eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IEM.IEM_PRE_MDTS

Object Details

Object Name:	IEM_PRE_MDTS
Object Type:	TABLE
Owner:	IEM
Subobject Name:
Status:	VALID

Stores Pre processed Meta Data information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEM_PRE_MDTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	MESSAGE_ID
IEM_PRE_MDTS_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
MESSAGE_ID	NUMBER	(15)	Yes	Message Id
MESSAGE_SIZE	NUMBER	(15)		Size of the message
SENDER_NAME	VARCHAR2	(128)		Name of the sender
USER_NAME	VARCHAR2	(256)		Name of the Account where the mesage originated
DOMAIN_NAME	VARCHAR2	(128)		Name of the domain to which the account belongs
PRIORITY	VARCHAR2	(20)		Priority of the message
MSG_STATUS	VARCHAR2	(50)		Status of the message
SUBJECT	VARCHAR2	(240)		Subject of the message
SENT_DATE	DATE			Date when message was sent
CUSTOMER_ID	NUMBER	(15)		Customer Identification
PRODUCT_ID	NUMBER			Product Indentification
EMAIL_CLASSIFICATION	VARCHAR2	(50)		Name of the Top Classification for the message
SCORE_PERCENT	NUMBER			Score of the classification
ICENTER_MAP_ID	NUMBER	(15)		Interaction Center Map Id
EMAIL_ACCOUNT_ID	NUMBER	(15)		Unique identification of the account
RT_CLASSIFICATION_ID	NUMBER	(15)		Route Classification Id
RFC822_MESSAGE_ID	VARCHAR2	(300)		Internal Indentification of the message
MESSAGE_UID	NUMBER	(15)		Message identifier
LANGUAGE	VARCHAR2	(50)		Langauge of the message
CONTENT_TYPE	VARCHAR2	(300)		Content type of the message
MAILER	VARCHAR2	(300)		Name of the Mailer
ORGANIZATION	VARCHAR2	(100)		Name fo the Oraganization
DFLT_AGT_ID	NUMBER	(15)		Default Agent Id
MESSAGE_TYPE	VARCHAR2	(30)		Type of the message
RECEIVED_DATE	DATE			Date when the message entered the system
SOURCE_MESSAGE_ID	NUMBER	(15)		OES Message ID
ATTRIBUTE1	VARCHAR2	(150)		Attribute column number 1 descriptive flexfild segment
ATTRIBUTE2	VARCHAR2	(150)		Attribute column number 2 descriptive flexfild segment
ATTRIBUTE3	VARCHAR2	(150)		Attribute column number 3 descriptive flexfild segment
ATTRIBUTE4	VARCHAR2	(150)		Attribute column number 4 descriptive flexfild segment
ATTRIBUTE5	VARCHAR2	(150)		Attribute column number 5 descriptive flexfild segment
ATTRIBUTE6	VARCHAR2	(150)		Attribute column number 6 descriptive flexfild segment
ATTRIBUTE7	VARCHAR2	(150)		Attribute column number 7 descriptive flexfild segment
ATTRIBUTE8	VARCHAR2	(150)		Attribute column number 8 descriptive flexfild segment
ATTRIBUTE9	VARCHAR2	(150)		Attribute column number 9 descriptive flexfild segment
ATTRIBUTE10	VARCHAR2	(150)		Attribute column number 10 descriptive flexfild segment
ATTRIBUTE11	VARCHAR2	(150)		Attribute column number 11 descriptive flexfild segment
ATTRIBUTE12	VARCHAR2	(150)		Attribute column number 12 descriptive flexfild segment
ATTRIBUTE13	VARCHAR2	(150)		Attribute column number 13 descriptive flexfild segment
ATTRIBUTE14	VARCHAR2	(150)		Attribute column number 14 descriptive flexfild segment
ATTRIBUTE15	VARCHAR2	(150)		Attribute column number 15 descriptive flexfild segment
SECURITY_GROUP_ID	NUMBER			Security group ID
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
IH_MEDIA_ITEM_ID	NUMBER	(15)		Interaction Media item Id.
IH_INTERACTION_ID	NUMBER	(15)		Interaction Id of the old interaction in case of re-route.
TO_ADDRESS	VARCHAR2	(240)		To address of the email header.

Query Text

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


SELECT MESSAGE_ID
,      MESSAGE_SIZE
,      SENDER_NAME
,      USER_NAME
,      DOMAIN_NAME
,      PRIORITY
,      MSG_STATUS
,      SUBJECT
,      SENT_DATE
,      CUSTOMER_ID
,      PRODUCT_ID
,      EMAIL_CLASSIFICATION
,      SCORE_PERCENT
,      ICENTER_MAP_ID
,      EMAIL_ACCOUNT_ID
,      RT_CLASSIFICATION_ID
,      RFC822_MESSAGE_ID
,      MESSAGE_UID
,      LANGUAGE
,      CONTENT_TYPE
,      MAILER
,      ORGANIZATION
,      DFLT_AGT_ID
,      MESSAGE_TYPE
,      RECEIVED_DATE
,      SOURCE_MESSAGE_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      IH_MEDIA_ITEM_ID
,      IH_INTERACTION_ID
,      TO_ADDRESS
FROM IEM.IEM_PRE_MDTS;

Dependencies

[top of page]

IEM.IEM_PRE_MDTS does not reference any database object

IEM.IEM_PRE_MDTS is referenced by following:

APPS: IEM_PRE_MDTS