4 INSERT INTO action.hold_transit_copy (dest, source, source_send_time, target_copy, copy_status, hold)
7 l.transit_date AS source_send_time,
12 JOIN action.hold_request h ON (l.hold_key = h.id)
13 JOIN legacy_item li USING (cat_key, call_key, item_key)
14 JOIN asset.copy cp ON (li.item_id = cp.barcode)
15 JOIN actor.org_unit dou ON (l.destination_lib = dou.shortname)
16 JOIN actor.org_unit sou ON (l.starting_lib = sou.shortname)
20 INSERT INTO action.transit_copy (dest, source, source_send_time, target_copy, copy_status)
21 SELECT dou.id AS dest,
23 l.transit_date AS source_send_time,
27 JOIN legacy_item li USING (cat_key, call_key, item_key)
28 JOIN asset.copy cp ON (li.item_id = cp.barcode)
29 JOIN actor.org_unit dou ON (l.destination_lib = dou.shortname)
30 JOIN actor.org_unit sou ON (l.starting_lib = sou.shortname)