APPS.OE_CONFIG_VALIDATION_PVT dependencies on OE_ORDER_LINES

Line 152: FROM oe_order_lines

148: BEGIN
149: -- 4319370
150: SELECT component_sequence_id, ordered_quantity,ship_from_org_id
151: INTO l_top_bill_sequence_id, l_model_qty, G_Ship_From_Org_Id
152: FROM oe_order_lines
153: WHERE line_id = p_top_model_line_id;
154: EXCEPTION
155: WHEN OTHERS THEN
156: IF l_debug_level > 0 THEN

Line 312: FROM oe_order_lines

308: Print_Time('Check_Ratio_And_Parent start time');
309:
310: SELECT ordered_quantity
311: INTO l_parent_qty
312: FROM oe_order_lines
313: WHERE line_id = p_top_model_line_id;
314:
315: I := p_options_tbl.FIRST ;
316:

Line 352: FROM oe_order_lines

348: ('VALUE', p_options_tbl(I).ordered_quantity/l_parent_qty);
349:
350: SELECT ordered_item, item_type_code
351: INTO l_ordered_item, l_item_type_code
352: FROM oe_order_lines
353: WHERE line_id = p_top_model_line_id;
354:
355: FND_MESSAGE.Set_TOKEN('MODEL', l_ordered_item);
356: FND_MESSAGE.Set_TOKEN('PTYPECODE', l_item_type_code);

Line 457: FROM oe_order_lines_all /* MOAC_SQL_CHANGE */

453:
454: -- should not get more than 1 rows in all cases.
455: SELECT open_flag
456: INTO l_open_flag
457: FROM oe_order_lines_all /* MOAC_SQL_CHANGE */
458: where line_id =
459: (SELECT line_id
460: FROM oe_order_lines
461: WHERE top_model_line_id = p_top_model_line_id

Line 460: FROM oe_order_lines

456: INTO l_open_flag
457: FROM oe_order_lines_all /* MOAC_SQL_CHANGE */
458: where line_id =
459: (SELECT line_id
460: FROM oe_order_lines
461: WHERE top_model_line_id = p_top_model_line_id
462: AND component_code = SUBSTR(p_component_code, 1,
463: INSTR(p_component_code, '-', -1) - 1));
464:

Line 488: FROM oe_order_lines

484:
485: BEGIN
486: SELECT ordered_item, line_number, shipment_number, option_number
487: INTO l_ordered_item, l_line_number, l_shipment_number, l_option_number
488: FROM oe_order_lines
489: WHERE top_model_line_id = p_top_model_line_id
490: AND component_code = p_component_code;
491:
492: l_line := l_line_number || '.'|| l_shipment_number ||'.'|| l_option_number;

Line 969: FROM OE_ORDER_LINES OECFG

965:
966: /*
967: CURSOR MANDATORY_COMPONENTS IS
968: SELECT bomexp.description, bomexp.component_code
969: FROM OE_ORDER_LINES OECFG
970: , BOM_EXPLOSIONS BOMEXP
971: WHERE OECFG.TOP_MODEL_LINE_ID = p_top_model_line_id
972: AND OECFG.SERVICE_REFERENCE_LINE_ID IS NULL
973: AND OECFG.ITEM_TYPE_CODE IN ( 'MODEL', 'CLASS' )

Line 987: FROM OE_ORDER_LINES OEOPT

983: LENGTH( RTRIM( BOMEXP.COMPONENT_CODE,
984: '0123456789' ) ) - 1 ) = OECFG.COMPONENT_CODE
985: AND NOT EXISTS (
986: SELECT NULL
987: FROM OE_ORDER_LINES OEOPT
988: WHERE OEOPT.TOP_MODEL_LINE_ID = p_top_model_line_id
989: AND OEOPT.SERVICE_REFERENCE_LINE_ID IS NULL
990: AND OEOPT.COMPONENT_CODE = BOMEXP.COMPONENT_CODE
991: )

Line 1276: FROM oe_order_lines_all /* MOAC_SQL_CHANGE */

1272: BEGIN
1273:
1274: SELECT open_flag, ordered_quantity
1275: INTO l_open_flag, l_ordered_quantity
1276: FROM oe_order_lines_all /* MOAC_SQL_CHANGE */
1277: where line_id =
1278: (SELECT line_id
1279: FROM oe_order_lines
1280: WHERE top_model_line_id = p_top_model_line_id

Line 1279: FROM oe_order_lines

1275: INTO l_open_flag, l_ordered_quantity
1276: FROM oe_order_lines_all /* MOAC_SQL_CHANGE */
1277: where line_id =
1278: (SELECT line_id
1279: FROM oe_order_lines
1280: WHERE top_model_line_id = p_top_model_line_id
1281: AND component_code = SUBSTR(p_component_code, 1,
1282: INSTR(p_component_code, '-', -1) - 1));
1283:

Line 1302: FROM oe_order_lines

1298: END IF;
1299:
1300: SELECT ordered_item, line_number, shipment_number, option_number
1301: INTO l_ordered_item, l_line_number, l_shipment_number, l_option_number
1302: FROM oe_order_lines
1303: WHERE top_model_line_id = p_top_model_line_id
1304: AND component_code = p_component_code;
1305:
1306: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_NO_PARENT');