DBA Data[Home] [Help]

APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on PO_VENDORS

Line 134: CURSOR curinfo(p_supplier_id po_vendors.vendor_id%TYPE) IS

130: --Bug 3338086 Removed group_by for line_type_code. Else
131: --it will fetch multiple rows.
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);