View: CSC_HZ_LOCATIONS_V

Product:	CSC - Customer Care
Description:	View of HZ_LOCATIONS. This view is used to get Location details.
Implementation/DBA Data:	APPS.CSC_HZ_LOCATIONS_V

View Text

SELECT LOCATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, WH_UPDATE_DATE
, ORIG_SYSTEM_REFERENCE
, COUNTRY
, ADDRESS1||DECODE(ADDRESS2
, NULL
, NULL
, ';'||ADDRESS2|| DECODE(ADDRESS3
, NULL
, NULL
, ';'||ADDRESS3|| DECODE(ADDRESS4
, NULL
, NULL
, ';'||ADDRESS4))) ADDRESS
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTY
, ADDRESS_STYLE
, POSTAL_PLUS4_CODE
, ADDRESS_EFFECTIVE_DATE
, ADDRESS_EXPIRATION_DATE
, CONTENT_SOURCE_TYPE
FROM HZ_LOCATIONS

Columns