APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on AP_INVOICES_ALL

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: /*