3 SELECT evergreen.upgrade_deps_block_check('1032', :eg_version); -- Bmagic/csharp/gmcharlt
5 CREATE OR REPLACE VIEW action.all_circulation_combined_types AS
11 ac_acirc.circ_modifier AS item_type,
12 'regular_circ'::text AS circ_type
13 FROM action.circulation acirc,
15 WHERE acirc.target_copy = ac_acirc.id
17 SELECT ancc.id::BIGINT AS id,
18 ancc.circ_time AS xact_start,
20 ancc.staff AS circ_staff,
21 ancc.circ_time AS create_time,
22 cnct_ancc.name AS item_type,
23 'non-cat_circ'::text AS circ_type
24 FROM action.non_cataloged_circulation ancc,
25 config.non_cataloged_type cnct_ancc
26 WHERE ancc.item_type = cnct_ancc.id
28 SELECT aihu.id::BIGINT AS id,
29 aihu.use_time AS xact_start,
30 aihu.org_unit AS circ_lib,
31 aihu.staff AS circ_staff,
32 aihu.use_time AS create_time,
33 ac_aihu.circ_modifier AS item_type,
34 'in-house_use'::text AS circ_type
35 FROM action.in_house_use aihu,
37 WHERE aihu.item = ac_aihu.id
39 SELECT ancihu.id::BIGINT AS id,
40 ancihu.use_time AS xact_start,
41 ancihu.org_unit AS circ_lib,
42 ancihu.staff AS circ_staff,
43 ancihu.use_time AS create_time,
44 cnct_ancihu.name AS item_type,
45 'non-cat_circ'::text AS circ_type
46 FROM action.non_cat_in_house_use ancihu,
47 config.non_cataloged_type cnct_ancihu
48 WHERE ancihu.item_type = cnct_ancihu.id
50 SELECT aacirc.id AS id,
55 ac_aacirc.circ_modifier AS item_type,
56 'aged_circ'::text AS circ_type
57 FROM action.aged_circulation aacirc,
59 WHERE aacirc.target_copy = ac_aacirc.id;