APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on AP_INVOICES_ALL

Line 23: l_payment_cross_rate ap_invoices_all.payment_cross_rate%TYPE;

19: l_amount_remaining ap_invoices.invoice_amount%TYPE;
20: l_session_language VARCHAR2(40);/* For MLS changes */
21: l_base_language VARCHAR2(40); /*For MLS changes*/
22: l_organization_name hr_organization_units.name%TYPE;
23: l_payment_cross_rate ap_invoices_all.payment_cross_rate%TYPE;
24: l_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
25: l_invoice_amount ap_invoices_all.invoice_amount%TYPE;
26: l_payment_amount ap_invoices_all.amount_paid%TYPE;
27: l_discount_taken ap_invoices_all.discount_amount_taken%TYPE;

Line 24: l_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;

20: l_session_language VARCHAR2(40);/* For MLS changes */
21: l_base_language VARCHAR2(40); /*For MLS changes*/
22: l_organization_name hr_organization_units.name%TYPE;
23: l_payment_cross_rate ap_invoices_all.payment_cross_rate%TYPE;
24: l_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
25: l_invoice_amount ap_invoices_all.invoice_amount%TYPE;
26: l_payment_amount ap_invoices_all.amount_paid%TYPE;
27: l_discount_taken ap_invoices_all.discount_amount_taken%TYPE;
28: l_discount_avail ap_invoices_all.discount_amount_taken%TYPE;

Line 25: l_invoice_amount ap_invoices_all.invoice_amount%TYPE;

21: l_base_language VARCHAR2(40); /*For MLS changes*/
22: l_organization_name hr_organization_units.name%TYPE;
23: l_payment_cross_rate ap_invoices_all.payment_cross_rate%TYPE;
24: l_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
25: l_invoice_amount ap_invoices_all.invoice_amount%TYPE;
26: l_payment_amount ap_invoices_all.amount_paid%TYPE;
27: l_discount_taken ap_invoices_all.discount_amount_taken%TYPE;
28: l_discount_avail ap_invoices_all.discount_amount_taken%TYPE;
29:

Line 26: l_payment_amount ap_invoices_all.amount_paid%TYPE;

22: l_organization_name hr_organization_units.name%TYPE;
23: l_payment_cross_rate ap_invoices_all.payment_cross_rate%TYPE;
24: l_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
25: l_invoice_amount ap_invoices_all.invoice_amount%TYPE;
26: l_payment_amount ap_invoices_all.amount_paid%TYPE;
27: l_discount_taken ap_invoices_all.discount_amount_taken%TYPE;
28: l_discount_avail ap_invoices_all.discount_amount_taken%TYPE;
29:
30:

Line 27: l_discount_taken ap_invoices_all.discount_amount_taken%TYPE;

23: l_payment_cross_rate ap_invoices_all.payment_cross_rate%TYPE;
24: l_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
25: l_invoice_amount ap_invoices_all.invoice_amount%TYPE;
26: l_payment_amount ap_invoices_all.amount_paid%TYPE;
27: l_discount_taken ap_invoices_all.discount_amount_taken%TYPE;
28: l_discount_avail ap_invoices_all.discount_amount_taken%TYPE;
29:
30:
31: --The cursor vendorinfo holds all the information about the vendor and vendor site

Line 28: l_discount_avail ap_invoices_all.discount_amount_taken%TYPE;

24: l_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
25: l_invoice_amount ap_invoices_all.invoice_amount%TYPE;
26: l_payment_amount ap_invoices_all.amount_paid%TYPE;
27: l_discount_taken ap_invoices_all.discount_amount_taken%TYPE;
28: l_discount_avail ap_invoices_all.discount_amount_taken%TYPE;
29:
30:
31: --The cursor vendorinfo holds all the information about the vendor and vendor site
32: CURSOR vendorinfo(p_base_language po_vendor_sites_all.language%TYPE,

Line 75: FROM ap_invoices_all ai,

71: ai.invoice_amount invoice_amount,
72: nvl(ai.amount_paid,0) payment_amount,
73: nvl(ai.discount_amount_taken,0) discount_taken,
74: gl.currency_code --bug9050332
75: FROM ap_invoices_all ai,
76: fnd_lookup_types_vl lkp,
77: fnd_lookup_values_vl lkv,
78: gl_ledgers gl --bug9050332
79: WHERE ai.set_of_books_id = gl.ledger_id --bug9050332

Line 98: FROM ap_invoices_all ai

94:
95: --Cursor to get the data of distinct invoice currency codes
96: CURSOR curinfo(p_supplier_id po_vendors.vendor_id%TYPE) IS
97: SELECT DISTINCT(invoice_currency_code) invoice_currency_code
98: FROM ap_invoices_all ai
99: WHERE ai.vendor_id=p_supplier_id
100: AND ai.invoice_currency_code=nvl(p_currency,ai.invoice_currency_code);
101:
102: --3641604 : New cursor to get sum of discount available for invoice