VIEW: APPS.WSH_REGIONS_V

Source

View Text - Preformatted

SELECT r.REGION_ID, r.REGION_TYPE, r.PARENT_REGION_ID, rt.CONTINENT, rt.COUNTRY, rt.COUNTRY_REGION, rt.STATE, rt.CITY, rt.ZONE, r.ZONE_LEVEL, rt.POSTAL_CODE_FROM, rt.POSTAL_CODE_TO, r.COUNTRY_CODE, r.COUNTRY_REGION_CODE, r.STATE_CODE, r.CITY_CODE, r.PORT_FLAG, r.AIRPORT_FLAG, r.ROAD_TERMINAL_FLAG, r.RAIL_TERMINAL_FLAG, r.LONGITUDE, r.LATITUDE, r.TIMEZONE, rt.CREATED_BY, rt.CREATION_DATE, rt.LAST_UPDATED_BY, rt.LAST_UPDATE_DATE, rt.LAST_UPDATE_LOGIN, r.ATTRIBUTE_CATEGORY, r.ATTRIBUTE1, r.ATTRIBUTE2, r.ATTRIBUTE3, r.ATTRIBUTE4, r.ATTRIBUTE5, r.ATTRIBUTE6, r.ATTRIBUTE7, r.ATTRIBUTE8, r.ATTRIBUTE9, r.ATTRIBUTE10, r.ATTRIBUTE11, r.ATTRIBUTE12, r.ATTRIBUTE13, r.ATTRIBUTE14, r.ATTRIBUTE15, r.deconsol_location_id FROM wsh_regions r, wsh_regions_tl rt WHERE r.region_id = rt.region_id AND rt.language = USERENV('LANG')

View Text - HTML Formatted

SELECT R.REGION_ID
, R.REGION_TYPE
, R.PARENT_REGION_ID
, RT.CONTINENT
, RT.COUNTRY
, RT.COUNTRY_REGION
, RT.STATE
, RT.CITY
, RT.ZONE
, R.ZONE_LEVEL
, RT.POSTAL_CODE_FROM
, RT.POSTAL_CODE_TO
, R.COUNTRY_CODE
, R.COUNTRY_REGION_CODE
, R.STATE_CODE
, R.CITY_CODE
, R.PORT_FLAG
, R.AIRPORT_FLAG
, R.ROAD_TERMINAL_FLAG
, R.RAIL_TERMINAL_FLAG
, R.LONGITUDE
, R.LATITUDE
, R.TIMEZONE
, RT.CREATED_BY
, RT.CREATION_DATE
, RT.LAST_UPDATED_BY
, RT.LAST_UPDATE_DATE
, RT.LAST_UPDATE_LOGIN
, R.ATTRIBUTE_CATEGORY
, R.ATTRIBUTE1
, R.ATTRIBUTE2
, R.ATTRIBUTE3
, R.ATTRIBUTE4
, R.ATTRIBUTE5
, R.ATTRIBUTE6
, R.ATTRIBUTE7
, R.ATTRIBUTE8
, R.ATTRIBUTE9
, R.ATTRIBUTE10
, R.ATTRIBUTE11
, R.ATTRIBUTE12
, R.ATTRIBUTE13
, R.ATTRIBUTE14
, R.ATTRIBUTE15
, R.DECONSOL_LOCATION_ID
FROM WSH_REGIONS R
, WSH_REGIONS_TL RT
WHERE R.REGION_ID = RT.REGION_ID
AND RT.LANGUAGE = USERENV('LANG')