AP Supplier Audit - draft
Description
Categories: BI Publisher
Columns: C Vendor Site Code, C Address, C City, C State, C Zip, C Site Vendor Id ...
Columns: C Vendor Site Code, C Address, C City, C State, C Zip, C Site Vendor Id ...
Application: Payables
Source: Supplier Audit Report (XML) - Not Supported: Reserved For Future Use
Short Name: APXVDDUP_XML
DB package: AP_APXVDDUP_XMLP_PKG
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Matching Supplier Name Length |
|
||
Ledger |
|