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 | |
|---|---|---|---|
| Supplier |
aps.vendor_name=:vendor_name | LOV | |
| Supplier Number |
aps.segment1=:supplier_number | LOV |
Blitz Report™ provides multiple benefits: