AP Invoice Audit Listing

Description
Categories: Enginatics, Kcapps
Repository: Github
Imported Oracle standard 'Invoice Audit Listing' report
Application: Payables
Source: Invoice Audit Listing
Short Name: APXINLST
Run AP Invoice Audit Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
select
haouv.name operating_unit,
aia.invoice_num invoice_number,
aia.invoice_date,
aia.invoice_currency_code currency_code,
aia.invoice_amount,
aia.description,
xxen_util.meaning(aia.invoice_type_lookup_code,'INVOICE TYPE',200) invoice_type,
nvl(aps.vendor_name,hp.party_name) vendor_name,
nvl(aps.segment1,hp.party_number) vendor_number,
nvl(to_char(aia.doc_sequence_value),aia.voucher_num) voucher_number
from
hr_all_organization_units_vl haouv,
ap_invoices_all aia,
ap_suppliers aps,
hz_parties hp
where
1=1 and
haouv.organization_id=aia.org_id and
aia.vendor_id=aps.vendor_id(+) and
aia.party_id=hp.party_id
order by
aia.invoice_date,
aia.invoice_currency_code,
aia.invoice_amount,
upper(aps.vendor_name),
upper(aia.invoice_num)
Parameter Name SQL text Validation
Operating Unit
haouv.name=:operating_unit
LOV
Minimum Invoice Amount
aia.invoice_amount>=:min_invoice_amount
Number
Begin Invoice Date
aia.invoice_date>=:begin_invoice_date
Date
Invoice Type
aia.invoice_type_lookup_code=xxen_util.lookup_code(:invoice_type,'INVOICE TYPE',200)
LOV
Blitz Report™