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

TABLE: IEM.IEM_MS_BASE_HEADERS

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


Stores base-headers of an email.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IEM_MS_BASE_HEADERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMESSAGE_ID
Columns
Name Datatype Length Mandatory Comments
MESSAGE_ID NUMBER (15) Yes Unique message id.
EMAIL_ACCOUNT_ID NUMBER (15)
Email account id.
SUBJECT VARCHAR2 (2000)
Subject rfc822 header.
MESSAGE_SIZE NUMBER (15)
Message size
SENT_DATE VARCHAR2 (60)
Sent date rfc822 header.
RECEIVED_DATE DATE

Received date.
FROM_STR VARCHAR2 (2000)
From header of the email.
TO_STR VARCHAR2 (2000)
To header of the email.
CC_STR VARCHAR2 (2000)
Cc header of the email.
REPLY_TO_STR VARCHAR2 (256)
Reply-To header of the email.
PRIORITY VARCHAR2 (256)
Priority.
RFC822_MESSAGE_ID VARCHAR2 (256)
Rfc822 message id.
MESSAGE_UID NUMBER (15)
Message UID.
MAILER VARCHAR2 (256)
Mailer.
LANGUAGE VARCHAR2 (256)
Language header.
CONTENT_TYPE VARCHAR2 (256)
Content-type header.
ORGANIZATION VARCHAR2 (256)
Organization header of the email.
CREATED_BY NUMBER (15) Yes FND Who columns.
CREATION_DATE DATE
Yes FND Who columns.
LAST_UPDATED_BY NUMBER (15) Yes FND Who columns.
LAST_UPDATE_DATE DATE
Yes FND Who columns.
LAST_UPDATE_LOGIN NUMBER (15)
FND Who columns.
SECURITY_GROUP_ID NUMBER (15)
Security group id.
Query Text

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


SELECT MESSAGE_ID
,      EMAIL_ACCOUNT_ID
,      SUBJECT
,      MESSAGE_SIZE
,      SENT_DATE
,      RECEIVED_DATE
,      FROM_STR
,      TO_STR
,      CC_STR
,      REPLY_TO_STR
,      PRIORITY
,      RFC822_MESSAGE_ID
,      MESSAGE_UID
,      MAILER
,      LANGUAGE
,      CONTENT_TYPE
,      ORGANIZATION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM IEM.IEM_MS_BASE_HEADERS;

Dependencies

[top of page]

IEM.IEM_MS_BASE_HEADERS does not reference any database object

IEM.IEM_MS_BASE_HEADERS is referenced by following:

SchemaAPPS
SynonymIEM_MS_BASE_HEADERS