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.AP_GET_SUPPLIER_BALANCE_PKG dependencies on AP_INVOICES

Line 19: l_total_inv_balance ap_invoices.invoice_amount%TYPE;

15: ,p_trace_flag in varchar2
16: ) is
17:
18:
19: l_total_inv_balance ap_invoices.invoice_amount%TYPE;
20: l_discount_avail ap_invoices.invoice_amount%TYPE;
21: l_tot_discount_avail ap_invoices.invoice_amount%TYPE;
22: l_amount_remaining ap_invoices.invoice_amount%TYPE;
23: l_functional_currency_code ap_invoices.invoice_currency_code%TYPE;

Line 20: l_discount_avail ap_invoices.invoice_amount%TYPE;

16: ) is
17:
18:
19: l_total_inv_balance ap_invoices.invoice_amount%TYPE;
20: l_discount_avail ap_invoices.invoice_amount%TYPE;
21: l_tot_discount_avail ap_invoices.invoice_amount%TYPE;
22: l_amount_remaining ap_invoices.invoice_amount%TYPE;
23: l_functional_currency_code ap_invoices.invoice_currency_code%TYPE;
24: l_open_balance ap_invoices.invoice_amount%TYPE;

Line 21: l_tot_discount_avail ap_invoices.invoice_amount%TYPE;

17:
18:
19: l_total_inv_balance ap_invoices.invoice_amount%TYPE;
20: l_discount_avail ap_invoices.invoice_amount%TYPE;
21: l_tot_discount_avail ap_invoices.invoice_amount%TYPE;
22: l_amount_remaining ap_invoices.invoice_amount%TYPE;
23: l_functional_currency_code ap_invoices.invoice_currency_code%TYPE;
24: l_open_balance ap_invoices.invoice_amount%TYPE;
25: l_total_prepayment ap_invoices.invoice_amount%TYPE;

Line 22: l_amount_remaining ap_invoices.invoice_amount%TYPE;

18:
19: l_total_inv_balance ap_invoices.invoice_amount%TYPE;
20: l_discount_avail ap_invoices.invoice_amount%TYPE;
21: l_tot_discount_avail ap_invoices.invoice_amount%TYPE;
22: l_amount_remaining ap_invoices.invoice_amount%TYPE;
23: l_functional_currency_code ap_invoices.invoice_currency_code%TYPE;
24: l_open_balance ap_invoices.invoice_amount%TYPE;
25: l_total_prepayment ap_invoices.invoice_amount%TYPE;
26: l_session_language varchar2(40);/* For MLS changes */

Line 23: l_functional_currency_code ap_invoices.invoice_currency_code%TYPE;

19: l_total_inv_balance ap_invoices.invoice_amount%TYPE;
20: l_discount_avail ap_invoices.invoice_amount%TYPE;
21: l_tot_discount_avail ap_invoices.invoice_amount%TYPE;
22: l_amount_remaining ap_invoices.invoice_amount%TYPE;
23: l_functional_currency_code ap_invoices.invoice_currency_code%TYPE;
24: l_open_balance ap_invoices.invoice_amount%TYPE;
25: l_total_prepayment ap_invoices.invoice_amount%TYPE;
26: l_session_language varchar2(40);/* For MLS changes */
27: l_base_language varchar2(40); /*For MLS changes*/

Line 24: l_open_balance ap_invoices.invoice_amount%TYPE;

20: l_discount_avail ap_invoices.invoice_amount%TYPE;
21: l_tot_discount_avail ap_invoices.invoice_amount%TYPE;
22: l_amount_remaining ap_invoices.invoice_amount%TYPE;
23: l_functional_currency_code ap_invoices.invoice_currency_code%TYPE;
24: l_open_balance ap_invoices.invoice_amount%TYPE;
25: l_total_prepayment ap_invoices.invoice_amount%TYPE;
26: l_session_language varchar2(40);/* For MLS changes */
27: l_base_language varchar2(40); /*For MLS changes*/
28: l_inv_balance ap_invoices.invoice_amount%TYPE;

Line 25: l_total_prepayment ap_invoices.invoice_amount%TYPE;

21: l_tot_discount_avail ap_invoices.invoice_amount%TYPE;
22: l_amount_remaining ap_invoices.invoice_amount%TYPE;
23: l_functional_currency_code ap_invoices.invoice_currency_code%TYPE;
24: l_open_balance ap_invoices.invoice_amount%TYPE;
25: l_total_prepayment ap_invoices.invoice_amount%TYPE;
26: l_session_language varchar2(40);/* For MLS changes */
27: l_base_language varchar2(40); /*For MLS changes*/
28: l_inv_balance ap_invoices.invoice_amount%TYPE;
29: --l_start_date ap_invoices.invoice_date%TYPE;

Line 28: l_inv_balance ap_invoices.invoice_amount%TYPE;

24: l_open_balance ap_invoices.invoice_amount%TYPE;
25: l_total_prepayment ap_invoices.invoice_amount%TYPE;
26: l_session_language varchar2(40);/* For MLS changes */
27: l_base_language varchar2(40); /*For MLS changes*/
28: l_inv_balance ap_invoices.invoice_amount%TYPE;
29: --l_start_date ap_invoices.invoice_date%TYPE;
30: l_organization_name hr_organization_units.name%TYPE;
31: l_sum_discount NUMBER; -- 3641604
32: l_paid_amount NUMBER; -- 2901541

