APPS.OE_INV_IFACE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 213: FROM MTL_SYSTEM_ITEMS

209:
210:
211: SELECT MTL_TRANSACTIONS_ENABLED_FLAG
212: INTO l_transactable_flag
213: FROM MTL_SYSTEM_ITEMS
214: WHERE inventory_item_id = l_line_rec.inventory_item_id
215: AND organization_id = l_line_rec.ship_from_org_id;
216:
217: IF l_line_rec.shippable_flag = 'Y' THEN

Line 308: FROM mtl_system_items

304: -- if item is under lot/serial/revision control
305: BEGIN
306: SELECT revision_qty_control_code, lot_control_code, serial_number_control_code
307: INTO l_revision_code, l_lot_code, l_serial_code
308: FROM mtl_system_items
309: WHERE inventory_item_id = l_line_rec.inventory_item_id
310: AND organization_id = l_line_rec.ship_from_org_id;
311: EXCEPTION
312: WHEN OTHERS THEN

Line 460: FROM mtl_system_items_b

456: -- Check if actually its a partial reservation or the difference is due to the precesion.
457: BEGIN
458: SELECT primary_uom_code
459: INTO l_primary_uom
460: FROM mtl_system_items_b
461: WHERE inventory_item_id = l_line_rec.inventory_item_id
462: AND organization_id = l_line_rec.ship_from_org_id;
463: EXCEPTION
464: WHEN OTHERS THEN

Line 700: FROM mtl_system_items

696:
697: BEGIN
698: SELECT location_control_code
699: INTO l_location_control_code
700: FROM mtl_system_items
701: WHERE inventory_item_id = l_line_rec.inventory_item_id
702: AND organization_id = l_line_rec.ship_from_org_id;
703: EXCEPTION
704: WHEN OTHERS THEN

Line 1243: FROM mtl_system_items

1239:
1240: BEGIN
1241: SELECT location_control_code
1242: INTO l_location_control_code
1243: FROM mtl_system_items
1244: WHERE inventory_item_id = l_line_rec.inventory_item_id
1245: AND organization_id = l_line_rec.ship_from_org_id;
1246: -- ???? warehouse or validation org?
1247: EXCEPTION