AP Invoice Validation- Not Supported: Reserved For Future Use
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
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 |