AP Supplier Audit Report- Not Supported: Reserved For Future Use

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Supplier Audit Report
Application: Payables
Source: Supplier Audit Report (XML) - Not Supported: Reserved For Future Use
Short Name: APXVDDUP_XML
DB package: AP_APXVDDUP_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

SELECT 	vendor_site_code C_VENDOR_SITE_CODE,
       	substr(address_line1||address_line2||address_line3, 1, 30) C_ADDRESS,
       	city C_CITY,
       	nvl(state,province) C_STATE,
       	zip C_ZIP,
       	vendor_id C_SITE_VENDOR_ID
FROM   	po_vendor_sites 
 where po_vendor_sites.vendor_id=:C_TMP_VENDOR_ID
Parameter Name SQL text Validation
Operating Unit
 
LOV
Matching Supplier Name Length
 
Char