[Home] [Help] [Dependency Information]
Object Name: | FII_FA_EXP_CJE_IDS |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_FA_EXP_CJE_IDS |
Subobject Name: | |
Status: | VALID |
This table stores the processed identifiers for Assets journal submissions which have been extracted into the base summary. Once Journal Entries have been extracted or rolled back during the extract, the new rows stored in FII_FA_NEW_EXP_CJE_IDS are then inserted into this table for audit trail purposes.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FII_FA_EXP_CJE_IDS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CJE_EXP_ID |
FII_FA_EXP_CJE_IDS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BOOK_TYPE_CODE
PERIOD_COUNTER EXTRACT_STATUS_CODE |
FII_FA_EXP_CJE_IDS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CJE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CJE_EXP_ID | NUMBER | Yes | Entity Identifier | |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book Name |
PERIOD_COUNTER | NUMBER | Yes | Numeric identifier of the period for which journal entries was run | |
CJE_ID | NUMBER | Identifer of the Journal submission | ||
EXTRACT_STATUS_CODE | VARCHAR2 | (15) | Yes | Status of the Journal Entry submission for DBI |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT CJE_EXP_ID
, BOOK_TYPE_CODE
, PERIOD_COUNTER
, CJE_ID
, EXTRACT_STATUS_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM FII.FII_FA_EXP_CJE_IDS;
FII.FII_FA_EXP_CJE_IDS does not reference any database object
FII.FII_FA_EXP_CJE_IDS is referenced by following:
|
|
|