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 AP_INVOICES_ALL

Line 24: (invoice_id ap_invoices_all.invoice_id%TYPE,

20: g_batch_list batch_table;
21: g_idx BINARY_INTEGER;
22: -- TYPE txnCurType IS REF CURSOR;
23: TYPE pymt_sch_rec IS RECORD
24: (invoice_id ap_invoices_all.invoice_id%TYPE,
25: min_payment_num ap_payment_schedules_all.payment_num%TYPE,
26: max_payment_num ap_payment_schedules_all.payment_num%TYPE);
27: TYPE pymt_sch_tab IS TABLE OF pymt_sch_rec INDEX BY BINARY_INTEGER;
28: TYPE txnRecType IS RECORD

Line 115: FROM ap_invoices_all api, fnd_currencies fc

111: l_path := g_path || 'Derive Converted Amount';
112: IF ap_ar='AP' THEN
113: SELECT fc.currency_code,fc.precision
114: INTO l_inv_currency,l_precision
115: FROM ap_invoices_all api, fnd_currencies fc
116: WHERE api.invoice_id = p_trx_id
117: AND api.invoice_currency_code = fc.currency_code;
118: ELSE
119: SELECT fc.currency_code,fc.precision

Line 174: l_invoice_currency_code AP_INVOICES_ALL.INVOICE_CURRENCY_CODE%TYPE;

170: l_settlement_date DATE;
171: l_current_discount NUMBER;
172: l_currency_code fun_net_batches.batch_currency%TYPE;
173: l_exchange_rate_type fun_net_batches.exchange_rate_type%TYPE;
174: l_invoice_currency_code AP_INVOICES_ALL.INVOICE_CURRENCY_CODE%TYPE;
175: l_path VARCHAR2(100);
176: BEGIN
177: l_path := g_path||'get_ap_discount';
178: l_sql_stmt:='select PAYMENT_NUM,AMOUNT_REMAINING FROM ap_payment_schedules_all WHERE invoice_id=:v_invoice_id ';

Line 214: from AP_INVOICES_ALL

210: fun_net_util.Log_String(g_state_level,l_path,'l_applieddisc :'|| l_applieddisc);
211: IF(l_net_currency_rule_code = 'ACCOUNTING_CURRENCY' and l_applieddisc > 0) THEN
212: select INVOICE_CURRENCY_CODE
213: into l_invoice_currency_code
214: from AP_INVOICES_ALL
215: where INVOICE_ID = p_invoice_id;
216: l_applieddisc := gl_currency_api.convert_amount_sql(l_invoice_currency_code,
217: l_currency_code,
218: trunc(l_settlement_date),

Line 741: ' FROM ap_invoices_all api,

737: END IF;
738: fun_net_util.Log_String(g_state_level,l_path,'SELECT : '||l_inv_select_clause);
739: /* Build the from clause */
740: l_inv_from_clause :=
741: ' FROM ap_invoices_all api,
742: fun_net_suppliers_all fns,
743: ap_payment_schedules_all aps';
744: fun_net_util.Log_String(g_state_level,l_path,'FROM : '||l_inv_from_clause);
745: /* Build where clause */

Line 1040: TYPE exchange_rate IS TABLE OF ap_invoices_all.exchange_rate%TYPE INDEX BY BINARY_INTEGER;

1036: TYPE amt_type IS TABLE OF fun_net_batches_all.total_netted_amt%TYPE INDEX BY BINARY_INTEGER;
1037: TYPE trx_type IS TABLE OF fun_net_ar_txns_all.customer_trx_id%TYPE INDEX BY BINARY_INTEGER;
1038: TYPE payment_num IS TABLE OF ap_payment_schedules_all.payment_num%TYPE INDEX BY BINARY_INTEGER;
1039: TYPE inv_rank IS TABLE OF fun_net_ap_invs_all.ap_txn_rank%TYPE INDEX BY BINARY_INTEGER;
1040: TYPE exchange_rate IS TABLE OF ap_invoices_all.exchange_rate%TYPE INDEX BY BINARY_INTEGER;
1041: TYPE precision_tab IS TABLE OF fnd_currencies.precision%TYPE INDEX BY BINARY_INTEGER;
1042: --l_invoice_id fun_net_ap_invs_all.invoice_id%TYPE;
1043: --l_invoice_amt fun_net_ap_invs_all.invoice_amt%TYPE;
1044: --l_open_amt fun_net_ap_invs_all.open_amt%TYPE;

Line 1680: -- FROM ap_invoices_all api, fnd_currencies fc

1676: fun_net_util.Log_String(g_state_level,l_path,'Inside IF condition');
1677: --IF g_net_currency_rule = 'ACCOUNTING_CURRENCY' THEN
1678: -- SELECT fc.currency_code,fc.precision
1679: -- INTO l_inv_currency,l_precision
1680: -- FROM ap_invoices_all api, fnd_currencies fc
1681: -- WHERE api.invoice_id = l_trx_id(i)
1682: -- AND api.invoice_currency_code = fc.currency_code;
1683: --l_net_amt_cur := l_open_amt_afterdisc(i) * Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);
1684: --l_net_amt_cur := ROUND(l_net_amt_cur,l_precision);

Line 1707: FROM ap_invoices_all api, fnd_currencies fc

1703: IF g_net_currency_rule = 'ACCOUNTING_CURRENCY' THEN
1704: IF p_appln = 'AP' THEN
1705: SELECT fc.currency_code,fc.precision
1706: INTO l_inv_currency,l_precision
1707: FROM ap_invoices_all api, fnd_currencies fc
1708: WHERE api.invoice_id = l_trx_id(i)
1709: AND api.invoice_currency_code = fc.currency_code;
1710: ELSE
1711: SELECT fc.currency_code,fc.precision

Line 1776: FROM ap_invoices_all api, fnd_currencies fc

1772: IF g_net_currency_rule = 'ACCOUNTING_CURRENCY' THEN
1773: IF p_appln = 'AP' THEN
1774: SELECT fc.currency_code,fc.precision
1775: INTO l_inv_currency,l_precision
1776: FROM ap_invoices_all api, fnd_currencies fc
1777: WHERE api.invoice_id = l_trx_id(i)
1778: AND api.invoice_currency_code = fc.currency_code;
1779: ELSE
1780: SELECT fc.currency_code,fc.precision

Line 1793: FROM ap_invoices_all api, fnd_currencies fc

1789: /*IF g_net_currency_rule = 'ACCOUNTING_CURRENCY' THEN
1790: IF p_appln = 'AP' THEN
1791: SELECT fc.currency_code,fc.precision
1792: INTO l_inv_currency,l_precision
1793: FROM ap_invoices_all api, fnd_currencies fc
1794: WHERE api.invoice_id = l_trx_id(i)
1795: AND api.invoice_currency_code = fc.currency_code;
1796: l_exc_rate := Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);
1797: fun_net_util.Log_String(g_state_level,l_path,'l_exc_rate:'||l_exc_rate);

Line 2165: FROM ap_invoices_all api, fun_net_ap_invs_all fnapi

2161: END batch_exists;
2162: PROCEDURE validate_exch_rate (p_status_flag OUT NOCOPY VARCHAR2) IS
2163: CURSOR trx_curr_cur IS
2164: SELECT INVOICE_CURRENCY_CODE
2165: FROM ap_invoices_all api, fun_net_ap_invs_all fnapi
2166: WHERE api.invoice_id = fnapi.invoice_id
2167: AND fnapi.batch_id = g_batch_id
2168: UNION
2169: SELECT INVOICE_CURRENCY_CODE

Line 2264: FROM ap_invoices_all api, fnd_currencies fc

2260: IF g_net_currency_rule = 'ACCOUNTING_CURRENCY' THEN
2261: IF p_appln = 'AP' THEN
2262: SELECT fc.currency_code,fc.precision
2263: INTO l_inv_currency,l_precision
2264: FROM ap_invoices_all api, fnd_currencies fc
2265: WHERE api.invoice_id = l_trx_id(i)
2266: AND api.invoice_currency_code = fc.currency_code;
2267: l_exc_rate := Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);
2268: fun_net_util.Log_String(g_state_level,l_path,'l_exc_rate:'||l_exc_rate);

Line 3276: TYPE party_type IS TABLE OF ap_invoices_all.party_id%TYPE INDEX BY BINARY_INTEGER;

3272: TYPE vendor_site_type IS TABLE OF po_vendor_sites_all.vendor_site_id%TYPE INDEX BY BINARY_INTEGER;
3273: TYPE currency_type IS TABLE OF fnd_currencies.currency_code%TYPE INDEX BY BINARY_INTEGER;
3274: TYPE ap_check_amt_type IS TABLE OF ap_checks.amount%TYPE INDEX BY BINARY_INTEGER;
3275: TYPE ap_invoice_type IS TABLE OF ap_invoices.invoice_id%TYPE INDEX BY BINARY_INTEGER;
3276: TYPE party_type IS TABLE OF ap_invoices_all.party_id%TYPE INDEX BY BINARY_INTEGER;
3277: TYPE party_site_type IS TABLE OF ap_invoices_all.party_site_id%TYPE INDEX BY BINARY_INTEGER;
3278: ap_check_amt_list ap_check_amt_type;
3279: ap_check_base_amt_list ap_check_amt_type;
3280: vendor_list vendor_type;

Line 3277: TYPE party_site_type IS TABLE OF ap_invoices_all.party_site_id%TYPE INDEX BY BINARY_INTEGER;

3273: TYPE currency_type IS TABLE OF fnd_currencies.currency_code%TYPE INDEX BY BINARY_INTEGER;
3274: TYPE ap_check_amt_type IS TABLE OF ap_checks.amount%TYPE INDEX BY BINARY_INTEGER;
3275: TYPE ap_invoice_type IS TABLE OF ap_invoices.invoice_id%TYPE INDEX BY BINARY_INTEGER;
3276: TYPE party_type IS TABLE OF ap_invoices_all.party_id%TYPE INDEX BY BINARY_INTEGER;
3277: TYPE party_site_type IS TABLE OF ap_invoices_all.party_site_id%TYPE INDEX BY BINARY_INTEGER;
3278: ap_check_amt_list ap_check_amt_type;
3279: ap_check_base_amt_list ap_check_amt_type;
3280: vendor_list vendor_type;
3281: vendor_site_list vendor_site_type;