DBA Data[Home] [Help]

APPS.JTF_FULFILLMENT_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 76: mtl_system_items_b msi

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

Line 96: FROM mtl_system_items_b msi

92: shipment_index number := 0;
93:
94: CURSOR cur_get_primary_uom (p_item_id NUMBER) IS
95: SELECT msi.primary_uom_code
96: FROM mtl_system_items_b msi
97: WHERE msi.inventory_item_id = p_item_id
98: AND msi.organization_id = p_order_header_rec.inv_organization_id;
99:
100: BEGIN