View: CS_LOCATION_V

Product:	CS - Service
Description:
Implementation/DBA Data:	APPS.CS_LOCATION_V

View Text

SELECT DISTINCT HZLOC.LOCATION_ID
, HZLOC.ADDRESS1 || ' ' || HZLOC.ADDRESS2 || ' ' || HZLOC.ADDRESS3 || ' ' || HZLOC.ADDRESS4 || ' ' || DECODE(LTRIM(HZLOC.CITY)
, NULL
, ''
, ' ' || HZLOC.CITY) || DECODE(LTRIM(HZLOC.POSTAL_CODE)
, NULL
, ''
, ' ' || HZLOC.POSTAL_CODE) || DECODE(LTRIM(HZLOC.STATE)
, NULL
, ''
, ' ' || HZLOC.STATE) || DECODE(LTRIM(HZLOC.PROVINCE)
, NULL
, ''
, ' ' || HZLOC.PROVINCE) || DECODE(LTRIM(HZLOC.COUNTY)
, NULL
, ''
, ' ' || HZLOC.COUNTY) || DECODE(LTRIM(HZLOC.COUNTRY)
, NULL
, ''
, ' ' || HZLOC.COUNTRY) ADDRESS
FROM HZ_LOCATIONS HZLOC

Columns