APPS.OE_SCHEDULE_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 518: FROM mtl_system_items_vl

514: BEGIN
515:
516: SELECT concatenated_segments
517: INTO l_ordered_item
518: FROM mtl_system_items_vl
519: WHERE inventory_item_id = l_inventory_item_id
520: AND organization_id = l_ship_from_org_id;
521:
522: EXCEPTION

Line 870: FROM MTL_SYSTEM_ITEMS

866: x_return_status := FND_API.G_RET_STS_SUCCESS;
867:
868: SELECT RESERVABLE_TYPE
869: INTO l_reservable_type
870: FROM MTL_SYSTEM_ITEMS
871: WHERE INVENTORY_ITEM_ID = p_line_rec.inventory_item_id
872: AND ORGANIZATION_ID = p_line_rec.ship_from_org_id;
873:
874: IF l_reservable_type = 1 THEN

Line 887: FROM mtl_system_items

883: SELECT revision_qty_control_code, lot_control_code,
884: serial_number_control_code
885: INTO l_revision_code, l_lot_code,
886: l_serial_code
887: FROM mtl_system_items
888: WHERE inventory_item_id = p_line_rec.inventory_item_id
889: AND organization_id = p_line_rec.ship_from_org_id;
890:
891: EXCEPTION

Line 5835: FROM mtl_system_items msi

5831: END IF;
5832:
5833: SELECT msi.lot_control_code
5834: INTO l_lot_control_code
5835: FROM mtl_system_items msi
5836: WHERE msi.inventory_item_id = p_item_id
5837: AND msi.organization_id = nvl(p_org_id,l_org_id);
5838:
5839: IF l_lot_control_code = 2 THEN

Line 10011: FROM mtl_system_items

10007: BEGIN
10008:
10009: SELECT planning_make_buy_code
10010: INTO l_make_buy
10011: FROM mtl_system_items
10012: WHERE inventory_item_id = p_line_rec.inventory_item_id
10013: AND ORGANIZATION_ID = nvl(p_line_rec.ship_from_org_id,
10014: l_org_id);
10015:

Line 10983: FROM MTL_SYSTEM_ITEMS MSI

10979: , db_primary_uom_code
10980: , db_model_item_id
10981: , db_line_unit_code
10982: , primary_model_qty
10983: FROM MTL_SYSTEM_ITEMS MSI
10984: , OE_ORDER_LINES OL
10985: WHERE MSI.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID
10986: AND MSI.ORGANIZATION_ID = p_ship_from_org_id
10987: AND OL.LINE_ID = p_ato_line_id ;

Line 16036: FROM MTL_SYSTEM_ITEMS

16032: BEGIN
16033: BEGIN
16034: SELECT shippable_item_flag
16035: INTO l_shippable_flag
16036: FROM MTL_SYSTEM_ITEMS
16037: WHERE INVENTORY_ITEM_ID = p_new_inventory_item_id
16038: AND ORGANIZATION_ID = p_new_ship_from_org_id;
16039:
16040: IF l_shippable_flag <> p_old_shippable_flag THEN