DBA Data[Home] [Help]

APPS.JAI_AP_RPT_PRRG_PKG dependencies on AP_INVOICES_ALL

Line 57: from ap_invoices_all aia

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