AP Invoice Audit Listing

➜ Back to Library
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
Download
 
Related Blitz Reports
AP Accounted Invoice Aging GL Account Analysis (Distributions) AP Invoice on Hold GL Account Analysis AP Supplier Upload AP Invoices and Lines XXSJ Report VAT Register JA India - Open Transactions Report for Prior-GST (XML Publisher) AP Cash Requirement - draft
Blitz Report™

Blitz Report™ provides multiple benefits: