AP Invoice Validation - draft

Description
Categories: BI Publisher, Financials, Procurement
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
Commit Size
 
Number
Ledger Id
 
Number
Entered By
 
LOV Oracle
Invoice Number
 
LOV Oracle
Pay Group
 
LOV Oracle
Supplier Name
 
LOV Oracle
To Invoice Date
 
Date
From Invoice Date
 
Date
Invoice Batch Name
 
LOV Oracle
Option
 
LOV Oracle
Operating Unit
 
LOV Oracle