Mariia's report

➜ Back to Library
Description

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Inv Creation Date From 
aia.creation_date>=:inv_creat_date_from
 Date
Download
 
Related Blitz Reports
AP Invoices AP Accounted Invoice Aging EOS GL Account Analysis with Tax Rares AP INVOICES JE Israeli Summary VAT to Tax Authorities FA Cost Adjustments Rares report number 2 AP test XXSJ Report VAT Register
Blitz Report™

Blitz Report™ provides multiple benefits: