AP Supplier Mailing Labels - draft
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
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 |