rares ap invoces

Description
This is a test report
Run rares ap invoces 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
Date From
aia.invoice_date >= :p_from_date
Date
Date To
aia.invoice_date < :p_to_date + 1
Date