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_ETRM_FILES

Object Details

Object Name:	FND_ETRM_FILES
Object Type:	TABLE
Owner:	APPLSYS
Subobject Name:
Status:	VALID

Used to store files that are included in the eTRM.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PK_ETRM_FILES

FILE_ID

Unique Key: UK_ETRM_FILES

APPLICATION_ID
FILE_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
PK_ETRM_FILES	NORMAL	UNIQUE	APPS_TS_TX_DATA	FILE_ID
SYS_IL0001045686C00007$$	LOB	UNIQUE	APPS_TS_TX_DATA
UK_ETRM_FILES	NORMAL	UNIQUE	APPS_TS_TX_DATA	APPLICATION_ID FILE_NAME
FND_ETRM_FILE_DESC	DOMAIN	NONUNIQUE		DESCRIPTION

Columns

Name	Datatype	Length	Mandatory	Comments
FILE_ID	NUMBER	(16)	Yes	Primary Key populated by sequence fnd_etrm_files_seq
APPLICATION_ID	NUMBER	(22)	Yes	FK to FND_APPLICATION
FILE_NAME	VARCHAR2	(256)	Yes	File name
FILE_TYPE	VARCHAR2	(64)	Yes	Report, Diagram or Internal
FILE_CONTENT_TYPE	VARCHAR2	(256)	Yes	MIME Content disposition default "application/octet-stream"
DESCRIPTION	VARCHAR2	(2000)		Short description of the file indexed to search engine
FILE_CONTENT	BLOB	(4000)		The file content

Query Text

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


SELECT FILE_ID
,      APPLICATION_ID
,      FILE_NAME
,      FILE_TYPE
,      FILE_CONTENT_TYPE
,      DESCRIPTION
,      FILE_CONTENT
FROM APPLSYS.FND_ETRM_FILES;

Dependencies

[top of page]

APPLSYS.FND_ETRM_FILES does not reference any database object

APPLSYS.FND_ETRM_FILES is referenced by following:

APPLSYS: DR$FND_ETRM_FILE_DESCTC
PUBLIC: FND_ETRM_FILES