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_SAFETY_QUEUES

Object Details

Object Name:	IEM_SAFETY_QUEUES
Object Type:	TABLE
Owner:	IEM
FND Design Data:	IEM.IEM_SAFETY_QUEUES
Subobject Name:
Status:	VALID

This is a safety queue for an AQ post processing message. This table stores the AQ message object until it is safely transferred to MCM by the eMC server.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
MESSAGE_ID	NUMBER		Yes	Identifiers.
MESSAGE_SIZE	NUMBER			Email message specific data.
SENDER_NAME	VARCHAR2	(128)		Email message specific data.
USER_NAME	VARCHAR2	(256)		Email message specific data.
DOMAIN_NAME	VARCHAR2	(128)		Email message specific data.
MESSAGE_PRIORITY	VARCHAR2	(50)		Email message specific data.
MSG_STATUS	VARCHAR2	(50)		Email message specific data.
SUBJECT	VARCHAR2	(256)		Email message specific data.
CLASSIFICATION	VARCHAR2	(50)		Email message specific data.
SCORE	NUMBER			Email message specific data.
SENT_DATE	DATE			Email message specific data.
CUSTOMER_ID	NUMBER			Identifiers.
PRODUCT_ID	NUMBER			Identifiers.
KEY1	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
VALUE1	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
KEY2	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
VALUE2	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
KEY3	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
VALUE3	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
KEY4	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
VALUE4	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
KEY5	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
VALUE5	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
KEY6	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
VALUE6	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
KEY7	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
VALUE7	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
KEY8	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
VALUE8	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
KEY9	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
VALUE9	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
KEY10	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
VALUE10	VARCHAR2	(100)		Configurable key value pairs. These contain values that are not always present in every email.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT MESSAGE_ID
,      MESSAGE_SIZE
,      SENDER_NAME
,      USER_NAME
,      DOMAIN_NAME
,      MESSAGE_PRIORITY
,      MSG_STATUS
,      SUBJECT
,      CLASSIFICATION
,      SCORE
,      SENT_DATE
,      CUSTOMER_ID
,      PRODUCT_ID
,      KEY1
,      VALUE1
,      KEY2
,      VALUE2
,      KEY3
,      VALUE3
,      KEY4
,      VALUE4
,      KEY5
,      VALUE5
,      KEY6
,      VALUE6
,      KEY7
,      VALUE7
,      KEY8
,      VALUE8
,      KEY9
,      VALUE9
,      KEY10
,      VALUE10
,      SECURITY_GROUP_ID
FROM IEM.IEM_SAFETY_QUEUES;

Dependencies

[top of page]

IEM.IEM_SAFETY_QUEUES does not reference any database object

IEM.IEM_SAFETY_QUEUES is referenced by following:

IEM: IEM_SAFETY_QUEUES#