[Home] [Help] [Dependency Information]
Object Name: | EDW_PROJ_PRJ_TYP_LSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_PROJ_PRJ_TYP_LSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for project type level table. Before project type information is loaded into the warehouse, data is temporarily held in the staging table for verification and cleansing.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_PROJ_PRJ_TYP_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PRJ_TYP_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALL_FK_KEY | NUMBER | System generated foreign Key to the top level of the project dimension | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
ALL_FK | VARCHAR2 | (40) | Foreign Key to the top level of the project dimension | |
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
NAME | VARCHAR2 | (2000) | Project type name | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine whether to insert/update/delete this record | |
PRJ_TYP_PK | VARCHAR2 | (80) | The unique identifier of the project type | |
PROJECT_TYPE | VARCHAR2 | (80) | Project type | |
ROW_ID | ROWID | (10) | Row identifier | |
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 | |
DELETION_DATE | DATE | Deletion date of the record |
Cut, paste (and edit) the following text to query this object:
SELECT ALL_FK_KEY
, REQUEST_ID
, ALL_FK
, COLLECTION_STATUS
, ERROR_CODE
, INSTANCE
, NAME
, OPERATION_CODE
, PRJ_TYP_PK
, PROJECT_TYPE
, ROW_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, DELETION_DATE
FROM FII.EDW_PROJ_PRJ_TYP_LSTG;
FII.EDW_PROJ_PRJ_TYP_LSTG does not reference any database object
FII.EDW_PROJ_PRJ_TYP_LSTG is referenced by following:
|
|
|