APPS.JTF_FULFILLMENT_PUB dependencies on AMS_DELIV_KIT_ITEMS

Line 78: FROM ams_deliv_kit_items

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)
80: AND delv.inventory_item_id is not null
81: AND nvl(delv.kit_flag,'N')='N'
82: AND delv.status_code='AVAILABLE'