mihalytest51

➜ Back to Library
Description
Run mihalytest51 and other Oracle EBS reports with Blitz Report™ on our demo environment
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 Type 
aps.vendor_type_lookup_code=xxen_util.lookup_code('Employee','VENDOR TYPE',201)
 LOV
Invoice Date From 
aia.invoice_date>=:invoice_date_from
 Date
Invoice Date To 
aia.invoice_date<:invoice_date_to+1
 Date
Download
Related Blitz Reports
AP Invoices My report JE Israeli Withholding Tax Summary/Detail JL Colombian Payables Withholding Certificate - draft AP Accounted Invoice Aging Rares AP INVOICES JE Israeli Summary VAT to Tax Authorities Mariia's report Rares report number 2 XXSJ Report VAT Register
Blitz Report™

Blitz Report™ provides multiple benefits: