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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PK_ETRM_FILES
  1. ColumnFILE_ID
Unique Key: UK_ETRM_FILES
  1. ColumnAPPLICATION_ID
  2. ColumnFILE_NAME
Indexes
Index Type Uniqueness Tablespace Column
PK_ETRM_FILES NORMAL UNIQUE TablespaceAPPS_TS_TX_DATA ColumnFILE_ID
SYS_IL0000497673C00007$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
UK_ETRM_FILES NORMAL UNIQUE TablespaceAPPS_TS_TX_DATA ColumnAPPLICATION_ID
ColumnFILE_NAME
FND_ETRM_FILE_DESC DOMAIN NONUNIQUE Tablespace ColumnDESCRIPTION
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:

SchemaAPPLSYS
TriggerDR$FND_ETRM_FILE_DESCTC
SchemaPUBLIC
SynonymFND_ETRM_FILES