[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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. |
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;
IEM.IEM_OUTBOUND_MSG_STATS does not reference any database object
IEM.IEM_OUTBOUND_MSG_STATS is referenced by following:
|
|
|