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 487: FROM oe_order_lines_all OOLA, /*BUG 5768680 Changes introduced to improve performance*/

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

Line 9476: OE_ORDER_LINES_ALL oel,

9472: oel.SOURCE_DOCUMENT_LINE_ID
9473: INTO
9474: l_req_line_id
9475: FROM
9476: OE_ORDER_LINES_ALL oel,
9477: cst_acct_info_v caiv
9478: WHERE
9479: oel.LINE_ID = l_trx_source_line_id
9480: and oel.org_id = caiv.operating_unit