SAM Training

➜ Back to Library
Description
select 
aps.vendor_name ,
aps.vendor_name "TEST & ",
aps.vendor_name "TEST &BC hdjkadh",
aps.vendor_name "TEST&BC",
aps.vendor_name "TEST&",
aps.vendor_name "&BC",
&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
/*&template_having_clause*/
Parameter NameSQL textValidation
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
test
<parameter_value>
Char
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 XXSJ Report VAT Register
Blitz Report™