[Home] [Help] [Dependency Information]
Object Name: | EDW_PA_PAEX_EXP_TYPE_LSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_PA_PAEX_EXP_TYPE_LSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for the Expenditure Type level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_PA_PAEX_EXP_TYPE_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | EXP_TYPE_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALL_FK_KEY | NUMBER | System generated foreign key to the top level | ||
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 | |
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
EXP_TYPE_NAME | VARCHAR2 | (120) | Expenditure type | |
EXP_TYPE_PK | VARCHAR2 | (120) | The unique identifier of the Expenditure Type | |
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
NAME | VARCHAR2 | (2000) | Expenditure type name | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine whether to insert/update/delete this record | |
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 | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. |
Cut, paste (and edit) the following text to query this object:
SELECT ALL_FK_KEY
, REQUEST_ID
, ALL_FK
, COLLECTION_STATUS
, ERROR_CODE
, EXP_TYPE_NAME
, EXP_TYPE_PK
, INSTANCE
, NAME
, OPERATION_CODE
, ROW_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, CREATION_DATE
, LAST_UPDATE_DATE
FROM FII.EDW_PA_PAEX_EXP_TYPE_LSTG;
FII.EDW_PA_PAEX_EXP_TYPE_LSTG does not reference any database object
FII.EDW_PA_PAEX_EXP_TYPE_LSTG is referenced by following:
|
|
|