DBA Data[Home] [Help]

APPS.CSTPLVCP dependencies on OE_ORDER_LINES_ALL

Line 383: oe_order_lines_all OOLA

379: l_stmt_num := 72;
380: SELECT MIN(OOLA.reference_line_id)
381: INTO l_so_line_id
382: FROM mtl_material_transactions MMT,
383: oe_order_lines_all OOLA
384: WHERE MMT.transaction_id = i_txn_id
385: AND OOLA.line_id = MMT.trx_source_line_id;
386:
387: IF l_so_line_id IS NOT NULL THEN

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

419: i_req_id,
420: i_prg_appl_id,
421: i_prg_id,
422: SYSDATE
423: FROM oe_order_lines_all OOLA, /*BUG 5768680 Changes introduced to improve performance*/
424: oe_order_headers_all OOHA, /* of the layer cost worker*/
425: mtl_sales_orders MSO,
426: mtl_material_transactions MMT,
427: mtl_cst_actual_cost_details MCACD,

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

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