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_OUTBOUND_MSG_STATS

Object Details

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

This table stores one row per outbound email to track email statistics.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEM_OUBOUND_MSG_STATS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OUTBOUND_MSG_STATS_ID
IEM_OUTBOUND_MSG_STATS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	MEDIA_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OUTBOUND_MSG_STATS_ID	NUMBER	(15)	Yes	Primary Key.
MEDIA_ID	NUMBER	(15)		Id of the outbound media item this email is tied to.
INBOUND_MEDIA_ID	NUMBER	(15)		Id of the inbound media item this email is tied to.
USES_SUGGESTIONS_Y_N	VARCHAR2	(1)		Indicates if the email used the response documents suggested by processing engine.
AUTO_REPLIED_Y_N	VARCHAR2	(1)		Indicates if the email was a reply autmatically generated by processing engine or manually by an agent.
USES_KB_DOCS_Y_N	VARCHAR2	(1)		Indicates if the email used documents available in the repository.
AGENT_ID	NUMBER	(15)		Resource Id who sent this outbound email.
OUTBOUND_METHOD	NUMBER			Lookup valu.
EMAIL_ACCOUNT_ID	NUMBER	(15)		Id of the Email account from which this email was sent out.
CUSTOMER_ID	NUMBER	(15)		PARTY_ID asociated with this outbound email.
CONTACT_ID	NUMBER	(15)		CONTACT_ID associated with this outbound email.
DATE_SENT	DATE			Date stamp when this email was sent out.
EXPIRE_Y_N	VARCHAR2	(1)		Intended flag for cleanup.
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			Security group Id.

Query Text

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


SELECT OUTBOUND_MSG_STATS_ID
,      MEDIA_ID
,      INBOUND_MEDIA_ID
,      USES_SUGGESTIONS_Y_N
,      AUTO_REPLIED_Y_N
,      USES_KB_DOCS_Y_N
,      AGENT_ID
,      OUTBOUND_METHOD
,      EMAIL_ACCOUNT_ID
,      CUSTOMER_ID
,      CONTACT_ID
,      DATE_SENT
,      EXPIRE_Y_N
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM IEM.IEM_OUTBOUND_MSG_STATS;

Dependencies

[top of page]

IEM.IEM_OUTBOUND_MSG_STATS does not reference any database object

IEM.IEM_OUTBOUND_MSG_STATS is referenced by following:

APPS: IEM_OUTBOUND_MSG_STATS