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.ARP_ETAX_UTIL dependencies on FND_CURRENCIES

Line 1460: fnd_currencies c

1456: p_ae_sys_rec.loss_cc_id,
1457: p_ae_sys_rec.round_cc_id
1458: FROM ar_system_parameters sysp,
1459: gl_sets_of_books sob,
1460: fnd_currencies c
1461: WHERE sob.set_of_books_id = sysp.set_of_books_id
1462: AND sob.currency_code = c.currency_code;
1463: END;
1464:

Line 2187: FND_CURRENCIES CUR,

2183: RA_CUSTOMER_TRX TRX,
2184: RA_CUST_TRX_TYPES TT,
2185: RA_CUSTOMER_TRX_LINES LINES,
2186: AR_SYSTEM_PARAMETERS AR,
2187: FND_CURRENCIES CUR,
2188: HZ_CUST_ACCOUNTS BILL_CUST,
2189: HZ_PARTIES BILL_PARTY,
2190: HZ_CUST_ACCT_SITES BILL_AS,
2191: HZ_CUST_SITE_USES BILL_SU,

Line 2981: l_base_currency FND_CURRENCIES.currency_code%type;

2977: IS
2978:
2979: l_new_extended_amount NUMBER;
2980: l_new_unit_selling_price NUMBER;
2981: l_base_currency FND_CURRENCIES.currency_code%type;
2982: l_base_precision FND_CURRENCIES.precision%type;
2983: l_base_mau FND_CURRENCIES.minimum_accountable_unit%type;
2984:
2985: CURSOR c_trx(p_trx_id NUMBER) IS

Line 2982: l_base_precision FND_CURRENCIES.precision%type;

2978:
2979: l_new_extended_amount NUMBER;
2980: l_new_unit_selling_price NUMBER;
2981: l_base_currency FND_CURRENCIES.currency_code%type;
2982: l_base_precision FND_CURRENCIES.precision%type;
2983: l_base_mau FND_CURRENCIES.minimum_accountable_unit%type;
2984:
2985: CURSOR c_trx(p_trx_id NUMBER) IS
2986: SELECT line.CUSTOMER_TRX_LINE_ID customer_trx_line_id,

Line 2983: l_base_mau FND_CURRENCIES.minimum_accountable_unit%type;

2979: l_new_extended_amount NUMBER;
2980: l_new_unit_selling_price NUMBER;
2981: l_base_currency FND_CURRENCIES.currency_code%type;
2982: l_base_precision FND_CURRENCIES.precision%type;
2983: l_base_mau FND_CURRENCIES.minimum_accountable_unit%type;
2984:
2985: CURSOR c_trx(p_trx_id NUMBER) IS
2986: SELECT line.CUSTOMER_TRX_LINE_ID customer_trx_line_id,
2987: /* sum(decode(tax.amount_includes_tax_flag,

Line 2998: FND_CURRENCIES currency,

2994: header.exchange_rate exchange_rate,
2995: currency.precision precision,
2996: currency.minimum_accountable_unit mau
2997: FROM RA_CUSTOMER_TRX header,
2998: FND_CURRENCIES currency,
2999: RA_CUSTOMER_TRX_LINES line,
3000: RA_CUSTOMER_TRX_LINES tax
3001: WHERE header.CUSTOMER_TRX_ID = p_trx_id
3002: AND line.CUSTOMER_TRX_ID = header.CUSTOMER_TRX_ID

Line 3021: FND_CURRENCIES currency,

3017: header.exchange_rate exchange_rate,
3018: currency.precision precision,
3019: currency.minimum_accountable_unit mau
3020: FROM RA_CUSTOMER_TRX header,
3021: FND_CURRENCIES currency,
3022: RA_CUSTOMER_TRX_LINES line
3023: WHERE header.CUSTOMER_TRX_ID = p_trx_id
3024: AND line.CUSTOMER_TRX_ID = header.CUSTOMER_TRX_ID
3025: AND line.LINE_TYPE = 'LINE'

Line 3046: FND_CURRENCIES currency,

3042: header.exchange_rate exchange_rate,
3043: currency.precision precision,
3044: currency.minimum_accountable_unit mau
3045: FROM RA_CUSTOMER_TRX header,
3046: FND_CURRENCIES currency,
3047: RA_CUSTOMER_TRX_LINES line,
3048: RA_CUSTOMER_TRX_LINES tax
3049: WHERE header.REQUEST_ID = p_request_id
3050: AND NVL(header.PREVIOUS_CUSTOMER_TRX_ID, -99) =

Line 3082: fnd_currencies c,

3078: l_base_currency,
3079: l_base_precision,
3080: l_base_mau
3081: FROM gl_sets_of_books sob,
3082: fnd_currencies c,
3083: ar_system_parameters sp
3084: WHERE sob.set_of_books_id = sp.set_of_books_id
3085: AND sob.currency_code = c.currency_code;
3086: