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
Run AP Invoice Validation- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
            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 Name SQL text Validation
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 RK: AP Invoices and Lines AP Open Balances Revaluation AP Open Items Revaluation AP Unaccounted Transactions PO Receiving Transactions Pipeline JE Polish Supplier Statement- Not Supported: Reserved For Future Use AP Payment Schedule Report- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: