DBA Data[Home] [Help]

APPS.JTF_FULFILLMENT_PUB dependencies on AMS_DELIVERABLES_ALL_B

Line 71: FROM ams_deliverables_all_b delv

67: -- the original kit.
68:
69: CURSOR cur_get_collateral_items(p_collateral_id NUMBER) IS
70: SELECT delv.INVENTORY_ITEM_ID
71: FROM ams_deliverables_all_b delv
72: WHERE delv.deliverable_id = p_collateral_id
73: UNION
74: SELECT delv.INVENTORY_ITEM_ID
75: FROM ams_deliverables_all_b delv,

Line 75: FROM ams_deliverables_all_b delv,

71: FROM ams_deliverables_all_b delv
72: WHERE delv.deliverable_id = p_collateral_id
73: UNION
74: SELECT delv.INVENTORY_ITEM_ID
75: FROM ams_deliverables_all_b delv,
76: mtl_system_items_b msi
77: WHERE delv.deliverable_id in (select deliverable_kit_part_id
78: FROM ams_deliv_kit_items
79: WHERE deliverable_kit_id = p_collateral_id)