APPS.CST_REVENUECOGSMATCH_PVT dependencies on MTL_COGS_RECOGNITION_TEMP

Line 1182: INSERT INTO MTL_COGS_RECOGNITION_TEMP (

1178: l_stmt_num := 90;
1179: debug(l_stmt_num);
1180:
1181: -- Insert their quantity adjustments into MMT
1182: INSERT INTO MTL_COGS_RECOGNITION_TEMP (
1183: TRANSACTION_ID,
1184: LAST_UPDATE_DATE,
1185: LAST_UPDATED_BY,
1186: CREATION_DATE,

Line 2024: INSERT INTO mtl_cogs_recognition_temp (

2020: l_stmt_num := 70;
2021: debug(l_stmt_num);
2022: -- Insert MMT transactions into the global temp table
2023: FORALL i IN l_new_mmt_txn_id_tbl.FIRST .. l_new_mmt_txn_id_tbl.LAST
2024: INSERT INTO mtl_cogs_recognition_temp (
2025: TRANSACTION_ID,
2026: LAST_UPDATE_DATE,
2027: LAST_UPDATED_BY,
2028: CREATION_DATE,

Line 2236: INSERT INTO MTL_COGS_RECOGNITION_TEMP (

2232: l_stmt_num := 110;
2233: debug(l_stmt_num);
2234: -- Now create these events in Inventory's table
2235: -- Use the Inventory Temp Table for new MMT txns
2236: INSERT INTO MTL_COGS_RECOGNITION_TEMP (
2237: TRANSACTION_ID,
2238: LAST_UPDATE_DATE,
2239: LAST_UPDATED_BY,
2240: CREATION_DATE,

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

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:
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

Line 2310: UPDATE mtl_cogs_recognition_temp mcr

2306:
2307: l_stmt_num := 150;
2308: debug(l_stmt_num);
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,

Line 3238: INSERT INTO mtl_cogs_recognition_temp (

3234: -- Insert MMT event here (from one global temp table to another)
3235: l_stmt_num := 90;
3236: debug(l_stmt_num);
3237:
3238: INSERT INTO mtl_cogs_recognition_temp (
3239: TRANSACTION_ID,
3240: LAST_UPDATE_DATE,
3241: LAST_UPDATED_BY,
3242: CREATION_DATE,

Line 6508: FROM mtl_cogs_recognition_temp mmtt,

6504: ,oap.schedule_close_date
6505: ,oap2.acct_period_id
6506: ,oap2.open_flag
6507: ,mmtt.organization_id
6508: FROM mtl_cogs_recognition_temp mmtt,
6509: org_acct_periods oap,
6510: (SELECT period_start_date,
6511: schedule_close_date,
6512: acct_period_id,

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

6626: END IF;
6627: END LOOP;
6628:
6629: l_stmt_num := 3;
6630: debug(l_stmt_num||': UPDATING mtl_cogs_recognition_temp transaction_date and acct_period_id');
6631: FORALL i IN l_mmtt_rowid_tab.FIRST .. l_mmtt_rowid_tab.LAST
6632: UPDATE mtl_cogs_recognition_temp
6633: SET transaction_date = l_upd_transaction_date_tab(i)
6634: ,acct_period_id = l_upd_acct_period_id_tab(i)

Line 6632: UPDATE mtl_cogs_recognition_temp

6628:
6629: l_stmt_num := 3;
6630: debug(l_stmt_num||': UPDATING mtl_cogs_recognition_temp transaction_date and acct_period_id');
6631: FORALL i IN l_mmtt_rowid_tab.FIRST .. l_mmtt_rowid_tab.LAST
6632: UPDATE mtl_cogs_recognition_temp
6633: SET transaction_date = l_upd_transaction_date_tab(i)
6634: ,acct_period_id = l_upd_acct_period_id_tab(i)
6635: WHERE rowid = l_mmtt_rowid_tab(i);
6636: END LOOP;