APPS.AMS_PHYSICAL_FULFILLMENT_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 42: mtl_system_items_b msi

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)
46: AND delv.inventory_item_id is not null

Line 62: FROM mtl_system_items_b msi

58: shipment_index number := 0;
59:
60: CURSOR cur_get_primary_uom (p_item_id NUMBER) IS
61: SELECT msi.primary_uom_code
62: FROM mtl_system_items_b msi
63: WHERE msi.inventory_item_id = p_item_id
64: AND msi.organization_id = p_order_header_rec.inv_organization_id;
65:
66: BEGIN