APPS.CST_TPRICE_PVT dependencies on MTL_TRANSACTION_ACCOUNTS

Line 168: FROM mtl_transaction_accounts

164: (l_pd_txfr_ind = 1 AND (p_txn_act_id = 21 or p_txn_act_id = 22))
165: then
166: SELECT count(*), sum(base_transaction_value)
167: INTO l_rcv_count, l_rcv_sum
168: FROM mtl_transaction_accounts
169: WHERE transaction_id = p_txn_id
170: AND organization_id = l_from_org
171: AND accounting_line_type = 10;
172: end if;

Line 181: FROM mtl_transaction_accounts

177: (l_pd_txfr_ind = 1 AND (p_txn_act_id = 15 or p_txn_act_id = 12))
178: then
179: SELECT count(*), sum(base_transaction_value)
180: INTO l_pay_count, l_pay_sum
181: FROM mtl_transaction_accounts
182: WHERE transaction_id = p_txn_id
183: AND organization_id = l_to_org
184: AND accounting_line_type = 9;
185: end if;

Line 444: DELETE FROM mtl_transaction_accounts

440: * OPM INVCONV: Process/Discrete xfer
441: * -- Delete InterOrg Profit Account (LineType 34) also.
442: */
443:
444: DELETE FROM mtl_transaction_accounts
445: WHERE transaction_id = p_txn_id
446: AND accounting_line_type in (9,10,34);
447:
448: -- Second adjustment: debit elemental COGS for the sending org

Line 614: FROM mtl_transaction_accounts MTA

610: l_stmt_num := 260;
611:
612: SELECT -1.0*nvl(sum(MTA.base_transaction_value),0)
613: INTO l_prf
614: FROM mtl_transaction_accounts MTA
615: WHERE organization_id = l_to_org
616: AND transaction_id = p_txn_id;
617:
618: if (G_DEBUG = 'Y') then