[Home] [Help]
View: WSH_LOCATIONS_REGIONS_V
View Text
SELECT WRL.REGION_ID
, WRL.LOCATION_ID
, HL.ADDRESS1||'
, '||HL.ADDRESS2||'
, '||HL.ADDRESS3||'
, '||HL.ADDRESS4||'
, '||HL.CITY||'
, '||HL.STATE||'
, '||HL.POSTAL_CODE|| '
, '||HL.COUNTRY
, WLO.OWNER_TYPE
, WRL.EXCEPTION_TYPE
, HP.PARTY_NAME
, HP.PARTY_NUMBER
, WRL.CREATED_BY
, WRL.CREATION_DATE
, WRL.LAST_UPDATED_BY
, WRL.LAST_UPDATE_DATE
, WRL.LAST_UPDATE_LOGIN
FROM WSH_LOCATIONS HL
, HZ_PARTIES HP
, WSH_LOCATION_OWNERS WLO
, WSH_REGION_LOCATIONS WRL
WHERE WRL.LOCATION_ID = HL.SOURCE_LOCATION_ID
AND WLO.WSH_LOCATION_ID = HL.SOURCE_LOCATION_ID
AND HP.PARTY_ID = WLO.OWNER_PARTY_ID
AND WLO.OWNER_TYPE <> 1 UNION SELECT DISTINCT WRL.REGION_ID
, WRL.LOCATION_ID
, HL.ADDRESS1||'
, '||HL.ADDRESS2||'
, '||HL.ADDRESS3||'
, '||HL.ADDRESS4||'
, '||HL.CITY||'
, '||HL.STATE||'
, '||HL.POSTAL_CODE|| '
, '||HL.COUNTRY
, WLO.OWNER_TYPE
, WRL.EXCEPTION_TYPE
, HL.LOCATION_CODE
, NULL
, WRL.CREATED_BY
, WRL.CREATION_DATE
, WRL.LAST_UPDATED_BY
, WRL.LAST_UPDATE_DATE
, WRL.LAST_UPDATE_LOGIN
FROM WSH_LOCATIONS HL
, WSH_LOCATION_OWNERS WLO
, WSH_REGION_LOCATIONS WRL
WHERE WRL.LOCATION_ID = HL.SOURCE_LOCATION_ID
AND WLO.WSH_LOCATION_ID = HL.SOURCE_LOCATION_ID
AND WLO.OWNER_PARTY_ID <> -1
AND WLO.OWNER_TYPE = 1 UNION SELECT WRL.REGION_ID
, WRL.LOCATION_ID
, HL.ADDRESS1||'
, '||HL.ADDRESS2||'
, '||HL.ADDRESS3||'
, '||HL.ADDRESS4||'
, '||HL.CITY||'
, '||HL.STATE||'
, '||HL.POSTAL_CODE|| '
, '||HL.COUNTRY
, WLO.OWNER_TYPE
, WRL.EXCEPTION_TYPE
, NULL
, NULL
, WRL.CREATED_BY
, WRL.CREATION_DATE
, WRL.LAST_UPDATED_BY
, WRL.LAST_UPDATE_DATE
, WRL.LAST_UPDATE_LOGIN
FROM WSH_LOCATIONS HL
, WSH_LOCATION_OWNERS WLO
, WSH_REGION_LOCATIONS WRL
WHERE WRL.LOCATION_ID = HL.SOURCE_LOCATION_ID
AND WLO.WSH_LOCATION_ID = HL.SOURCE_LOCATION_ID
AND WLO.OWNER_PARTY_ID = -1
AND WLO.OWNER_TYPE = 1
Columns
Name |
REGION_ID |
LOCATION_ID |
LOCATION |
TYPE |
EXCEPTION_TYPE |
NAME |
LOC_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |