3 INSERT INTO config.upgrade_log (version) VALUES ('0419'); -- miker
5 CREATE OR REPLACE VIEW reporter.hold_request_record AS
13 THEN (SELECT ssub.record_entry FROM serial.subscription ssub JOIN serial.issuance si ON (si.subscription = ssub.id) WHERE si.id = ahr.target)
15 THEN (SELECT cn.record FROM asset.call_number cn WHERE cn.id = ahr.target)
16 WHEN hold_type IN ('C','R','F')
17 THEN (SELECT cn.record FROM asset.call_number cn JOIN asset.copy cp ON (cn.id = cp.call_number) WHERE cp.id = ahr.target)
19 THEN (SELECT mr.master_record FROM metabib.metarecord mr WHERE mr.id = ahr.target)
21 FROM action.hold_request ahr;