View: WSH_LOCATIONS_REGIONS_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.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