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 3110: FROM mtl_transaction_accounts mta

3106:
3107: BEGIN
3108: SELECT nvl(SUM(ABS(NVL(base_transaction_value, 0))),0)
3109: INTO l_perp_ship_value
3110: FROM mtl_transaction_accounts mta
3111: WHERE mta.transaction_id = i_ae_txn_rec.transaction_id
3112: and mta.organization_id = i_ae_txn_rec.organization_id
3113: and mta.accounting_line_type IN (1,2,14)
3114: and mta.base_transaction_value < 0;

Line 4131: FROM mtl_transaction_accounts mta

4127:
4128: BEGIN
4129: SELECT nvl(SUM(ABS(NVL(base_transaction_value, 0))),0)
4130: INTO l_perp_ship_value
4131: FROM mtl_transaction_accounts mta
4132: WHERE mta.transaction_id = i_ae_txn_rec.transaction_id
4133: and mta.organization_id = i_ae_txn_rec.organization_id
4134: and mta.accounting_line_type IN (1,2,14)
4135: and mta.base_transaction_value < 0;

Line 5259: FROM mtl_transaction_accounts mta

5255:
5256: BEGIN
5257: SELECT nvl(SUM(ABS(NVL(base_transaction_value, 0))),0)
5258: INTO l_perp_ship_value
5259: FROM mtl_transaction_accounts mta
5260: WHERE mta.transaction_id = l_txfr_txn_id
5261: and mta.organization_id = i_ae_txn_rec.xfer_organization_id
5262: and mta.accounting_line_type IN (1,2,14)
5263: and mta.base_transaction_value < 0;

Line 10891: FROM mtl_transaction_accounts mta

10887: l_stmt_num := 220;
10888:
10889: SELECT nvl(SUM(ABS(NVL(base_transaction_value, 0))),0)
10890: INTO o_perp_ship_value
10891: FROM mtl_transaction_accounts mta
10892: WHERE mta.transaction_id = i_ae_txn_rec.transaction_id
10893: and mta.organization_id = i_ae_txn_rec.organization_id
10894: and mta.accounting_line_type IN (1,2,14)
10895: and mta.base_transaction_value > 0;

Line 10903: FROM mtl_transaction_accounts mta

10899: l_stmt_num := 230;
10900:
10901: SELECT nvl(SUM(ABS(NVL(base_transaction_value, 0))),0)
10902: INTO o_perp_ship_value
10903: FROM mtl_transaction_accounts mta
10904: WHERE mta.transaction_id = i_ae_txn_rec.transaction_id
10905: and mta.organization_id = i_ae_txn_rec.organization_id
10906: and mta.accounting_line_type IN (1,2,14)
10907: and mta.base_transaction_value < 0;