VIEW: SYS.ALL_STREAMS_MESSAGE_RULES

Source

View Text - Preformatted

select mr."STREAMS_NAME",mr."STREAMS_TYPE",mr."MESSAGE_TYPE_NAME",mr."MESSAGE_TYPE_OWNER",mr."MESSAGE_RULE_VARIABLE",mr."RULE_NAME",mr."RULE_OWNER",mr."RULE_CONDITION"
  from dba_streams_message_rules mr, "_ALL_STREAMS_PROCESSES" p, all_rules ar
 where mr.rule_owner = ar.rule_owner
   and mr.rule_name  = ar.rule_name
   and mr.streams_name = p.streams_name
   and mr.streams_type = p.streams_type

View Text - HTML Formatted

SELECT MR."STREAMS_NAME"
, MR."STREAMS_TYPE"
, MR."MESSAGE_TYPE_NAME"
, MR."MESSAGE_TYPE_OWNER"
, MR."MESSAGE_RULE_VARIABLE"
, MR."RULE_NAME"
, MR."RULE_OWNER"
, MR."RULE_CONDITION"
FROM DBA_STREAMS_MESSAGE_RULES MR
, "_ALL_STREAMS_PROCESSES" P
, ALL_RULES AR
WHERE MR.RULE_OWNER = AR.RULE_OWNER
AND MR.RULE_NAME = AR.RULE_NAME
AND MR.STREAMS_NAME = P.STREAMS_NAME
AND MR.STREAMS_TYPE = P.STREAMS_TYPE