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

TABLE: ECX.ECX_ATTACHMENT_MAPS

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


The table records correlation mappings between main business documents and their assciated attachments. It is used by the OTA and XML-Gateway engine.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ECX_ATTACHMENT_MAPS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMSGID
ColumnCID
Columns
Name Datatype Length Mandatory Comments
MSGID RAW (16) Yes This is the message id
CID VARCHAR2 (256) Yes Content Id through whic user uniquely identifies the attachment
FID NUMBER
Yes File Id of attachment
DATATYPE NUMBER
Yes This type of attachment files
ORDERINDEX NUMBER

This is the order index of attachments
NESTPARENTINDEX NUMBER

This is nest parent index
Query Text

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


SELECT MSGID
,      CID
,      FID
,      DATATYPE
,      ORDERINDEX
,      NESTPARENTINDEX
FROM ECX.ECX_ATTACHMENT_MAPS;

Dependencies

[top of page]

ECX.ECX_ATTACHMENT_MAPS does not reference any database object

ECX.ECX_ATTACHMENT_MAPS is referenced by following:

SchemaECX
ViewECX_ATTACHMENT_MAPS#