APPS.CST_REVENUECOGSMATCH_PVT dependencies on MTL_SALES_ORDERS

Line 1422: mtl_sales_orders mso,

1418: ccqa.adj_rma_om_line_id, -- RMA Line ID
1419: 1, -- Logical Txn
1420: ccqa.adj_new_cogs_percentage
1421: FROM cst_cogs_qty_adj_events_temp ccqa,
1422: mtl_sales_orders mso,
1423: oe_order_lines_all ool,
1424: oe_order_headers_all ooh,
1425: oe_transaction_types_tl ott
1426: WHERE ool.line_id = ccqa.adj_cogs_om_line_id

Line 2345: -- sales_order_id from mtl_sales_orders.

2341: ,p_neg_req_id --BUG#7387575
2342: FROM cst_cogs_pct_adj_events_temp;
2343:
2344: -- Next update MTL_COGS_RECOGNITION_TEMP to populate transaction_source_id with the
2345: -- sales_order_id from mtl_sales_orders.
2346: -- Get the source code from the OE profile system parameter.
2347: -- It can be overridden by the user but most likely uses the default
2348: -- called 'ORDER ENTRY' and will most likely never change.
2349: l_stmt_num := 145;

Line 2361: FROM mtl_sales_orders mkts,

2357:
2358: UPDATE mtl_cogs_recognition_temp mcr
2359: SET (transaction_source_id, transaction_source_name) = (
2360: SELECT mkts.sales_order_id, mkts.segment1
2361: FROM mtl_sales_orders mkts,
2362: oe_order_lines_all ool,
2363: oe_order_headers_all ooh,
2364: oe_transaction_types_tl ott
2365: WHERE ool.line_id = mcr.trx_source_line_id

Line 3323: mtl_sales_orders mso,

3319: ccqa.adj_rma_om_line_id, -- RMA Line ID
3320: 1, -- Logical Txn
3321: ccqa.adj_new_cogs_percentage
3322: FROM cst_cogs_qty_adj_events_temp ccqa,
3323: mtl_sales_orders mso,
3324: oe_order_lines_all ool,
3325: oe_order_headers_all ooh,
3326: oe_transaction_types_tl ott
3327: WHERE ool.line_id = ccqa.adj_cogs_om_line_id