AP Invoices

➜ Back to Library
Description
Run AP Invoices and other Oracle EBS reports with Blitz Report™ on our demo environment
select
aps.vendor_name,
aps.segment1 vendor_number,
aia.*
from
ap_suppliers aps,
ap_invoices_all aia
where
1=1 and
aps.vendor_id=aia.vendor_id
Parameter Name SQL text Validation
Supplier 
aps.vendor_name=:vendor_name
 LOV
Supplier Number 
aps.segment1=:supplier_number
 LOV
Invoice Date From 
aia.invoice_date>=:invoice_date_from
 Date
Invoice Date To 
aia.invoice_date<:invoice_date_to+1
 Date
Download
Related Blitz Reports
My report JE Israeli Withholding Tax Summary/Detail JL Colombian Payables Withholding Certificate - draft AP Accounted Invoice Aging Rares AP INVOICES JE Israeli Summary VAT to Tax Authorities Mariia's report Rares report number 2 XXSJ Report VAT Register
Blitz Report™

Blitz Report™ provides multiple benefits: