VIEW: SYS.ALL_STREAMS_MESSAGE_CONSUMERS

Source

View Text - Preformatted

select c."STREAMS_NAME",c."QUEUE_NAME",c."QUEUE_OWNER",c."RULE_SET_NAME",c."RULE_SET_OWNER",c."NEGATIVE_RULE_SET_NAME",c."NEGATIVE_RULE_SET_OWNER",c."NOTIFICATION_TYPE",c."NOTIFICATION_ACTION",c."NOTIFICATION_CONTEXT"
  from dba_streams_message_consumers c, all_queues q
 where c.queue_name = q.name
   and c.queue_owner = q.owner
   and ((c.rule_set_owner is null and c.rule_set_name is null) or
        ((c.rule_set_owner, c.rule_set_name) in
          (select r.rule_set_owner, r.rule_set_name
             from all_rule_sets r)))
   and ((c.negative_rule_set_owner is null and
         c.negative_rule_set_name is null) or
        ((c.negative_rule_set_owner, c.negative_rule_set_name) in
          (select r.rule_set_owner, r.rule_set_name
             from all_rule_sets r)))

View Text - HTML Formatted

SELECT C."STREAMS_NAME"
, C."QUEUE_NAME"
, C."QUEUE_OWNER"
, C."RULE_SET_NAME"
, C."RULE_SET_OWNER"
, C."NEGATIVE_RULE_SET_NAME"
, C."NEGATIVE_RULE_SET_OWNER"
, C."NOTIFICATION_TYPE"
, C."NOTIFICATION_ACTION"
, C."NOTIFICATION_CONTEXT"
FROM DBA_STREAMS_MESSAGE_CONSUMERS C
, ALL_QUEUES Q
WHERE C.QUEUE_NAME = Q.NAME
AND C.QUEUE_OWNER = Q.OWNER
AND ((C.RULE_SET_OWNER IS NULL
AND C.RULE_SET_NAME IS NULL) OR ((C.RULE_SET_OWNER
, C.RULE_SET_NAME) IN (SELECT R.RULE_SET_OWNER
, R.RULE_SET_NAME
FROM ALL_RULE_SETS R)))
AND ((C.NEGATIVE_RULE_SET_OWNER IS NULL AND C.NEGATIVE_RULE_SET_NAME IS NULL) OR ((C.NEGATIVE_RULE_SET_OWNER
, C.NEGATIVE_RULE_SET_NAME) IN (SELECT R.RULE_SET_OWNER
, R.RULE_SET_NAME
FROM ALL_RULE_SETS R)))