AP Supplier Audit - draft

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Supplier Audit Report (XML) - Not Supported: Reserved For Future Use
Short Name: APXVDDUP_XML
DB package: AP_APXVDDUP_XMLP_PKG
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
Ask a question
Parameter Name SQL text Validation
Ledger
 
Matching Supplier Name Length