View: WSH_REGION_LOCATIONS_VL

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

View Text

SELECT R.REGION_ID
, R.REGION_TYPE
, WRL.LOCATION_ID
, R.PARENT_REGION_ID
, RT.COUNTRY
, RT.COUNTRY_REGION
, RT.STATE
, RT.CITY
, RT.POSTAL_CODE_FROM
, RT.POSTAL_CODE_TO
, R.COUNTRY_CODE
, R.COUNTRY_REGION_CODE
, R.STATE_CODE
, R.CITY_CODE
, WRL.PARENT_REGION_FLAG
, WRL.EXCEPTION_TYPE
, RT.CREATED_BY
, RT.CREATION_DATE
, RT.LAST_UPDATED_BY
, RT.LAST_UPDATE_DATE
, RT.LAST_UPDATE_LOGIN
, R.DECONSOL_LOCATION_ID
FROM WSH_REGIONS R
, WSH_REGIONS_TL RT
, WSH_REGION_LOCATIONS WRL
WHERE R.REGION_ID = RT.REGION_ID
AND R.REGION_ID = WRL.REGION_ID
AND RT.LANGUAGE = USERENV('LANG') ORDER BY REGION_ID

Columns