AP Supplier Audit - draft

➜ Back to Library
Description
Categories: BI Publisher
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 
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 
 
Download
Related Blitz Reports
EAM Assets JA India - Cenvat Monthly Return Capital Goods-Textile - draft JA India - RG23C Part I Report - draft - draft JA India - Creditors Ledger - draft JA India - OSP Pending Receipt - draft JA India - OSP Pending Despatch JA India - Outside Processing Challan - draft JA India - RG 23 D - draft PO Headers, Releases and AP Invoices PO Approved Supplier List
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: