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

TABLE: ALR.ALR_RESPONSE_MESSAGES

Object Details
Object Name: ALR_RESPONSE_MESSAGES
Object Type: TABLE
Owner: ALR
FND Design Data: TableALR.ALR_RESPONSE_MESSAGES
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ALR_RESPONSE_MESSAGES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESPONSE_MESSAGE_ID
ALR_RESPONSE_MESSAGES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMESSAGE_HANDLE
ColumnNODE_HANDLE
ColumnAPPLICATION_ID
ColumnRESPONSE_SET_ID
ColumnRESPONSE_ID
Columns
Name Datatype Length Mandatory Comments
MESSAGE_HANDLE NUMBER
Yes
NODE_HANDLE NUMBER
Yes
APPLICATION_ID NUMBER
Yes
ALERT_ID NUMBER
Yes
RESPONSE_SET_ID NUMBER
Yes
RESPONSE_TYPE VARCHAR2 (1) Yes
RESPONSE_ID NUMBER

RESPONSE_MESSAGE_ID NUMBER
Yes
DATE_PROCESSED DATE
Yes
TO_RECIPIENTS VARCHAR2 (240)
CC_RECIPIENTS VARCHAR2 (240)
BCC_RECIPIENTS VARCHAR2 (240)
SENT_FROM VARCHAR2 (240)
REPLY_TO VARCHAR2 (240)
SUBJECT VARCHAR2 (240)
RECEIVED VARCHAR2 (240)
BODY LONG (0)
SECURITY_GROUP_ID NUMBER

Query Text

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


SELECT MESSAGE_HANDLE
,      NODE_HANDLE
,      APPLICATION_ID
,      ALERT_ID
,      RESPONSE_SET_ID
,      RESPONSE_TYPE
,      RESPONSE_ID
,      RESPONSE_MESSAGE_ID
,      DATE_PROCESSED
,      TO_RECIPIENTS
,      CC_RECIPIENTS
,      BCC_RECIPIENTS
,      SENT_FROM
,      REPLY_TO
,      SUBJECT
,      RECEIVED
,      BODY
,      SECURITY_GROUP_ID
FROM ALR.ALR_RESPONSE_MESSAGES;

Dependencies

[top of page]

ALR.ALR_RESPONSE_MESSAGES does not reference any database object

ALR.ALR_RESPONSE_MESSAGES is referenced by following:

SchemaAPPS
SynonymALR_RESPONSE_MESSAGES