[Home] [Help] [Dependency Information]
Object Name: | EDW_PA_EXP_TYPE_M |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_PA_EXP_TYPE_M |
Subobject Name: | |
Status: | VALID |
This is the denormalized star table for the Project Expenditure Type dimension. It contains records for the lowest level of this 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_PA_EXP_TYPE_M_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
EXPT_EXP_TYPE_PK
EXPT_EXP_TYPE_PK_KEY |
EDW_PA_EXP_TYPE_M_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY | EXPT_EXP_TYPE_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXPT_EXP_TYPE_PK_KEY | NUMBER | Yes | System generated unique identifier of the Expenditure Type | |
ALL_ALL_PK_KEY | NUMBER | System generated unique identifier for level ALL | ||
EXPT_EXP_TYPE_NAME | VARCHAR2 | (120) | Expenditure type | |
EXPT_EXP_TYPE_PK | VARCHAR2 | (120) | The user identifier of the Expenditure Type | |
EXPT_INSTANCE | VARCHAR2 | (40) | Instance identifier | |
EXPT_NAME | VARCHAR2 | (2000) | Expenditure type name | |
EXPT_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
EXPT_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
EXPT_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
EXPT_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
EXPT_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
ALL_ALL_PK | VARCHAR2 | (40) | The unique identifier for level ALL | |
ALL_NAME | VARCHAR2 | (80) | All Levels Name | |
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 EXPT_EXP_TYPE_PK_KEY
, ALL_ALL_PK_KEY
, EXPT_EXP_TYPE_NAME
, EXPT_EXP_TYPE_PK
, EXPT_INSTANCE
, EXPT_NAME
, EXPT_USER_ATTRIBUTE1
, EXPT_USER_ATTRIBUTE2
, EXPT_USER_ATTRIBUTE3
, EXPT_USER_ATTRIBUTE4
, EXPT_USER_ATTRIBUTE5
, ALL_ALL_PK
, ALL_NAME
, CREATION_DATE
, LAST_UPDATE_DATE
FROM FII.EDW_PA_EXP_TYPE_M;
FII.EDW_PA_EXP_TYPE_M does not reference any database object
FII.EDW_PA_EXP_TYPE_M is referenced by following:
|
|
|