DBA Data[Home] [Help]

APPS.JAI_AP_RPT_PRRG_PKG dependencies on AP_INVOICES_ALL

Line 62: from ap_invoices_all aia

58:
59: cursor c_inv_select_cursor is /*Signature change of cursor by nprahsar for bug # 7225946*/ --rchandan for bug#4428980
60: select invoice_id, invoice_num, org_id, vendor_id, vendor_site_id, invoice_date,
61: invoice_currency_code, nvl(exchange_rate,1) exchange_rate, voucher_num
62: from ap_invoices_all aia
63: where cancelled_date is null
64: and (p_vendor_id is null or vendor_id = p_vendor_id)
65: and (p_vendor_site_id is null or vendor_site_id = p_vendor_site_id)
66: and (p_org_id is null or org_id = p_org_id)