[Home] [Help] [Dependency Information]
Object Name: | FND_IREP_DEFERRED_LOAD_FILES |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_IREP_DEFERRED_LOAD_FILES |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_IREP_DEFERRED_LOAD_FS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FILE_PRODUCT
FILE_PATH FILE_NAME FILE_VERSION |
FND_IREP_DEFERRED_LOAD_FS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
LOAD_STATUS
REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FILE_PRODUCT | VARCHAR2 | (8) | Yes | File's product top |
FILE_PATH | VARCHAR2 | (100) | Yes | File's path |
FILE_NAME | VARCHAR2 | (150) | Yes | File's name |
FILE_VERSION | VARCHAR2 | (150) | Yes | File's source control revision |
LOAD_STATUS | VARCHAR2 | (1) | Yes | Status of file |
LOAD_ERRORS | VARCHAR2 | (4000) | Errors encountered during load | |
LOAD_START | DATE | Start time of last load attempt | ||
LOAD_FINISH | DATE | End time of last load attempt | ||
REQUEST_ID | NUMBER | Request ID for last load attempt | ||
LOG_FILE | VARCHAR2 | (150) | Log file from last load attempt | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | 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) | Yes | Standard who column |
BATCH_ID | NUMBER | Batch ID from FNDLOAD batch used for last load attempt |
Cut, paste (and edit) the following text to query this object:
SELECT FILE_PRODUCT
, FILE_PATH
, FILE_NAME
, FILE_VERSION
, LOAD_STATUS
, LOAD_ERRORS
, LOAD_START
, LOAD_FINISH
, REQUEST_ID
, LOG_FILE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, BATCH_ID
FROM APPLSYS.FND_IREP_DEFERRED_LOAD_FILES;
APPLSYS.FND_IREP_DEFERRED_LOAD_FILES does not reference any database object
APPLSYS.FND_IREP_DEFERRED_LOAD_FILES is referenced by following:
|
|
|