APPS.CSTPPINV dependencies on MTL_TRANSACTION_ACCOUNTS

Line 182: | Calculate the txn cost using data from mtl_transaction_accounts,

178: /*---------------------------------------------------------------------------
179: | Insert into mptcd if necessary.
180: | Five cases :
181: | - Interorg Accross CG with ownership change (group 1).
182: | Calculate the txn cost using data from mtl_transaction_accounts,
183: | , then insert that into mptcd elementally.
184: | - PO related txns (group 1 and i_txn_src_type_id = 1 and i_txn_action_id <> 6).
185: | Obtain the transaction cost from po table, then insert that into mptcd.
186: | i_txn_action_id of 6 is an ownership txfr, which has no acquisition cost.

Line 2047: FROM mtl_transaction_accounts mta

2043: to On-hand (either Inventory or Expense accounting line type). */
2044: BEGIN
2045: SELECT nvl(SUM(ABS(NVL(base_transaction_value, 0)))/abs(l_mta_txn_qty),0)
2046: INTO l_perp_ship_cost
2047: FROM mtl_transaction_accounts mta
2048: WHERE mta.transaction_id = i_mta_txn_id
2049: and mta.organization_id = i_from_org
2050: and mta.accounting_line_type IN (1,2)
2051: and mta.base_transaction_value < 0;

Line 2100: mtl_transaction_accounts mta

2096: i_prog_id,
2097: SYSDATE,
2098: i_login_id
2099: FROM
2100: mtl_transaction_accounts mta
2101: WHERE
2102: mta.transaction_id = i_mta_txn_id
2103: and mta.organization_id = i_from_org
2104: and mta.accounting_line_type IN (1,2)