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: FTE.FTE_BULKLOAD_DATA

Object Details

Object Name:	FTE_BULKLOAD_DATA
Object Type:	TABLE
Owner:	FTE
FND Design Data:	FTE.FTE_BULKLOAD_DATA
Subobject Name:
Status:	VALID

This table is used to store data related to download and upload for the Bulkload processing.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000194331C00007$$	LOB	UNIQUE	APPS_TS_INTERFACE
FTE_BULKLOAD_DATA_U1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	LOAD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LOAD_ID	NUMBER		Yes	Load Identifier
LOAD_TYPE	VARCHAR2	(20)	Yes	Type of Bulkload processing
FILE_TYPE	VARCHAR2	(10)	Yes	Type of File, which is to be upload or download
FILE_NAME	VARCHAR2	(200)		Name of the File, which is to be upload or download
FILE_SIZE	NUMBER			File Size
REQUEST_ID	NUMBER			Std Who Column
CONTENT	BLOB	(4000)		Content of the File
CREATED_BY	NUMBER		Yes	Std Who Column
CREATION_DATE	DATE		Yes	Std Who Column
LAST_UPDATED_BY	NUMBER		Yes	Std Who Column
LAST_UPDATE_DATE	DATE		Yes	Std Who Column
LAST_UPDATE_LOGIN	NUMBER			Std Who Column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOAD_ID
,      LOAD_TYPE
,      FILE_TYPE
,      FILE_NAME
,      FILE_SIZE
,      REQUEST_ID
,      CONTENT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM FTE.FTE_BULKLOAD_DATA;

Dependencies

[top of page]

FTE.FTE_BULKLOAD_DATA does not reference any database object

FTE.FTE_BULKLOAD_DATA is referenced by following:

FTE: FTE_BULKLOAD_DATA#