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.

[Home] [Help]

APPS.ARP_ETAX_UTIL dependencies on FND_CURRENCIES

Line 1396: fnd_currencies c

1392: p_ae_sys_rec.loss_cc_id,
1393: p_ae_sys_rec.round_cc_id
1394: FROM ar_system_parameters sysp,
1395: gl_sets_of_books sob,
1396: fnd_currencies c
1397: WHERE sob.set_of_books_id = sysp.set_of_books_id
1398: AND sob.currency_code = c.currency_code;
1399: END;
1400:

Line 2118: FND_CURRENCIES CUR,

2114: RA_CUSTOMER_TRX TRX,
2115: RA_CUST_TRX_TYPES TT,
2116: RA_CUSTOMER_TRX_LINES LINES,
2117: AR_SYSTEM_PARAMETERS AR,
2118: FND_CURRENCIES CUR,
2119: HZ_CUST_ACCOUNTS BILL_CUST,
2120: HZ_PARTIES BILL_PARTY,
2121: HZ_CUST_ACCT_SITES BILL_AS,
2122: HZ_CUST_SITE_USES BILL_SU,

Line 2922: l_base_currency FND_CURRENCIES.currency_code%type;

2918: IS
2919:
2920: l_new_extended_amount NUMBER;
2921: l_new_unit_selling_price NUMBER;
2922: l_base_currency FND_CURRENCIES.currency_code%type;
2923: l_base_precision FND_CURRENCIES.precision%type;
2924: l_base_mau FND_CURRENCIES.minimum_accountable_unit%type;
2925:
2926: CURSOR c_trx(p_trx_id NUMBER) IS

Line 2923: l_base_precision FND_CURRENCIES.precision%type;

2919:
2920: l_new_extended_amount NUMBER;
2921: l_new_unit_selling_price NUMBER;
2922: l_base_currency FND_CURRENCIES.currency_code%type;
2923: l_base_precision FND_CURRENCIES.precision%type;
2924: l_base_mau FND_CURRENCIES.minimum_accountable_unit%type;
2925:
2926: CURSOR c_trx(p_trx_id NUMBER) IS
2927: SELECT line.CUSTOMER_TRX_LINE_ID customer_trx_line_id,

Line 2924: l_base_mau FND_CURRENCIES.minimum_accountable_unit%type;

2920: l_new_extended_amount NUMBER;
2921: l_new_unit_selling_price NUMBER;
2922: l_base_currency FND_CURRENCIES.currency_code%type;
2923: l_base_precision FND_CURRENCIES.precision%type;
2924: l_base_mau FND_CURRENCIES.minimum_accountable_unit%type;
2925:
2926: CURSOR c_trx(p_trx_id NUMBER) IS
2927: SELECT line.CUSTOMER_TRX_LINE_ID customer_trx_line_id,
2928: sum(decode(tax.amount_includes_tax_flag,

Line 2936: FND_CURRENCIES currency,

2932: header.exchange_rate exchange_rate,
2933: currency.precision precision,
2934: currency.minimum_accountable_unit mau
2935: FROM RA_CUSTOMER_TRX header,
2936: FND_CURRENCIES currency,
2937: RA_CUSTOMER_TRX_LINES line,
2938: RA_CUSTOMER_TRX_LINES tax
2939: WHERE header.CUSTOMER_TRX_ID = p_trx_id
2940: AND line.CUSTOMER_TRX_ID = header.CUSTOMER_TRX_ID

Line 2959: FND_CURRENCIES currency,

2955: header.exchange_rate exchange_rate,
2956: currency.precision precision,
2957: currency.minimum_accountable_unit mau
2958: FROM RA_CUSTOMER_TRX header,
2959: FND_CURRENCIES currency,
2960: RA_CUSTOMER_TRX_LINES line
2961: WHERE header.CUSTOMER_TRX_ID = p_trx_id
2962: AND line.CUSTOMER_TRX_ID = header.CUSTOMER_TRX_ID
2963: AND line.LINE_TYPE = 'LINE'

Line 2984: FND_CURRENCIES currency,

2980: header.exchange_rate exchange_rate,
2981: currency.precision precision,
2982: currency.minimum_accountable_unit mau
2983: FROM RA_CUSTOMER_TRX header,
2984: FND_CURRENCIES currency,
2985: RA_CUSTOMER_TRX_LINES line,
2986: RA_CUSTOMER_TRX_LINES tax
2987: WHERE header.REQUEST_ID = p_request_id
2988: AND NVL(header.PREVIOUS_CUSTOMER_TRX_ID, -99) =

Line 3020: fnd_currencies c,

3016: l_base_currency,
3017: l_base_precision,
3018: l_base_mau
3019: FROM gl_sets_of_books sob,
3020: fnd_currencies c,
3021: ar_system_parameters sp
3022: WHERE sob.set_of_books_id = sp.set_of_books_id
3023: AND sob.currency_code = c.currency_code;
3024: