View: WSH_LOCATIONS_HR_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_LOCATIONS_HR_V

View Text

SELECT WSH_LOCATION_ID
, LOCATION_SOURCE_CODE
, SOURCE_LOCATION_ID
, LOCATION_CODE
, UI_LOCATION_CODE
, LOCATION_CODE || ':' || NVL(CITY
, SUBSTRB(ADDRESS1
, 1
, 60)) UI_SHORT_LOCATION_CODE
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, STATE
, COUNTRY
, COUNTY
, PROVINCE
, POSTAL_CODE
, INACTIVE_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM WSH_LOCATIONS
WHERE LOCATION_SOURCE_CODE='HR'

Columns