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'