APPS.CST_REVENUECOGSMATCH_PVT dependencies on CST_COGS_QTY_ADJ_EVENTS_TEMP

Line 1242: INSERT INTO cst_cogs_qty_adj_events_temp (

1238:
1239: l_stmt_num := 60;
1240: debug(l_stmt_num);
1241: FORALL i IN l_cogs_om_line_id_tbl.FIRST..l_cogs_om_line_id_tbl.LAST
1242: INSERT INTO cst_cogs_qty_adj_events_temp (
1243: adj_event_id,
1244: adj_mmt_txn_id,
1245: adj_cogs_om_line_id,
1246: adj_rma_om_line_id,

Line 1346: FROM cst_cogs_qty_adj_events_temp;

1342: p_request_id,
1343: p_pgm_app_id,
1344: p_pgm_id,
1345: sysdate
1346: FROM cst_cogs_qty_adj_events_temp;
1347:
1348: -- Get the source code from the OE profile system parameter.
1349: -- It can be overridden by the user but most likely uses the default
1350: -- called 'ORDER ENTRY' and will most likely never change.

Line 1421: FROM cst_cogs_qty_adj_events_temp ccqa,

1417: ccqa.adj_cogs_om_line_id,
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

Line 1461: commit; --delete from cst_cogs_qty_adj_events_temp;

1457: END IF;
1458:
1459: l_stmt_num := 90;
1460: debug(l_stmt_num);
1461: commit; --delete from cst_cogs_qty_adj_events_temp;
1462: SAVEPOINT Insert_RmaReceipts_PVT;
1463:
1464: END LOOP all_rma_receipts_loop;
1465:

Line 3145: INSERT INTO cst_cogs_qty_adj_events_temp (

3141: -- Now create quantity adjustment events for all future COGS Rec events
3142: -- This is a 2 step process, first insert into the global temp table
3143: l_stmt_num := 60;
3144: debug(l_stmt_num);
3145: INSERT INTO cst_cogs_qty_adj_events_temp (
3146: adj_event_id,
3147: adj_mmt_txn_id,
3148: adj_cogs_om_line_id,
3149: adj_rma_om_line_id,

Line 3248: FROM cst_cogs_qty_adj_events_temp;

3244: p_request_id,
3245: p_pgm_app_id,
3246: p_pgm_id,
3247: sysdate
3248: FROM cst_cogs_qty_adj_events_temp;
3249:
3250: -- Get the source code from the OE profile system parameter.
3251: -- It can be overridden by the user but most likely uses the default
3252: -- called 'ORDER ENTRY' and will most likely never change.

Line 3322: FROM cst_cogs_qty_adj_events_temp ccqa,

3318: ccqa.adj_cogs_om_line_id,
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

Line 3364: DELETE FROM cst_cogs_qty_adj_events_temp;

3360: raise program_exception;
3361: END IF;
3362:
3363: --{BUG#12532039
3364: DELETE FROM cst_cogs_qty_adj_events_temp;
3365: --}
3366: --{BUG#13712426
3367: DELETE FROM mtl_cogs_recognition_temp;
3368: --}