APPS.BOM_CONFIG_VALIDATION_PUB dependencies on OE_ORDER_LINES

Line 150: FROM oe_order_lines

146:
147: BEGIN
148: SELECT component_sequence_id, ordered_quantity
149: INTO l_top_bill_sequence_id, l_model_qty
150: FROM oe_order_lines
151: WHERE line_id = p_top_model_line_id;
152: EXCEPTION
153: WHEN OTHERS THEN
154: IF l_debug_level > 0 THEN

Line 310: FROM oe_order_lines

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

Line 350: FROM oe_order_lines

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

Line 455: FROM oe_order_lines

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

Line 458: FROM oe_order_lines

454: INTO l_open_flag
455: FROM oe_order_lines
456: where line_id =
457: (SELECT line_id
458: FROM oe_order_lines
459: WHERE top_model_line_id = p_top_model_line_id
460: AND component_code = SUBSTR(p_component_code, 1,
461: INSTR(p_component_code, '-', -1) - 1));
462:

Line 486: FROM oe_order_lines

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

Line 960: FROM OE_ORDER_LINES OECFG

956:
957: /*
958: CURSOR MANDATORY_COMPONENTS IS
959: SELECT bomexp.description, bomexp.component_code
960: FROM OE_ORDER_LINES OECFG
961: , BOM_EXPLOSIONS BOMEXP
962: WHERE OECFG.TOP_MODEL_LINE_ID = p_top_model_line_id
963: AND OECFG.SERVICE_REFERENCE_LINE_ID IS NULL
964: AND OECFG.ITEM_TYPE_CODE IN ( 'MODEL', 'CLASS' )

Line 978: FROM OE_ORDER_LINES OEOPT

974: LENGTH( RTRIM( BOMEXP.COMPONENT_CODE,
975: '0123456789' ) ) - 1 ) = OECFG.COMPONENT_CODE
976: AND NOT EXISTS (
977: SELECT NULL
978: FROM OE_ORDER_LINES OEOPT
979: WHERE OEOPT.TOP_MODEL_LINE_ID = p_top_model_line_id
980: AND OEOPT.SERVICE_REFERENCE_LINE_ID IS NULL
981: AND OEOPT.COMPONENT_CODE = BOMEXP.COMPONENT_CODE
982: )

Line 1267: FROM oe_order_lines

1263: BEGIN
1264:
1265: SELECT open_flag, ordered_quantity
1266: INTO l_open_flag, l_ordered_quantity
1267: FROM oe_order_lines
1268: where line_id =
1269: (SELECT line_id
1270: FROM oe_order_lines
1271: WHERE top_model_line_id = p_top_model_line_id

Line 1270: FROM oe_order_lines

1266: INTO l_open_flag, l_ordered_quantity
1267: FROM oe_order_lines
1268: where line_id =
1269: (SELECT line_id
1270: FROM oe_order_lines
1271: WHERE top_model_line_id = p_top_model_line_id
1272: AND component_code = SUBSTR(p_component_code, 1,
1273: INSTR(p_component_code, '-', -1) - 1));
1274:

Line 1293: FROM oe_order_lines

1289: END IF;
1290:
1291: SELECT ordered_item, line_number, shipment_number, option_number
1292: INTO l_ordered_item, l_line_number, l_shipment_number, l_option_number
1293: FROM oe_order_lines
1294: WHERE top_model_line_id = p_top_model_line_id
1295: AND component_code = p_component_code;
1296:
1297: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_NO_PARENT');