APPS.CST_REVENUECOGSMATCH_PVT dependencies on MTL_COGS_RECOGNITION_TEMP

Line 1361: INSERT INTO MTL_COGS_RECOGNITION_TEMP (

1357: l_stmt_num := 90;
1358: debug(l_stmt_num);
1359:
1360: -- Insert their quantity adjustments into MMT
1361: INSERT INTO MTL_COGS_RECOGNITION_TEMP (
1362: TRANSACTION_ID,
1363: LAST_UPDATE_DATE,
1364: LAST_UPDATED_BY,
1365: CREATION_DATE,

Line 2089: INSERT INTO mtl_cogs_recognition_temp (

2085: l_stmt_num := 70;
2086: debug(l_stmt_num);
2087: -- Insert MMT transactions into the global temp table
2088: FORALL i IN l_new_mmt_txn_id_tbl.FIRST .. l_new_mmt_txn_id_tbl.LAST
2089: INSERT INTO mtl_cogs_recognition_temp (
2090: TRANSACTION_ID,
2091: LAST_UPDATE_DATE,
2092: LAST_UPDATED_BY,
2093: CREATION_DATE,

Line 2285: INSERT INTO MTL_COGS_RECOGNITION_TEMP (

2281: l_stmt_num := 110;
2282: debug(l_stmt_num);
2283: -- Now create these events in Inventory's table
2284: -- Use the Inventory Temp Table for new MMT txns
2285: INSERT INTO MTL_COGS_RECOGNITION_TEMP (
2286: TRANSACTION_ID,
2287: LAST_UPDATE_DATE,
2288: LAST_UPDATED_BY,
2289: CREATION_DATE,

Line 2344: -- Next update MTL_COGS_RECOGNITION_TEMP to populate transaction_source_id with the

2340: adj_new_cogs_percentage
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.

Line 2358: UPDATE mtl_cogs_recognition_temp mcr

2354:
2355: l_stmt_num := 150;
2356: debug(l_stmt_num);
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,

Line 3262: INSERT INTO mtl_cogs_recognition_temp (

3258: -- Insert MMT event here (from one global temp table to another)
3259: l_stmt_num := 90;
3260: debug(l_stmt_num);
3261:
3262: INSERT INTO mtl_cogs_recognition_temp (
3263: TRANSACTION_ID,
3264: LAST_UPDATE_DATE,
3265: LAST_UPDATED_BY,
3266: CREATION_DATE,

Line 3367: DELETE FROM mtl_cogs_recognition_temp;

3363: --{BUG#12532039
3364: DELETE FROM cst_cogs_qty_adj_events_temp;
3365: --}
3366: --{BUG#13712426
3367: DELETE FROM mtl_cogs_recognition_temp;
3368: --}
3369:
3370: -- Set the value of the return paramter
3371: x_cogs_percentage := l_cogs_percentage;

Line 6853: FROM mtl_cogs_recognition_temp mmtt,

6849: ,oap.schedule_close_date
6850: ,oap2.acct_period_id
6851: ,oap2.open_flag
6852: ,mmtt.organization_id
6853: FROM mtl_cogs_recognition_temp mmtt,
6854: org_acct_periods oap,
6855: (SELECT period_start_date,
6856: schedule_close_date,
6857: acct_period_id,

Line 6974: debug(l_stmt_num||': UPDATING mtl_cogs_recognition_temp transaction_date and acct_period_id');

6970: END IF;
6971: END LOOP;
6972:
6973: l_stmt_num := 3;
6974: debug(l_stmt_num||': UPDATING mtl_cogs_recognition_temp transaction_date and acct_period_id');
6975: FORALL i IN l_mmtt_rowid_tab.FIRST .. l_mmtt_rowid_tab.LAST
6976: UPDATE mtl_cogs_recognition_temp
6977: SET transaction_date = l_upd_transaction_date_tab(i)
6978: ,acct_period_id = l_upd_acct_period_id_tab(i)

Line 6976: UPDATE mtl_cogs_recognition_temp

6972:
6973: l_stmt_num := 3;
6974: debug(l_stmt_num||': UPDATING mtl_cogs_recognition_temp transaction_date and acct_period_id');
6975: FORALL i IN l_mmtt_rowid_tab.FIRST .. l_mmtt_rowid_tab.LAST
6976: UPDATE mtl_cogs_recognition_temp
6977: SET transaction_date = l_upd_transaction_date_tab(i)
6978: ,acct_period_id = l_upd_acct_period_id_tab(i)
6979: WHERE rowid = l_mmtt_rowid_tab(i);
6980: END LOOP;