APPS.OE_ORDER_SCH_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 3164: FROM mtl_system_items

3160: BEGIN
3161:
3162: SELECT planning_make_buy_code
3163: INTO l_make_buy
3164: FROM mtl_system_items
3165: WHERE inventory_item_id = p_line_rec.inventory_item_id
3166: AND ORGANIZATION_ID = nvl(p_line_rec.ship_from_org_id,
3167: l_org_id);
3168:

Line 3352: FROM mtl_system_items msi

3348: END IF;
3349:
3350: SELECT msi.lot_control_code
3351: INTO l_lot_control_code
3352: FROM mtl_system_items msi
3353: WHERE msi.inventory_item_id = p_item_id
3354: AND msi.organization_id = nvl(p_org_id,l_org_id);
3355:
3356: IF l_lot_control_code = 2 THEN

Line 3763: FROM MTL_SYSTEM_ITEMS

3759:
3760: IF p_action <> OESCH_ACT_RESERVE THEN
3761: SELECT RESERVABLE_TYPE
3762: INTO l_reservable_type
3763: FROM MTL_SYSTEM_ITEMS
3764: WHERE INVENTORY_ITEM_ID = l_line_rec.inventory_item_id
3765: AND ORGANIZATION_ID = l_line_rec.ship_from_org_id;
3766:
3767: IF l_reservable_type <> 1 THEN

Line 3788: FROM mtl_system_items

3784: BEGIN
3785: SELECT revision_qty_control_code, lot_control_code,
3786: serial_number_control_code
3787: INTO l_revision_code, l_lot_code, l_serial_code
3788: FROM mtl_system_items
3789: WHERE inventory_item_id = l_line_rec.inventory_item_id
3790: AND organization_id = l_line_rec.ship_from_org_id;
3791:
3792: EXCEPTION

Line 4624: FROM MTL_SYSTEM_ITEMS

4620: -- Load the INV record
4621:
4622: SELECT RESERVABLE_TYPE
4623: INTO l_reservable_type
4624: FROM MTL_SYSTEM_ITEMS
4625: WHERE INVENTORY_ITEM_ID = l_line_rec.inventory_item_id
4626: AND ORGANIZATION_ID = l_line_rec.ship_from_org_id;
4627:
4628: IF l_reservable_type <> 1 THEN

Line 4643: FROM mtl_system_items

4639: BEGIN
4640: SELECT revision_qty_control_code, lot_control_code,
4641: serial_number_control_code
4642: INTO l_revision_code, l_lot_code, l_serial_code
4643: FROM mtl_system_items
4644: WHERE inventory_item_id = l_line_rec.inventory_item_id
4645: AND organization_id = l_line_rec.ship_from_org_id;
4646:
4647: EXCEPTION

Line 5642: FROM MTL_SYSTEM_ITEMS MSI

5638: , db_primary_uom_code
5639: , db_model_item_id
5640: , db_line_unit_code
5641: , primary_model_qty
5642: FROM MTL_SYSTEM_ITEMS MSI
5643: , OE_ORDER_LINES OL
5644: WHERE MSI.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID
5645: AND MSI.ORGANIZATION_ID = p_ship_from_org_id
5646: AND OL.LINE_ID = p_ato_line_id ;

Line 9949: FROM mtl_system_items_vl

9945: BEGIN
9946:
9947: SELECT concatenated_segments
9948: INTO l_ordered_item
9949: FROM mtl_system_items_vl
9950: WHERE inventory_item_id = l_inventory_item_id
9951: AND organization_id = l_ship_from_org_id;
9952:
9953: EXCEPTION