SELECT sequence_id,
mid_keltsd AS reason_message_id,
npm_keltsd AS reason_argument_count,
reason_argument_1,
reason_argument_2,
reason_argument_3,
reason_argument_4,
reason_argument_5,
amid_keltsd AS action_message_id,
anpm_keltsd AS action_argument_count,
action_argument_1,
action_argument_2,
action_argument_3,
action_argument_4,
action_argument_5
FROM wri$_alert_outstanding, X$KELTSD
WHERE reason_id = rid_keltsd
SELECT SEQUENCE_ID
,
MID_KELTSD AS REASON_MESSAGE_ID
,
NPM_KELTSD AS REASON_ARGUMENT_COUNT
,
REASON_ARGUMENT_1
,
REASON_ARGUMENT_2
,
REASON_ARGUMENT_3
,
REASON_ARGUMENT_4
,
REASON_ARGUMENT_5
,
AMID_KELTSD AS ACTION_MESSAGE_ID
,
ANPM_KELTSD AS ACTION_ARGUMENT_COUNT
,
ACTION_ARGUMENT_1
,
ACTION_ARGUMENT_2
,
ACTION_ARGUMENT_3
,
ACTION_ARGUMENT_4
,
ACTION_ARGUMENT_5
FROM WRI$_ALERT_OUTSTANDING
, X$KELTSD
WHERE REASON_ID = RID_KELTSD
|
|
|