[Home] [Help] [Dependency Information]
Object Name: | IEM_RT_MEDIA_ITEMS |
---|---|
Object Type: | TABLE |
Owner: | IEM |
Subobject Name: | |
Status: | VALID |
Contains information about individual messages that belong to an interacion
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEM_RT_MEDIA_ITEMS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | RT_MEDIA_ITEM_ID |
IEM_RT_MEDIA_ITEMS_U2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RT_INTERACTION_ID
EMAIL_TYPE |
IEM_RT_MEDIA_ITEMS_U3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MESSAGE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RT_MEDIA_ITEM_ID | NUMBER | (15) | Yes | Primary key |
RT_INTERACTION_ID | NUMBER | (15) | RT interaction ID | |
RESOURCE_ID | NUMBER | (15) | Resource ID | |
MEDIA_ID | NUMBER | (15) | Media item ID from Interaction history table | |
MESSAGE_ID | NUMBER | Message ID from OES | ||
RFC822_MESSAGE_ID | VARCHAR2 | (255) | SMTP ID | |
FOLDER_UID | NUMBER | Folder UID | ||
FOLDER_NAME | VARCHAR2 | (255) | Folder Name | |
EMAIL_ACCOUNT_ID | NUMBER | (15) | Email Account ID | |
AGENT_ACCOUNT_ID | NUMBER | (15) | Agent account ID | |
DB_SERVER_ID | NUMBER | (15) | Database Server ID | |
EMAIL_TYPE | VARCHAR2 | (1) | Inbound I; Outbound O; Reply/Draft R | |
STATUS | VARCHAR2 | (1) | Delete D; Send S; Transfer T; Reroute R;Forward F; Move M | |
EXPIRE | VARCHAR2 | (1) | Expire ID | |
VERSION | NUMBER | Version 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 | |
SECURITY_GROUP_ID | NUMBER | Security Group ID for hosted system | ||
EDIT_MODE | VARCHAR2 | (1) | Edit mode. Valid values (H-html, T-text) |
Cut, paste (and edit) the following text to query this object:
SELECT RT_MEDIA_ITEM_ID
, RT_INTERACTION_ID
, RESOURCE_ID
, MEDIA_ID
, MESSAGE_ID
, RFC822_MESSAGE_ID
, FOLDER_UID
, FOLDER_NAME
, EMAIL_ACCOUNT_ID
, AGENT_ACCOUNT_ID
, DB_SERVER_ID
, EMAIL_TYPE
, STATUS
, EXPIRE
, VERSION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, EDIT_MODE
FROM IEM.IEM_RT_MEDIA_ITEMS;
IEM.IEM_RT_MEDIA_ITEMS does not reference any database object
IEM.IEM_RT_MEDIA_ITEMS is referenced by following:
|
|
|