VIEW: SYS.ALL_SYNC_CAPTURE

Source

View Text - Preformatted

select c."CAPTURE_NAME",c."QUEUE_NAME",c."QUEUE_OWNER",c."RULE_SET_NAME",c."RULE_SET_OWNER",c."CAPTURE_USER"
  from dba_sync_capture 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)))

View Text - HTML Formatted

SELECT C."CAPTURE_NAME"
, C."QUEUE_NAME"
, C."QUEUE_OWNER"
, C."RULE_SET_NAME"
, C."RULE_SET_OWNER"
, C."CAPTURE_USER"
FROM DBA_SYNC_CAPTURE 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)))