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

TABLE: WSH.WSH_REGIONS

Object Details
Object Name: WSH_REGIONS
Object Type: TABLE
Owner: WSH
FND Design Data: TableWSH.WSH_REGIONS
Subobject Name:
Status: VALID


Stores non-translated geographic region information including region codes and region hierarchy


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WSH_REGIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREGION_ID
WSH_REGIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_REGION_ID
WSH_REGIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREGION_TYPE
WSH_REGIONS_N3 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPPER("COUNTRY_CODE")
Columns
Name Datatype Length Mandatory Comments
REGION_ID NUMBER
Yes Primary Key for table
REGION_TYPE NUMBER
Yes Region type (0=country, 1=state, 2=city, 3=postal code, 10=zone, 11=parcel zone)
PARENT_REGION_ID NUMBER

Identification id for the region parent
COUNTRY_CODE VARCHAR2 (10)
Country code
COUNTRY_REGION_CODE VARCHAR2 (10)
Country region code
STATE_CODE VARCHAR2 (10)
State code
CITY_CODE VARCHAR2 (10)
City code
PORT_FLAG VARCHAR2 (1)
Port flag (for future use)
AIRPORT_FLAG VARCHAR2 (1)
Airport flag (for future use)
ROAD_TERMINAL_FLAG VARCHAR2 (1)
Road Terminal flag (for future use)
RAIL_TERMINAL_FLAG VARCHAR2 (1)
Rail Terminal flag (for future use)
LONGITUDE NUMBER

Longitude (for future use)
LATITUDE NUMBER

Latitude (for future use)
TIMEZONE VARCHAR2 (3)
Timezone (for future use)
ZONE_LEVEL NUMBER

Equivalent region level for a zone record
CREATED_BY NUMBER
Yes Who column
CREATION_DATE DATE
Yes Who column
LAST_UPDATED_BY NUMBER
Yes Who column
LAST_UPDATE_DATE DATE
Yes Who column
LAST_UPDATE_LOGIN NUMBER

Who column
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield Structure Defining Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment
DECONSOL_LOCATION_ID NUMBER

Stores the WSH location identifier for default deconsolidation location
Query Text

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


SELECT REGION_ID
,      REGION_TYPE
,      PARENT_REGION_ID
,      COUNTRY_CODE
,      COUNTRY_REGION_CODE
,      STATE_CODE
,      CITY_CODE
,      PORT_FLAG
,      AIRPORT_FLAG
,      ROAD_TERMINAL_FLAG
,      RAIL_TERMINAL_FLAG
,      LONGITUDE
,      LATITUDE
,      TIMEZONE
,      ZONE_LEVEL
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DECONSOL_LOCATION_ID
FROM WSH.WSH_REGIONS;

Dependencies

[top of page]

WSH.WSH_REGIONS does not reference any database object

WSH.WSH_REGIONS is referenced by following:

SchemaAPPS
SynonymWSH_REGIONS