SRF Training

➜ Back to Library
Description
select 
aps.vendor_name,
aps.segment1 vendor_number,
&supplierinfo
&supplierquery
aia.*
from
(select * from ap_suppliers aps where 2=2) aps,
ap_invoices_all aia,
hr_operating_units haou
where
&supplierwhere
1=1 and
haou.organization_id=aia.org_id and
aps.vendor_id=aia.vendor_id
Parameter NameSQL textValidation
Operating Unit
haou.name=:operating_unit
LOV
Supplier
aps.vendor_name<>:vendor_name
LOV
Invoice date from
aia.invoice_date>=:date_from
Date
Invoice date to
aia.invoice_date<:date_to+1
Date
Supplier Number
aps.segment1=:segment1 and
LOV
Download
Related Blitz Reports
TB GL Account Analysis (Drilldown)v2 AP Accounted Invoice Aging KDM DIOT V2 AP Suppliers ECC Payables, AP Closing, SQL3 (1) TB Accounts Payables Trial Balance - FSSC AP 1099 Payments LSE: INV Material Account Distribution Detail SAM Training XXSJ Report VAT Register
Blitz Report™