APPS.CSTPAVCP dependencies on OE_ORDER_LINES_ALL

Line 447: oe_order_lines_all OOLA

443: l_stmt_num := 83;
444: SELECT MIN(OOLA.reference_line_id)
445: INTO l_so_line_id
446: FROM mtl_material_transactions MMT,
447: oe_order_lines_all OOLA
448: WHERE MMT.transaction_id = i_txn_id
449: AND OOLA.line_id = MMT.trx_source_line_id;
450:
451: IF l_so_line_id IS NOT NULL THEN

Line 490: FROM oe_order_lines_all OOLA, /*BUG 5768680 Changes introduced to improve performance*/

486: i_req_id,
487: i_prg_appl_id,
488: i_prg_id,
489: SYSDATE
490: FROM oe_order_lines_all OOLA, /*BUG 5768680 Changes introduced to improve performance*/
491: oe_order_headers_all OOHA, /* of the layer cost worker*/
492: mtl_sales_orders MSO,
493: mtl_material_transactions MMT,
494: mtl_cst_actual_cost_details MCACD,

Line 556: FROM oe_order_lines_all OOLA, /*BUG 5768680 Changes introduced to improve performance*/

552: i_req_id,
553: i_prg_appl_id,
554: i_prg_id,
555: SYSDATE
556: FROM oe_order_lines_all OOLA, /*BUG 5768680 Changes introduced to improve performance*/
557: oe_order_headers_all OOHA, /* of the layer cost worker*/
558: mtl_sales_orders MSO,
559: mtl_material_transactions MMT,
560: mtl_cst_actual_cost_details MCACD

Line 9673: OE_ORDER_LINES_ALL oel,

9669: oel.SOURCE_DOCUMENT_LINE_ID
9670: INTO
9671: l_req_line_id
9672: FROM
9673: OE_ORDER_LINES_ALL oel,
9674: cst_acct_info_v caiv
9675: WHERE
9676: oel.LINE_ID = l_trx_source_line_id
9677: and oel.org_id = caiv.operating_unit