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_MSG_PARTS

Object Details

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

Contains various MIME parts of the message used for Caching and displaying.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000241981C00005$$	LOB	UNIQUE	APPS_TS_TX_DATA
IEM_MSG_PARTS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REF_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
REF_KEY	NUMBER	(15)	Yes	Foreign key to IEM_RT_MEDIA_ITEMS.
PART_INFO	VARCHAR2	(128)		Programmatic information regarding the part.
PART_TYPE	VARCHAR2	(32)	Yes	Descripbes the type of message part.
PART_NAME	VARCHAR2	(80)		Used for an attached email subject or content id for an attachment.
PART_DATA	BLOB	(4000)		The binary data of the part.
DELETE_FLAG	VARCHAR2	(1)		Y or N. Indicates whether this row should be deleted by a backend process.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
SECURITY_GROUP_ID	NUMBER			Standard SGID column.

Query Text

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


SELECT REF_KEY
,      PART_INFO
,      PART_TYPE
,      PART_NAME
,      PART_DATA
,      DELETE_FLAG
,      LAST_UPDATE_DATE
,      SECURITY_GROUP_ID
FROM IEM.IEM_MSG_PARTS;

Dependencies

[top of page]

IEM.IEM_MSG_PARTS does not reference any database object

IEM.IEM_MSG_PARTS is referenced by following:

APPS: IEM_MSG_PARTS