AP Invoice Validation- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Invoice Validation
Application: Payables
Source: Invoice Validation (XML) - Not Supported: Reserved For Future Use
Short Name: APPRVL_XML
DB package: AP_APXAPRVL_XMLP_PKG
            select  displayed_field, number_holds_placed,
             number_holds_released, substrb(mo_global.get_ou_name(org_id),1, 240) operating_unit
            from ap_temp_approval_gt at, ap_lookup_codes al
            where at.hold_lookup_code = al.lookup_code
            and al.lookup_type = 'HOLD CODE'
            and (number_holds_placed != 0
                    or number_holds_released != 0)
            and mo_global.check_access(org_id) = 'Y'
            Order By operating_unit
Parameter NameSQL textValidation
Operating Unit
 
LOV Oracle
Option
 
LOV Oracle
Invoice Batch Name
 
LOV Oracle
From Invoice Date
 
Date
To Invoice Date
 
Date
Supplier Name
 
LOV Oracle
Pay Group
 
LOV Oracle
Invoice Number
 
LOV Oracle
Entered By
 
LOV Oracle
Download
Related Blitz Reports
ECC Procurement, Purchase Orders ECC Procurement, Agreements AP Invoice Approval Status PO Receiving Transactions Pipeline ICC: AP Supplier Statement JE Polish Supplier Statement- Not Supported: Reserved For Future Use AP Payment Schedule Report- Not Supported: Reserved For Future Use AP Supplier Statement(GST) AP Unaccounted Transactions
Blitz Report™