APPS.OE_INV_IFACE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 200: FROM MTL_SYSTEM_ITEMS

196:
197:
198: SELECT MTL_TRANSACTIONS_ENABLED_FLAG
199: INTO l_transactable_flag
200: FROM MTL_SYSTEM_ITEMS
201: WHERE inventory_item_id = l_line_rec.inventory_item_id
202: AND organization_id = l_line_rec.ship_from_org_id;
203:
204: IF l_line_rec.shippable_flag = 'Y' THEN

Line 295: FROM mtl_system_items

291: -- if item is under lot/serial/revision control
292: BEGIN
293: SELECT revision_qty_control_code, lot_control_code, serial_number_control_code
294: INTO l_revision_code, l_lot_code, l_serial_code
295: FROM mtl_system_items
296: WHERE inventory_item_id = l_line_rec.inventory_item_id
297: AND organization_id = l_line_rec.ship_from_org_id;
298: EXCEPTION
299: WHEN OTHERS THEN

Line 607: FROM mtl_system_items

603:
604: BEGIN
605: SELECT location_control_code
606: INTO l_location_control_code
607: FROM mtl_system_items
608: WHERE inventory_item_id = l_line_rec.inventory_item_id
609: AND organization_id = l_line_rec.ship_from_org_id;
610: EXCEPTION
611: WHEN OTHERS THEN

Line 1069: FROM mtl_system_items

1065:
1066: BEGIN
1067: SELECT location_control_code
1068: INTO l_location_control_code
1069: FROM mtl_system_items
1070: WHERE inventory_item_id = l_line_rec.inventory_item_id
1071: AND organization_id = l_line_rec.ship_from_org_id;
1072: -- ???? warehouse or validation org?
1073: EXCEPTION