Training Blitz Report Test -- Mrugesh

➜ Back to Library
Description
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 NameSQL textValidation
Operating Unit
hou.name=:operating_unit
LOV
Supplier Name
aps.vendor_name like :vendor_name
LOV
Invoice Date From
aia.invoice_date>=:invoice_date_from
Date
Invoice Date To
aia.invoice_date<:invoice_date_to
Date
Supplier Number
aps.segment1=:suppliernumber and
LOV Oracle
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™