eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPPACQ dependencies on MTL_PAC_TXN_COST_DETAILS

Line 1478: Delete from mtl_pac_txn_cost_details mptcd

1474:
1475: FOR c_rec IN c_lcm_adj(l_start_date,l_end_date) LOOP
1476: l_recs_processed := l_recs_processed + 1;
1477: l_stmt_num := 1100;
1478: Delete from mtl_pac_txn_cost_details mptcd
1479: where mptcd.transaction_id IN ( SELECT mmt.transaction_id
1480: FROM mtl_material_transactions mmt,
1481: cst_rcv_acq_costs_adj craca
1482: WHERE mmt.rcv_transaction_id

Line 2093: Insert into mtl_pac_txn_cost_details

2089: );
2090:
2091: /* insert into MPTCD */
2092: l_stmt_num := 1280;
2093: Insert into mtl_pac_txn_cost_details
2094: (cost_group_id,
2095: transaction_id,
2096: pac_period_id,
2097: cost_type_id,

Line 2373: Delete from mtl_pac_txn_cost_details mptcd

2369: -- Delete from MMT and MPTCD transactions that were created for the
2370: -- previous run for this receipt and then delete from craca and cracda*/
2371:
2372: l_stmt_num := 71;
2373: Delete from mtl_pac_txn_cost_details mptcd
2374: where mptcd.transaction_id IN ( select craca.mmt_transaction_id
2375: from cst_rcv_acq_costs_adj craca
2376: where craca.mmt_transaction_id is not null
2377: and craca.period_id = i_period

Line 4580: Insert into mtl_pac_txn_cost_details

4576:
4577: /* insert into MPTCD */
4578:
4579: l_stmt_num := 80;
4580: Insert into mtl_pac_txn_cost_details
4581: (cost_group_id,
4582: transaction_id,
4583: pac_period_id,
4584: cost_type_id,