View: OKL_CS_DIS_ADDRESS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_DIS_ADDRESS_UV

View Text

SELECT DISTINCT POVS.VENDOR_ID
, POVS.ADDRESS_LINE1 || ' '||POVS.ADDRESS_LINE2 || ' '|| POVS.ADDRESS_LINE3 ||' ' || POVS.CITY|| ' '|| POVS.COUNTY || ' '|| POVS.PROVINCE ||' ' || POVS.STATE || ' ' || POVS.ZIP ||' ' || POVS. COUNTRY ADDRESS
, POVS.AREA_CODE || '-' ||PHONE PHONE
, POVS.VENDOR_SITE_ID
FROM PO_VENDOR_SITES_ALL POVS

Columns