Product: | WSH - Shipping Execution |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSH_ZONE_REGIONS_V |
SELECT Z.ZONE_REGION_ID
, Z.PARENT_REGION_ID
, R.REGION_ID
, R.REGION_TYPE
, RT.CONTINENT
, 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
, 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
FROM WSH_REGIONS R
, WSH_REGIONS_TL RT
, WSH_ZONE_REGIONS Z
WHERE R.REGION_ID = RT.REGION_ID
AND RT.LANGUAGE = USERENV('LANG')
AND Z.REGION_ID = R.REGION_ID