VIEW: APPS.CS_LOCATION_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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