[Home] [Help]
View: 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
Name |
WSH_LOCATION_ID |
LOCATION_SOURCE_CODE |
SOURCE_LOCATION_ID |
LOCATION_CODE |
UI_LOCATION_CODE |
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 |