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.FUN_NET_ARAP_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 121: FROM ra_customer_trx_all rct, fnd_currencies fc

117: AND api.invoice_currency_code = fc.currency_code;
118: ELSE
119: SELECT fc.currency_code,fc.precision
120: INTO l_inv_currency,l_precision
121: FROM ra_customer_trx_all rct, fnd_currencies fc
122: WHERE rct.customer_trx_id = p_trx_id
123: AND rct.invoice_currency_code = fc.currency_code;
124: END IF;
125: SELECT BATCH_CURRENCY,SETTLEMENT_DATE,EXCHANGE_RATE_TYPE,EXCHANGE_RATE,ORG_ID

Line 245: l_invoice_currency_code RA_CUSTOMER_TRX_ALL.INVOICE_CURRENCY_CODE%TYPE;

241: l_org_id NUMBER;
242: l_settlement_date DATE;
243: l_currency_code fun_net_batches.batch_currency%TYPE;
244: l_exchange_rate_type fun_net_batches.exchange_rate_type%TYPE;
245: l_invoice_currency_code RA_CUSTOMER_TRX_ALL.INVOICE_CURRENCY_CODE%TYPE;
246: l_path VARCHAR2(100);
247: BEGIN
248: l_path := g_path||'get_ar_discount';
249: l_amt_to_net := p_amt_to_net;

Line 290: from RA_CUSTOMER_TRX_ALL

286: fun_net_util.Log_String(g_state_level,l_path,'l_applieddisc :'|| l_applieddisc);
287: IF(l_net_currency_rule_code = 'ACCOUNTING_CURRENCY' and l_applieddisc > 0) THEN
288: select INVOICE_CURRENCY_CODE
289: into l_invoice_currency_code
290: from RA_CUSTOMER_TRX_ALL
291: where CUSTOMER_TRX_ID = p_cust_txn_id;
292: l_applieddisc := gl_currency_api.convert_amount_sql(l_invoice_currency_code,
293: l_currency_code,
294: trunc(l_settlement_date),

Line 502: ' FROM ra_customer_trx_all rct,

498: sum(arps.amount_due_remaining - ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)) AS OPEN_AMOUNT_AFTERDISC'; -- ADDED FOR ESD ENABLED AGREEMENTS
499: END IF;
500: fun_net_util.Log_String(g_state_level,l_path,'SELECT : '||l_trx_select_clause);
501: l_trx_from_clause :=
502: ' FROM ra_customer_trx_all rct,
503: ar_payment_schedules_all arps,
504: ra_cust_trx_types_all rctt,
505: fun_net_customers_all fnc ';
506: fun_net_util.Log_String(g_state_level,l_path,'FROM : '||l_trx_from_clause);

Line 1713: FROM ra_customer_trx_all rct, fnd_currencies fc

1709: AND api.invoice_currency_code = fc.currency_code;
1710: ELSE
1711: SELECT fc.currency_code,fc.precision
1712: INTO l_inv_currency,l_precision
1713: FROM ra_customer_trx_all rct, fnd_currencies fc
1714: WHERE rct.customer_trx_id = l_trx_id(i)
1715: AND rct.invoice_currency_code = fc.currency_code;
1716: END IF;
1717: l_amt_to_net := round(l_amt_to_net * Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency),l_precision);

Line 1782: FROM ra_customer_trx_all rct, fnd_currencies fc

1778: AND api.invoice_currency_code = fc.currency_code;
1779: ELSE
1780: SELECT fc.currency_code,fc.precision
1781: INTO l_inv_currency,l_precision
1782: FROM ra_customer_trx_all rct, fnd_currencies fc
1783: WHERE rct.customer_trx_id = l_trx_id(i)
1784: AND rct.invoice_currency_code = fc.currency_code;
1785: END IF;
1786: l_applieddisc(i):=round(l_applieddisc(i) * Derive_Net_Exchg_Rate(l_inv_currency,g_func_currency),l_precision); -- from ACC CUR t BATCH CUR

Line 1804: FROM ra_customer_trx_all rct, fnd_currencies fc

1800: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);
1801: ELSIF p_appln = 'AR' THEN
1802: SELECT fc.currency_code,fc.precision
1803: INTO l_inv_currency,l_precision
1804: FROM ra_customer_trx_all rct, fnd_currencies fc
1805: WHERE rct.customer_trx_id = l_trx_id(i)
1806: AND rct.invoice_currency_code = fc.currency_code;
1807: l_inv_curr_net_amt(i) := l_net_amt(i) * Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);
1808: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);

Line 2170: FROM ra_customer_trx_all rct, fun_net_ar_txns_all fnart

2166: WHERE api.invoice_id = fnapi.invoice_id
2167: AND fnapi.batch_id = g_batch_id
2168: UNION
2169: SELECT INVOICE_CURRENCY_CODE
2170: FROM ra_customer_trx_all rct, fun_net_ar_txns_all fnart
2171: WHERE rct.customer_trx_id = fnart.customer_trx_id
2172: AND fnart.batch_id = g_batch_id;
2173: l_count NUMBER;
2174: l_exc_rate NUMBER;

Line 2275: FROM ra_customer_trx_all rct, fnd_currencies fc

2271: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);
2272: ELSIF p_appln = 'AR' THEN
2273: SELECT fc.currency_code,fc.precision
2274: INTO l_inv_currency,l_precision
2275: FROM ra_customer_trx_all rct, fnd_currencies fc
2276: WHERE rct.customer_trx_id = l_trx_id(i)
2277: AND rct.invoice_currency_code = fc.currency_code;
2278: l_inv_curr_net_amt(i) := l_amt_to_net * Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);
2279: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);

Line 2598: FROM ra_customer_trx_all rac,fun_net_ar_txns_all fnar

2594: end if;
2595: elsif (g_net_currency_rule = 'WITHIN_CURRENCY') then
2596: SELECT count (DISTINCT rac.invoice_currency_code)
2597: into l_count
2598: FROM ra_customer_trx_all rac,fun_net_ar_txns_all fnar
2599: WHERE rac.customer_trx_id = fnar.customer_trx_id
2600: AND fnar.batch_id = g_batch_id
2601: AND rac.invoice_currency_code <> g_func_currency;
2602: end if;