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 
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 
 
Download
Related Blitz Reports
JA India - Creditors Ledger - draft JA India - Open Transactions Report for Prior-GST (XML Publisher) INV Consigned Return Transactions PO Purchase Order Detail PO Vendor Purchase Summary PO Receiving Exceptions PO Receipt Adjustments PO Headers, Releases and AP Invoices PO Cancelled Purchase Orders PO Purchase Order and Releases Detail
Related Topics
AP Cash RequirementAP Supplier Merge Program - draftXLA Entity ID MappingsFA Japanese Depreciable Assets Tax SummaryPAY Inland Revenue Form IR21 (Singapore)AP SuppliersPO Approved Supplier ListAP Withholding Tax by InvoicePO Headers, Releases and AP InvoicesAP Prepayment Balance
Blitz Report In Action