AP Supplier Audit - draft

➜ Back to Library

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 more less

Copy

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

Ledger

Matching Supplier Name Length

Download

Related Blitz Reports
PO Printed Planning Schedule AP Prepayment Remittance Notice - draft AP Unclaimed Property - draft JA India - RG23C Part I Report - draft - draft AP Recurring Invoices - draft AP Supplier Mailing Labels - draft AP Invalid PO Supplier Notice - draft AP Suppliers - draft JA India - OSP Pending Despatch