DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.WSH_ZONE_REGIONS_V

Object Details
Object Name: WSH_ZONE_REGIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSH_ZONE_REGIONS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ZONE_REGION_ID NUMBER
Yes
ZONE_ID NUMBER
Yes
REGION_ID NUMBER
Yes
REGION_TYPE NUMBER
Yes
CONTINENT VARCHAR2 (60)
COUNTRY VARCHAR2 (80)
COUNTRY_REGION VARCHAR2 (60)
STATE VARCHAR2 (60)
CITY VARCHAR2 (60)
POSTAL_CODE_FROM VARCHAR2 (60)
POSTAL_CODE_TO VARCHAR2 (60)
COUNTRY_CODE VARCHAR2 (10)
COUNTRY_REGION_CODE VARCHAR2 (10)
STATE_CODE VARCHAR2 (10)
CITY_CODE VARCHAR2 (10)
PORT_FLAG VARCHAR2 (1)
AIRPORT_FLAG VARCHAR2 (1)
ROAD_TERMINAL_FLAG VARCHAR2 (1)
RAIL_TERMINAL_FLAG VARCHAR2 (1)
LONGITUDE NUMBER

LATITUDE NUMBER

TIMEZONE VARCHAR2 (3)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ZONE_REGION_ID
,      ZONE_ID
,      REGION_ID
,      REGION_TYPE
,      CONTINENT
,      COUNTRY
,      COUNTRY_REGION
,      STATE
,      CITY
,      POSTAL_CODE_FROM
,      POSTAL_CODE_TO
,      COUNTRY_CODE
,      COUNTRY_REGION_CODE
,      STATE_CODE
,      CITY_CODE
,      PORT_FLAG
,      AIRPORT_FLAG
,      ROAD_TERMINAL_FLAG
,      RAIL_TERMINAL_FLAG
,      LONGITUDE
,      LATITUDE
,      TIMEZONE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.WSH_ZONE_REGIONS_V;

Dependencies

[top of page]

APPS.WSH_ZONE_REGIONS_V references the following:

SchemaAPPS
SynonymWSH_REGIONS
SynonymWSH_REGIONS_TL
SynonymWSH_ZONE_REGIONS
APPS.WSH_ZONE_REGIONS_V is referenced by following:

SchemaAPPS
ViewCSP_SHIPPING_DETAILS_V