DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on MTL_SALES_ORDERS

Line 1241: mtl_sales_orders mso,

1237: ccqa.adj_rma_om_line_id, -- RMA Line ID
1238: 1, -- Logical Txn
1239: ccqa.adj_new_cogs_percentage
1240: FROM cst_cogs_qty_adj_events_temp ccqa,
1241: mtl_sales_orders mso,
1242: oe_order_lines_all ool,
1243: oe_order_headers_all ooh,
1244: oe_transaction_types_tl ott
1245: WHERE ool.line_id = ccqa.adj_cogs_om_line_id

Line 2296: -- sales_order_id from mtl_sales_orders.

2292: ,p_neg_req_id --BUG#7387575
2293: FROM cst_cogs_pct_adj_events_temp;
2294:
2295: -- Next update MTL_COGS_RECOGNITION_TEMP to populate transaction_source_id with the
2296: -- sales_order_id from mtl_sales_orders.
2297:
2298: -- Get the source code from the OE profile system parameter.
2299: -- It can be overridden by the user but most likely uses the default
2300: -- called 'ORDER ENTRY' and will most likely never change.

Line 2313: FROM mtl_sales_orders mkts,

2309:
2310: UPDATE mtl_cogs_recognition_temp mcr
2311: SET (transaction_source_id) = (
2312: SELECT mkts.sales_order_id
2313: FROM mtl_sales_orders mkts,
2314: oe_order_lines_all ool,
2315: oe_order_headers_all ooh,
2316: oe_transaction_types_tl ott
2317: WHERE ool.line_id = mcr.trx_source_line_id

Line 3297: mtl_sales_orders mso,

3293: ccqa.adj_rma_om_line_id, -- RMA Line ID
3294: 1, -- Logical Txn
3295: ccqa.adj_new_cogs_percentage
3296: FROM cst_cogs_qty_adj_events_temp ccqa,
3297: mtl_sales_orders mso,
3298: oe_order_lines_all ool,
3299: oe_order_headers_all ooh,
3300: oe_transaction_types_tl ott
3301: WHERE ool.line_id = ccqa.adj_cogs_om_line_id