AP Supplier Mailing Labels - draft

➜ Back to Library
Description
Categories: BI Publisher
Application: Payables
Source: Supplier Mailing Labels (XML) - Not Supported: Reserved For Future Use
Short Name: APXVDLBL_XML
DB package: AP_APXVDLBL_XMLP_PKG
SELECT
    pvs.vendor_site_id				vendor_site_id,		
    pv.vendor_name					vendor_name,
    pvs.address_line1					address1,
    pvs.address_line2					address2,
    pvs.address_line3					address3,	
    pvs.city						city,	
    nvl(pvs.state, pvs.province)				state,
    pvs.zip						zip,	
    nvl(pvs.country,:DEFAULT_COUNTRY_CODE_1)		country_code,
    nvl(ft.territory_short_name,:DEFAULT_COUNTRY_NAME)	country_name,	
    decode(pvs.attention_ar_flag, 'N', NULL, :ATTN_MESSAGE)	attention, 
	AP_APXVDLBL_XMLP_PKG.c_address_concatenatedformula(pvs.address_line1, pvs.address_line2, pvs.address_line3, pvs.city, nvl(pvs.state, pvs.province), pvs.zip, nvl(ft.territory_short_name,:DEFAULT_COUNTRY_NAME), nvl(pvs.country,:DEFAULT_COUNTRY_CODE_1), pv.vendor_name, decode(pvs.attention_ar_flag, 'N', NULL, :ATTN_MESSAGE)) C_address_concatenated
FROM po_vendors pv , po_vendor_sites pvs, fnd_territories_vl ft
WHERE  pv.vendor_id = pvs.vendor_id
AND pvs.country = ft.territory_code (+) 
 and pvs.vendor_site_id=:site_id
Parameter NameSQL textValidation
Supplier Type
 
LOV Oracle
Order By
 
LOV Oracle
Site Uses
 
LOV Oracle
Print Home Country
 
LOV Oracle
Output Style
 
LOV Oracle
Download
Related Blitz Reports
AP Supplier Upload AP Suppliers Report- Not Supported: Reserved For Future Use MDS TEST AP Supplier Upload AP 1099 Electronic Media- Not Supported: Reserved For Future Use COPY OF: AP Supplier Upload PO Country of Origin (By Item) PO Country of Origin (By Supplier) PO Headers and Lines AP Invoice Upload
Blitz Report™