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
Run AP Supplier Mailing Labels - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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 Name SQL text Validation
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 Suppliers Report- Not Supported: Reserved For Future Use AP 1099 Electronic Media- Not Supported: Reserved For Future Use PO Headers and Lines 11i PO Country of Origin (By Item) PO Country of Origin (By Supplier) AP Suppliers XXT OF: PO Headers and Lines XX AP Suppliers PO Receiving Transactions Pipeline
Blitz Report™

Blitz Report™ provides multiple benefits: