Rares report

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
Vendor Name
pov.vendor_name=:vendor_name
LOV Oracle
Invoice Number
aia.invoice_num=:invoice_number
LOV
Source
aerha.source=xxen_util.lookup_code(:source,'SOURCE',200)
LOV