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


TABLE: MSC.MSC_REGIONS

Object Details
Object Name: MSC_REGIONS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_REGIONS
Subobject Name:
Status: VALID

This table contains geographical regions data

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_REGIONS_N1 FUNCTION-BASED NORMAL NONUNIQUE Tablespace ColumnUPPER("COUNTRY")
MSC_REGIONS_N2 NORMAL NONUNIQUE Tablespace ColumnREGION_ID
ColumnSR_INSTANCE_ID
ColumnZONE_USAGE
MSC_REGIONS_N3 FUNCTION-BASED NORMAL NONUNIQUE Tablespace ColumnUPPER("CITY")
Columns
Name Datatype Length Mandatory Comments
REGION_ID NUMBER
Yes Region Id
REGION_TYPE NUMBER
Yes Region Type
PARENT_REGION_ID NUMBER

Parent Region Id
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
AIRPORT_FLAG VARCHAR2 (1)
Airport Flag
ROAD_TERMINAL_FLAG VARCHAR2 (1)
Road Terminal Flag
RAIL_TERMINAL_FLAG VARCHAR2 (1)
Rail Terminal Flag
LONGITUDE NUMBER

Longitude
TIMEZONE VARCHAR2 (3)
Timezone
SR_INSTANCE_ID NUMBER
Yes Source Instance Id
REFRESH_NUMBER NUMBER

Refresh Number
CREATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
REQUEST_ID NUMBER

Concurrent WHO column
PROGRAM_APPLICATION_ID NUMBER

Concurrent WHO column
PROGRAM_ID NUMBER

Concurrent WHO column
PROGRAM_UPDATE_DATE DATE

Concurrent WHO column
LATITUDE NUMBER

Latitude
CONTINENT VARCHAR2 (60)
Continent
COUNTRY VARCHAR2 (60)
Country
COUNTRY_REGION VARCHAR2 (60)
Country Region
STATE VARCHAR2 (60)
State
CITY VARCHAR2 (60)
City
ZONE VARCHAR2 (60)
Zone
ZONE_LEVEL NUMBER

Zone Level
POSTAL_CODE_FROM VARCHAR2 (30)
Postal Code From
POSTAL_CODE_TO VARCHAR2 (30)
Postal Code To
ALTERNATE_NAME VARCHAR2 (60)
Alternate Name
COUNTY VARCHAR2 (60)
County
ZONE_USAGE NUMBER

SR_INSTANCE_CODE VARCHAR2 (3)
DELETED_FLAG NUMBER

PROCESS_FLAG NUMBER

DATA_SOURCE_TYPE VARCHAR2 (15)
ST_TRANSACTION_ID NUMBER

ERROR_TEXT VARCHAR2 (2000)
BATCH_ID NUMBER

MESSAGE_ID NUMBER

COMPANY_NAME VARCHAR2 (255)
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
,      TIMEZONE
,      SR_INSTANCE_ID
,      REFRESH_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LATITUDE
,      CONTINENT
,      COUNTRY
,      COUNTRY_REGION
,      STATE
,      CITY
,      ZONE
,      ZONE_LEVEL
,      POSTAL_CODE_FROM
,      POSTAL_CODE_TO
,      ALTERNATE_NAME
,      COUNTY
,      ZONE_USAGE
,      SR_INSTANCE_CODE
,      DELETED_FLAG
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      ERROR_TEXT
,      BATCH_ID
,      MESSAGE_ID
,      COMPANY_NAME
FROM MSC.MSC_REGIONS;

Dependencies

[top of page]

MSC.MSC_REGIONS does not reference any database object

MSC.MSC_REGIONS is referenced by following:

SchemaAPPS
SynonymMSC_REGIONS