[Home] [Help]
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);