DBA Data[Home] [Help] [Dependency Information]

VIEW: IEM.IEM_SAFETY_QUEUES#

Object Details
Object Name: IEM_SAFETY_QUEUES#
Object Type: VIEW
Owner: IEM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
MESSAGE_ID NUMBER
Yes
MESSAGE_SIZE NUMBER

SENDER_NAME VARCHAR2 (128)
USER_NAME VARCHAR2 (256)
DOMAIN_NAME VARCHAR2 (128)
MESSAGE_PRIORITY VARCHAR2 (50)
MSG_STATUS VARCHAR2 (50)
SUBJECT VARCHAR2 (256)
CLASSIFICATION VARCHAR2 (50)
SCORE NUMBER

SENT_DATE DATE

CUSTOMER_ID NUMBER

PRODUCT_ID NUMBER

KEY1 VARCHAR2 (100)
VALUE1 VARCHAR2 (100)
KEY2 VARCHAR2 (100)
VALUE2 VARCHAR2 (100)
KEY3 VARCHAR2 (100)
VALUE3 VARCHAR2 (100)
KEY4 VARCHAR2 (100)
VALUE4 VARCHAR2 (100)
KEY5 VARCHAR2 (100)
VALUE5 VARCHAR2 (100)
KEY6 VARCHAR2 (100)
VALUE6 VARCHAR2 (100)
KEY7 VARCHAR2 (100)
VALUE7 VARCHAR2 (100)
KEY8 VARCHAR2 (100)
VALUE8 VARCHAR2 (100)
KEY9 VARCHAR2 (100)
VALUE9 VARCHAR2 (100)
KEY10 VARCHAR2 (100)
VALUE10 VARCHAR2 (100)
SECURITY_GROUP_ID NUMBER

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# references the following:

SchemaIEM
TableIEM_SAFETY_QUEUES
IEM.IEM_SAFETY_QUEUES# is referenced by following:

SchemaAPPS
SynonymIEM_SAFETY_QUEUES