APPS.AMS_PHYSICAL_FULFILLMENT_PUB dependencies on AMS_DELIVERABLES_ALL_B

Line 37: FROM ams_deliverables_all_b delv

33: -- the original kit.
34:
35: CURSOR cur_get_collateral_items(p_collateral_id NUMBER) IS
36: SELECT delv.INVENTORY_ITEM_ID
37: FROM ams_deliverables_all_b delv
38: WHERE delv.deliverable_id = p_collateral_id
39: UNION
40: SELECT delv.INVENTORY_ITEM_ID
41: FROM ams_deliverables_all_b delv,

Line 41: FROM ams_deliverables_all_b delv,

37: FROM ams_deliverables_all_b delv
38: WHERE delv.deliverable_id = p_collateral_id
39: UNION
40: SELECT delv.INVENTORY_ITEM_ID
41: FROM ams_deliverables_all_b delv,
42: mtl_system_items_b msi
43: WHERE delv.deliverable_id in (select deliverable_kit_part_id
44: FROM ams_deliv_kit_items
45: WHERE deliverable_kit_id = p_collateral_id)