[Home] [Help] [Dependency Information]
Object Name: | EDW_INSTANCE_M |
---|---|
Object Type: | TABLE |
Owner: | BIS |
FND Design Data: | BIS.EDW_INSTANCE_M |
Subobject Name: | |
Status: | VALID |
This is the denormalized star table for the InstanceDimension. It contains records for the lowest level of the Instance dimension and their parentage up to the top level, across all hierarchies.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_INSTANCE_M_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
INST_INSTANCE_PK
INST_INSTANCE_PK_KEY |
EDW_INSTANCE_M_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY | INST_INSTANCE_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSA_ALL_PK_KEY | NUMBER | System generated unique identifier for the top level of the instance dimension | ||
INST_INSTANCE_PK_KEY | NUMBER | Yes | System generated unique identifier for the instance level | |
INSA_ALL_PK | VARCHAR2 | (40) | Unique identifier for the top level of the instance dimension | |
INSA_NAME | VARCHAR2 | (80) | All level name | |
INST_INSTANCE_PK | VARCHAR2 | (40) | Unique identifier for the instance level | |
INST_INSTANCE_DP | VARCHAR2 | (40) | Unique Instance Name | |
INST_NAME | VARCHAR2 | (80) | Instance Name | |
INST_DESCRIPTION | VARCHAR2 | (240) | Instance Description | |
INST_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
INST_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
INST_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
INST_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
INST_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. |
Cut, paste (and edit) the following text to query this object:
SELECT INSA_ALL_PK_KEY
, INST_INSTANCE_PK_KEY
, INSA_ALL_PK
, INSA_NAME
, INST_INSTANCE_PK
, INST_INSTANCE_DP
, INST_NAME
, INST_DESCRIPTION
, INST_USER_ATTRIBUTE1
, INST_USER_ATTRIBUTE2
, INST_USER_ATTRIBUTE3
, INST_USER_ATTRIBUTE4
, INST_USER_ATTRIBUTE5
, CREATION_DATE
, LAST_UPDATE_DATE
FROM BIS.EDW_INSTANCE_M;
BIS.EDW_INSTANCE_M does not reference any database object
BIS.EDW_INSTANCE_M is referenced by following:
|
|
|