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
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
| Parameter | Type | List of values SQL |
|---|---|---|
| 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 |