3 SELECT evergreen.upgrade_deps_block_check('1189', :eg_version);
5 CREATE OR REPLACE VIEW action.open_circulation AS
7 FROM action.circulation
8 WHERE checkin_time IS NULL
11 CREATE OR REPLACE VIEW action.billable_circulations AS
13 FROM action.circulation
14 WHERE xact_finish IS NULL;
16 CREATE OR REPLACE VIEW reporter.overdue_circs AS
18 FROM "action".circulation
19 WHERE checkin_time is null
20 AND (stop_fines NOT IN ('LOST','CLAIMSRETURNED') OR stop_fines IS NULL)
23 CREATE OR REPLACE VIEW reporter.circ_type AS
25 CASE WHEN opac_renewal OR phone_renewal OR desk_renewal OR auto_renewal
29 FROM action.circulation;