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.CSTPAPBR dependencies on MTL_TRANSACTION_ACCOUNTS

Line 2828: FROM mtl_transaction_accounts mta

2824:
2825: BEGIN
2826: SELECT nvl(SUM(ABS(NVL(base_transaction_value, 0))),0)
2827: INTO l_perp_ship_value
2828: FROM mtl_transaction_accounts mta
2829: WHERE mta.transaction_id = i_ae_txn_rec.transaction_id
2830: and mta.organization_id = i_ae_txn_rec.organization_id
2831: and mta.accounting_line_type IN (1,2,14)
2832: and mta.base_transaction_value < 0;

Line 3849: FROM mtl_transaction_accounts mta

3845:
3846: BEGIN
3847: SELECT nvl(SUM(ABS(NVL(base_transaction_value, 0))),0)
3848: INTO l_perp_ship_value
3849: FROM mtl_transaction_accounts mta
3850: WHERE mta.transaction_id = i_ae_txn_rec.transaction_id
3851: and mta.organization_id = i_ae_txn_rec.organization_id
3852: and mta.accounting_line_type IN (1,2,14)
3853: and mta.base_transaction_value < 0;

Line 4977: FROM mtl_transaction_accounts mta

4973:
4974: BEGIN
4975: SELECT nvl(SUM(ABS(NVL(base_transaction_value, 0))),0)
4976: INTO l_perp_ship_value
4977: FROM mtl_transaction_accounts mta
4978: WHERE mta.transaction_id = l_txfr_txn_id
4979: and mta.organization_id = i_ae_txn_rec.xfer_organization_id
4980: and mta.accounting_line_type IN (1,2,14)
4981: and mta.base_transaction_value < 0;

Line 10407: FROM mtl_transaction_accounts mta

10403: l_stmt_num := 220;
10404:
10405: SELECT nvl(SUM(ABS(NVL(base_transaction_value, 0))),0)
10406: INTO o_perp_ship_value
10407: FROM mtl_transaction_accounts mta
10408: WHERE mta.transaction_id = i_ae_txn_rec.transaction_id
10409: and mta.organization_id = i_ae_txn_rec.organization_id
10410: and mta.accounting_line_type IN (1,2,14)
10411: and mta.base_transaction_value > 0;

Line 10419: FROM mtl_transaction_accounts mta

10415: l_stmt_num := 230;
10416:
10417: SELECT nvl(SUM(ABS(NVL(base_transaction_value, 0))),0)
10418: INTO o_perp_ship_value
10419: FROM mtl_transaction_accounts mta
10420: WHERE mta.transaction_id = i_ae_txn_rec.transaction_id
10421: and mta.organization_id = i_ae_txn_rec.organization_id
10422: and mta.accounting_line_type IN (1,2,14)
10423: and mta.base_transaction_value < 0;