eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_IREP_DEFERRED_LOAD_FILES

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: FND_IREP_DEFERRED_LOAD_FS_PK

FILE_PRODUCT
FILE_PATH
FILE_NAME
FILE_VERSION

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

APPLSYS.FND_IREP_DEFERRED_LOAD_FILES does not reference any database object

APPLSYS.FND_IREP_DEFERRED_LOAD_FILES is referenced by following:

APPS: FND_IREP_DEFERRED_LOAD_FILES