select aps.vendor_name, &supplierinfo aps.segment1 vendor_number, &supplierquery aia.* from (select * from ap_suppliers aps where 2=2) aps, ap_invoices_all aia, hr_operating_units hou where &supplier_number 1=1 and hou.organization_id=aia.org_id and aps.vendor_id=aia.vendor_id |
select aps.vendor_name, &supplierinfo aps.segment1 vendor_number, &supplierquery aia.* from (select * from ap_suppliers aps where 2=2) aps, ap_invoices_all aia, hr_operating_units hou where &supplier_number 1=1 and hou.organization_id=aia.org_id and aps.vendor_id=aia.vendor_id
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Operating Unit |
hou.name=:operating_unit | LOV | |
| Supplier |
aps.vendor_name=:vendor_name | LOV | |
| Supplier Number |
aps.segment1=:segment1 and | LOV | |
| Invoice Date From |
aia.invoice_date>=:invoice_date_from | Date | |
| Invoice Date To |
aia.invoice_date<:invoice_date_to+1 | Date |
Blitz Report™ provides multiple benefits:
