AP Invoice Validation- Not Supported: Reserved For Future Use

Description

Categories
BI Publisher
Application
Payables
Source
Invoice Validation (XML) - Not Supported: Reserved For Future Use
Short Name
APPRVL_XML
DB package
AP_APXAPRVL_XMLP_PKG
Imported from BI Publisher
Invoice Validation

SQL 10 lines

            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

Parameters 9

ParameterTypeList of values SQL
Operating UnitLOV Oracle
OptionLOV Oracle
Invoice Batch NameLOV Oracle
From Invoice DateDate
To Invoice DateDate
Supplier NameLOV Oracle
Pay GroupLOV Oracle
Invoice NumberLOV Oracle
Entered ByLOV Oracle