[Home] [Help] [Dependency Information]
Object Name: | EDW_GEOG_REGION_LTC |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | BIS.EDW_GEOG_REGION_LTC
POA.EDW_GEOG_REGION_LTC |
Subobject Name: | |
Status: | VALID |
This is the Region level table in the Geography dimension. This level is not currently populated with data stored in Oracle Applications instances. Instead, information that is stored in the Country level is brought down to this level. The Region level is meant to hold information about geographical classifications that include more than one state but are within a single country. For example, this level may contain values for Western United states, Northern India, or Southern Brazil.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_GEOG_REGION_LTC_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | REGION_PK_KEY |
EDW_GEOG_REGION_LTC_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
REGION_PK
REGION_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COUNTRY_FK | VARCHAR2 | (240) | Foreign key to the Country level | |
COUNTRY_FK_KEY | NUMBER | System generated foreign key to the Country level | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
NAME | VARCHAR2 | (240) | Region name | |
REGION_DP | VARCHAR2 | (240) | Unique name for Region | |
REGION_PK | VARCHAR2 | (240) | Unique identifier for Region | |
REGION_PK_KEY | NUMBER | System generated unique identifier for Region | ||
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute |
Cut, paste (and edit) the following text to query this object:
SELECT COUNTRY_FK
, COUNTRY_FK_KEY
, CREATION_DATE
, INSTANCE
, LAST_UPDATE_DATE
, NAME
, REGION_DP
, REGION_PK
, REGION_PK_KEY
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM POA.EDW_GEOG_REGION_LTC;
POA.EDW_GEOG_REGION_LTC does not reference any database object
POA.EDW_GEOG_REGION_LTC is referenced by following:
|
|
|