VIEW: APPS.CSC_HZ_LOCATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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