Line 29: --l_start_date ap_invoices.invoice_date%TYPE;

25: l_total_prepayment ap_invoices.invoice_amount%TYPE;
26: l_session_language varchar2(40);/* For MLS changes */
27: l_base_language varchar2(40); /*For MLS changes*/
28: l_inv_balance ap_invoices.invoice_amount%TYPE;
29: --l_start_date ap_invoices.invoice_date%TYPE;
30: l_organization_name hr_organization_units.name%TYPE;
31: l_sum_discount NUMBER; -- 3641604
32: l_paid_amount NUMBER; -- 2901541
33: --The cursor vendorinfo holds all the information about the vendor and vendor site

Line 80: CURSOR invinfo(p_vendor_id ap_invoices.vendor_id%TYPE,

76: --Cursor invinfo holds data about invoices for the parameters entered
77:
78: --Bug 2431936 changed 'prepay' to 'PREPAY'
79:
80: CURSOR invinfo(p_vendor_id ap_invoices.vendor_id%TYPE,
81: p_vendor_site_id ap_invoices.vendor_site_id%TYPE,
82: p_currency ap_invoices.invoice_currency_code%TYPE) is
83: SELECT
84: ai.invoice_id,

Line 81: p_vendor_site_id ap_invoices.vendor_site_id%TYPE,

77:
78: --Bug 2431936 changed 'prepay' to 'PREPAY'
79:
80: CURSOR invinfo(p_vendor_id ap_invoices.vendor_id%TYPE,
81: p_vendor_site_id ap_invoices.vendor_site_id%TYPE,
82: p_currency ap_invoices.invoice_currency_code%TYPE) is
83: SELECT
84: ai.invoice_id,
85: ai.payment_cross_rate,

Line 82: p_currency ap_invoices.invoice_currency_code%TYPE) is

78: --Bug 2431936 changed 'prepay' to 'PREPAY'
79:
80: CURSOR invinfo(p_vendor_id ap_invoices.vendor_id%TYPE,
81: p_vendor_site_id ap_invoices.vendor_site_id%TYPE,
82: p_currency ap_invoices.invoice_currency_code%TYPE) is
83: SELECT
84: ai.invoice_id,
85: ai.payment_cross_rate,
86: -- 3641604 aps.payment_num,

Line 97: ap_invoices_all ai,

93: nvl(ai.discount_amount_taken,0) discount_taken,
94: sum(nvl(aid1.amount,0)) dist_amount --bug 3338086
95: FROM
96: /*bug 5264865*/
97: ap_invoices_all ai,
98: ap_invoice_distributions_all aid1,
99: fnd_lookup_types_vl lkp,
100: fnd_lookup_values_vl lkv
101: -- 3641604 ap_payment_schedules aps

Line 136: FROM ap_invoices_all ai

132:
133: --bug 5264869 replace view with base table
134: CURSOR curinfo(p_supplier_id po_vendors.vendor_id%TYPE) IS
135: SELECT DISTINCT(invoice_currency_code) invoice_currency_code
136: FROM ap_invoices_all ai
137: WHERE ai.vendor_id=p_supplier_id
138: and ai.invoice_currency_code=nvl(p_currency,ai.invoice_currency_code);
139:
140: /*

Line 390: ap_invoices ai,

386: SUM(nvl(AID1.PREPAY_AMOUNT_REMAINING,AID1.AMOUNT) ),
387: (SUM(nvl(AID1.AMOUNT,0)) -
388: SUM(nvl(AID1.PREPAY_AMOUNT_REMAINING,AID1.AMOUNT)))
389: FROM
390: ap_invoices ai,
391: ap_invoice_distributions aid1,
392: fnd_lookup_types_vl lkp,
393: fnd_lookup_values_vl lkv
394: WHERE

Line 483: FROM ap_invoice_distributions AID, ap_invoices AI

479: 3542467: Get the payment cross rate and invoice currency code
480: */
481: SELECT AI.payment_cross_rate, AI.invoice_currency_code, NVL(SUM(NVL(AID.amount, 0)), 0)
482: INTO v_payment_cross_rate, v_invoice_currency_code, v_invoice_amount
483: FROM ap_invoice_distributions AID, ap_invoices AI
484: WHERE AI.invoice_id = AID.invoice_id
485: AND AI.invoice_id = p_invoice_id
486: GROUP BY AI.payment_cross_rate, AI.invoice_currency_code;
487:

Line 493: FROM ap_invoice_payments AIP, ap_invoices AI

489: 3542467: Get the discount taken
490: */
491: SELECT NVL(SUM(NVL(AIP.amount, 0)), 0), NVL(SUM(NVL(AIP.discount_taken, 0)), 0)
492: INTO v_payment_amount, v_discount_taken
493: FROM ap_invoice_payments AIP, ap_invoices AI
494: WHERE AIP.invoice_id = AI.invoice_id
495: AND AI.invoice_id = p_invoice_id
496: AND accounting_date <= p_as_of_date;
497: