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]

TYPE: SYSTEM.IEM_MSGP_TYP

Object Details

Object Name:	IEM_MSGP_TYP
Object Type:	TYPE
Owner:	SYSTEM
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
MSG_ID	NUMBER
MSG_SIZE	NUMBER
SENDER_NAME	VARCHAR2	(128)
USER_NAME	VARCHAR2	(256)
DOMAIN_NAME	VARCHAR2	(128)
PRIORITY	VARCHAR2	(50)
MSG_STATUS	VARCHAR2	(50)
SUBJECT	VARCHAR2	(256)
SENT_DATE	DATE
CUSTOMER_ID	NUMBER
PRODUCT_ID	NUMBER
CLASSIFICATION	VARCHAR2	(128)
SCORE_PERCENT	NUMBER
INFO_ID	NUMBER
KEY1	VARCHAR2	(256)
VAL1	VARCHAR2	(256)
KEY2	VARCHAR2	(256)
VAL2	VARCHAR2	(256)
KEY3	VARCHAR2	(256)
VAL3	VARCHAR2	(256)
KEY4	VARCHAR2	(256)
VAL4	VARCHAR2	(256)
KEY5	VARCHAR2	(256)
VAL5	VARCHAR2	(256)
KEY6	VARCHAR2	(256)
VAL6	VARCHAR2	(256)
KEY7	VARCHAR2	(256)
VAL7	VARCHAR2	(256)
KEY8	VARCHAR2	(256)
VAL8	VARCHAR2	(256)
KEY9	VARCHAR2	(256)
VAL9	VARCHAR2	(256)
KEY10	VARCHAR2	(256)
VAL10	VARCHAR2	(256)

Dependencies

[top of page]

SYSTEM.IEM_MSGP_TYP references the following:

SYS: STANDARD - show dependent code

SYSTEM.IEM_MSGP_TYP is referenced by following:

IEM: AQ$IEMP_QUEUE_TBL; AQ$_IEMP_QUEUE_TBL_F; IEMP_QUEUE_TBL