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

TABLE: ECX.ECX_FILES

Object Details
Object Name: ECX_FILES
Object Type: TABLE
Owner: ECX
FND Design Data: TableECX.ECX_FILES
Subobject Name:
Status: VALID


This table contains XSLT Files


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ECX_FILES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnID
SYS_IL0000194132C00003$$ LOB UNIQUE TablespaceAPPS_TS_SEED
ECX_FILES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnTYPE
ColumnNAME
ColumnVERSION
ColumnAPPLICATION_CODE
Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PAYLOAD CLOB (4000)
actual content of the file
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
NAME VARCHAR2 (256) Yes name of file
VERSION NUMBER (15)
Version of the File
APPLICATION_CODE VARCHAR2 (256) Yes application code
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
TYPE VARCHAR2 (256) Yes file type i.e. XML ,XSLT,DTD's
ID NUMBER (15) Yes Unique identifier for the table
Query Text

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


SELECT LAST_UPDATE_LOGIN
,      CREATED_BY
,      PAYLOAD
,      CREATION_DATE
,      LAST_UPDATED_BY
,      NAME
,      VERSION
,      APPLICATION_CODE
,      LAST_UPDATE_DATE
,      TYPE
,      ID
FROM ECX.ECX_FILES;

Dependencies

[top of page]

ECX.ECX_FILES does not reference any database object

ECX.ECX_FILES is referenced by following:

SchemaAPPS
SynonymECX_FILES