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 |
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 |
cmr.transaction_date >= :p_from_date | Date |
Blitz Report™ provides multiple benefits: