APPS.OE_GRP_SCH_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 383: FROM mtl_system_items

379: BEGIN
380:
381: SELECT planning_make_buy_code
382: INTO l_make_buy
383: FROM mtl_system_items
384: WHERE inventory_item_id = p_line_rec.inventory_item_id
385: AND ORGANIZATION_ID = nvl(p_line_rec.ship_from_org_id,
386: l_org_id);
387:

Line 3210: FROM MTL_SYSTEM_ITEMS

3206: AND l_line_tbl(j).Item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
3207:
3208: SELECT RESERVABLE_TYPE
3209: INTO l_reservable_type
3210: FROM MTL_SYSTEM_ITEMS
3211: WHERE INVENTORY_ITEM_ID = l_line_tbl(j).inventory_item_id
3212: AND ORGANIZATION_ID = l_line_tbl(j).ship_from_org_id;
3213:
3214: IF l_reservable_type = 1 THEN

Line 3247: FROM mtl_system_items

3243: BEGIN
3244: SELECT revision_qty_control_code, lot_control_code,
3245: serial_number_control_code
3246: INTO l_revision_code, l_lot_code, l_serial_code
3247: FROM mtl_system_items
3248: WHERE inventory_item_id = l_line_tbl(j).inventory_item_id
3249: AND organization_id = l_line_tbl(j).ship_from_org_id;
3250:
3251: EXCEPTION

Line 3886: FROM MTL_SYSTEM_ITEMS

3882: l_line_number := p_line_tbl(I).line_number;
3883:
3884: SELECT 'VALID'
3885: INTO l_dummy
3886: FROM MTL_SYSTEM_ITEMS
3887: WHERE INVENTORY_ITEM_ID = p_line_tbl(I).inventory_item_id
3888: AND ORGANIZATION_ID = p_ship_from_org_id;
3889:
3890: END LOOP;