AP Invoice Audit Listing - draft

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Invoice Audit Listing (XML) - Not Supported: Reserved For Future Use
Short Name: APXINLST_XML
DB package: AP_APXINLST_XMLP_PKG
            SELECT  i.invoice_num            C_INVOICE_NUMBER,
                    i.invoice_date           C_INVOICE_DATE,
                    i.invoice_currency_code  C_CURRENCY_CODE,
                    i.invoice_amount     C_INVOICE_AMOUNT,
                    i.description            C_DESCRIPTION,
                    lc.displayed_field   C_INVOICE_TYPE,
                    v.vendor_name            C_VENDOR_NAME,
                    v.segment1               C_VENDOR_NUMBER
            FROM    ap_invoices i,
                    po_vendors  v,
                ap_lookup_codes lc
            WHERE   i.invoice_type_lookup_code = nvl(:P_INVOICE_TYPE,
                            i.invoice_type_lookup_code)
            AND i.vendor_id               =  v.vendor_id
            AND lc.lookup_code (+)    =  i.invoice_type_lookup_code
            AND lc.lookup_type (+)    =  'INVOICE TYPE'
            AND     i.invoice_amount           >=  :P_MIN_INV_AMOUNT
            AND     i.invoice_date             >=  :P_DATE_SINCE
            &C_ORDER_BY
Parameter NameSQL textValidation
Ledger
 
Invoice Type (Skip for All)
 
LOV Oracle
Invoice Sort Option
 
LOV Oracle
Begin Invoice Date
 
Date
Minimum Invoice Amount
 
Number