Skip to content

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

TABLE: IEM.IEM_ARCH_MSGDTLS

Object Details
Object Name: IEM_ARCH_MSGDTLS
Object Type: TABLE
Owner: IEM
Subobject Name:
Status: VALID


Stores searchable header information of archived emails.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IEMARCH_MSGDTLS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMESSAGE_ID
Columns
Name Datatype Length Mandatory Comments
MESSAGE_ID NUMBER
Yes Message id.
INBOUND_MESSAGE_ID NUMBER (15)
Inbound message id.
EMAIL_ACCOUNT_ID NUMBER (15)
Email account id.
MAILPROC_STATUS VARCHAR2 (1)
Resolved/Send/Deleted.
RT_CLASSIFICATION_ID NUMBER (15)
Route classification id.
MAIL_TYPE NUMBER (15)
Inb/Outbound.
FROM_STR VARCHAR2 (2000)
From header string.
REPLY_TO_STR VARCHAR2 (2000)
Reply-to string.
TO_STR VARCHAR2 (2000)
To string.
CC_STR VARCHAR2 (2000)
Cc string.
BCC_STR VARCHAR2 (2000)
Bcc string.
SENT_DATE VARCHAR2 (60)
Sent date.
RECEIVED_DATE DATE

Received date.
SUBJECT VARCHAR2 (2000)
Subject
RESOURCE_ID NUMBER (15)
Resource id.
GROUP_ID NUMBER (15)
Group id.
MESSAGE_SIZE NUMBER (15)
Message size
IH_MEDIA_ITEM_ID NUMBER (15)
IH media item id.
TOP_INTENT VARCHAR2 (256)
Top intent.
CUSTOMER_ID NUMBER (15)
Customer id.
CONTACT_ID NUMBER (15)
Contact id.
RELATIONSHIP_ID NUMBER (15)
Relationship id.
MESSAGE_TEXT VARCHAR2 (4000)
Message text.
CREATED_BY NUMBER
Yes FND Who Columns
CREATION_DATE DATE
Yes FND Who Columns
LAST_UPDATED_BY NUMBER
Yes FND Who Columns
LAST_UPDATE_DATE DATE
Yes FND Who Columns
LAST_UPDATE_LOGIN NUMBER

FND Who Columns
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column.
SECURITY_GROUP_ID NUMBER (15)
Security group id.
Query Text

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


SELECT MESSAGE_ID
,      INBOUND_MESSAGE_ID
,      EMAIL_ACCOUNT_ID
,      MAILPROC_STATUS
,      RT_CLASSIFICATION_ID
,      MAIL_TYPE
,      FROM_STR
,      REPLY_TO_STR
,      TO_STR
,      CC_STR
,      BCC_STR
,      SENT_DATE
,      RECEIVED_DATE
,      SUBJECT
,      RESOURCE_ID
,      GROUP_ID
,      MESSAGE_SIZE
,      IH_MEDIA_ITEM_ID
,      TOP_INTENT
,      CUSTOMER_ID
,      CONTACT_ID
,      RELATIONSHIP_ID
,      MESSAGE_TEXT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
FROM IEM.IEM_ARCH_MSGDTLS;

Dependencies

[top of page]

IEM.IEM_ARCH_MSGDTLS does not reference any database object

IEM.IEM_ARCH_MSGDTLS is referenced by following:

SchemaIEM
ViewIEM_ARCH_MSGDTLS#