[Home] [Help] [Dependency Information]
Object Name: | FII_FA_NEW_EXP_CJE_IDS |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_FA_NEW_EXP_CJE_IDS |
Subobject Name: | |
Status: | VALID |
This table stores the new identifiers for Assets journal submissions which have not yet been extracted into the base summary. It is used to indicate which journal entry submissions must be extracted or rolled back during the extract.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FII_FA_NEW_EXP_CJE_IDS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BOOK_TYPE_CODE
PERIOD_COUNTER EXTRACT_STATUS_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CJE_EXP_ID | NUMBER | 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_NEW_EXP_CJE_IDS;
FII.FII_FA_NEW_EXP_CJE_IDS does not reference any database object
FII.FII_FA_NEW_EXP_CJE_IDS is referenced by following:
|
|
|