APPS.CST_REVENUECOGSMATCH_PVT dependencies on CST_COGS_PCT_ADJ_EVENTS_TEMP

Line 2136: INSERT INTO cst_cogs_pct_adj_events_temp (

2132: -- This portion is for Revenue Recognition adjustment activity for the bug#6809034 remain untouched
2133: l_stmt_num := 90;
2134: debug(l_stmt_num);
2135: FORALL i IN l_cogs_om_line_id_tbl.FIRST..l_cogs_om_line_id_tbl.LAST
2136: INSERT INTO cst_cogs_pct_adj_events_temp (
2137: adj_event_id,
2138: adj_mmt_txn_id,
2139: adj_cogs_om_line_id,
2140: adj_event_date,

Line 2228: FROM cst_cogs_pct_adj_events_temp;

2224: p_request_id,
2225: p_pgm_app_id,
2226: p_pgm_id,
2227: sysdate
2228: FROM cst_cogs_pct_adj_events_temp;
2229:
2230: l_cce_count := l_cce_count + SQL%ROWCOUNT;
2231: debug(' l_cce_count : '|| l_cce_count);
2232: l_stmt_num := 110;

Line 2293: FROM cst_cogs_pct_adj_events_temp;

2289: adj_cogs_om_line_id,
2290: 1, -- Logical Txn
2291: adj_new_cogs_percentage
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:

Line 2376: cst_cogs_pct_adj_events_temp cba

2372: UPDATE (
2373: SELECT cce.prior_event_id,
2374: cba.adj_event_id
2375: FROM cst_cogs_events cce,
2376: cst_cogs_pct_adj_events_temp cba
2377: WHERE cce.event_id = cba.ftr_event_id)
2378: SET prior_event_id = adj_event_id;
2379:
2380: l_stmt_num := 180;

Line 2383: COMMIT; --also deletes from cst_cogs_pct_adj_events_temp;

2379:
2380: l_stmt_num := 180;
2381: debug(l_stmt_num);
2382:
2383: COMMIT; --also deletes from cst_cogs_pct_adj_events_temp;
2384: SAVEPOINT Create_CogsRecEvents_PVT;
2385:
2386: END LOOP mismatched_lines_loop; -- c_mismatched_lines bulk fetches
2387: