APPS.AMS_PHYSICAL_FULFILLMENT_PUB dependencies on AMS_DELIV_KIT_ITEMS

Line 44: FROM ams_deliv_kit_items

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