VIEW: APPS.AP_VENDOR_DISP_V

Source

View Text - Preformatted

SELECT PVS.ROWID , PVS.VENDOR_ID , PV.VENDOR_NAME , PV.SEGMENT1 , PVS.VENDOR_SITE_ID , PVS.VENDOR_SITE_CODE , PVS.ADDRESS_LINE1 , PVS.ADDRESS_LINE2 , PVS.ADDRESS_LINE3 , PVS.ADDRESS_LINE4 , PVS.CITY , PVS.COUNTY , PVS.STATE , PVS.ZIP , PVS.COUNTRY , PVS.PROVINCE , FT.TERRITORY_SHORT_NAME , AP_VENDOR_SITES_PKG.FORMAT_ADDRESS(PVS.COUNTRY, PVS.ADDRESS_LINE1, PVS.ADDRESS_LINE2, PVS.ADDRESS_LINE3, PVS.ADDRESS_LINE4, PVS.CITY,PVS.COUNTY,PVS.STATE, PVS.PROVINCE,PVS.ZIP, FT.TERRITORY_SHORT_NAME) , PVS.AREA_CODE , PVS.PHONE , PVS.TELEX , PVS.FAX_AREA_CODE , PVS.FAX , PVS.LANGUAGE , FL.DESCRIPTION , PVS.INVOICE_CURRENCY_CODE , PVS.ADDRESS_STYLE FROM PO_VENDOR_SITES PVS, PO_VENDORS PV, FND_TERRITORIES_VL FT, FND_LANGUAGES_VL FL WHERE PV.VENDOR_ID = PVS.VENDOR_ID AND FT.TERRITORY_CODE(+) = PVS.COUNTRY AND FL.NLS_LANGUAGE(+) = PVS.LANGUAGE

View Text - HTML Formatted

SELECT PVS.ROWID
, PVS.VENDOR_ID
, PV.VENDOR_NAME
, PV.SEGMENT1
, PVS.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, PVS.ADDRESS_LINE1
, PVS.ADDRESS_LINE2
, PVS.ADDRESS_LINE3
, PVS.ADDRESS_LINE4
, PVS.CITY
, PVS.COUNTY
, PVS.STATE
, PVS.ZIP
, PVS.COUNTRY
, PVS.PROVINCE
, FT.TERRITORY_SHORT_NAME
, AP_VENDOR_SITES_PKG.FORMAT_ADDRESS(PVS.COUNTRY
, PVS.ADDRESS_LINE1
, PVS.ADDRESS_LINE2
, PVS.ADDRESS_LINE3
, PVS.ADDRESS_LINE4
, PVS.CITY
, PVS.COUNTY
, PVS.STATE
, PVS.PROVINCE
, PVS.ZIP
, FT.TERRITORY_SHORT_NAME)
, PVS.AREA_CODE
, PVS.PHONE
, PVS.TELEX
, PVS.FAX_AREA_CODE
, PVS.FAX
, PVS.LANGUAGE
, FL.DESCRIPTION
, PVS.INVOICE_CURRENCY_CODE
, PVS.ADDRESS_STYLE
FROM PO_VENDOR_SITES PVS
, PO_VENDORS PV
, FND_TERRITORIES_VL FT
, FND_LANGUAGES_VL FL
WHERE PV.VENDOR_ID = PVS.VENDOR_ID
AND FT.TERRITORY_CODE(+) = PVS.COUNTRY
AND FL.NLS_LANGUAGE(+) = PVS.LANGUAGE