VIEW: SYS._ALL_STREAMS_PROCESSES

Source

View Text - Preformatted

select 'CAPTURE' streams_type,
       capture_name, rule_set_owner, rule_set_name,
       negative_rule_set_owner, negative_rule_set_name
  from all_capture
union all
select 'SYNC_CAPTURE' streams_type,
       capture_name, rule_set_owner, rule_set_name,
       null negative_rule_set_owner, null negative_rule_set_name
  from all_sync_capture
union all
select 'APPLY', apply_name, rule_set_owner, rule_set_name,
       negative_rule_set_owner, negative_rule_set_name
  from all_apply
union all
select 'PROPAGATION', propagation_name, rule_set_owner, rule_set_name,
       negative_rule_set_owner, negative_rule_set_name
  from all_propagation
union all
select 'DEQUEUE', streams_name, rule_set_owner, rule_set_name,
       negative_rule_set_owner, negative_rule_set_name
  from all_streams_message_consumers

View Text - HTML Formatted

SELECT 'CAPTURE' STREAMS_TYPE
, CAPTURE_NAME
, RULE_SET_OWNER
, RULE_SET_NAME
, NEGATIVE_RULE_SET_OWNER
, NEGATIVE_RULE_SET_NAME
FROM ALL_CAPTURE UNION ALL SELECT 'SYNC_CAPTURE' STREAMS_TYPE
, CAPTURE_NAME
, RULE_SET_OWNER
, RULE_SET_NAME
, NULL NEGATIVE_RULE_SET_OWNER
, NULL NEGATIVE_RULE_SET_NAME
FROM ALL_SYNC_CAPTURE UNION ALL SELECT 'APPLY'
, APPLY_NAME
, RULE_SET_OWNER
, RULE_SET_NAME
, NEGATIVE_RULE_SET_OWNER
, NEGATIVE_RULE_SET_NAME
FROM ALL_APPLY UNION ALL SELECT 'PROPAGATION'
, PROPAGATION_NAME
, RULE_SET_OWNER
, RULE_SET_NAME
, NEGATIVE_RULE_SET_OWNER
, NEGATIVE_RULE_SET_NAME
FROM ALL_PROPAGATION UNION ALL SELECT 'DEQUEUE'
, STREAMS_NAME
, RULE_SET_OWNER
, RULE_SET_NAME
, NEGATIVE_RULE_SET_OWNER
, NEGATIVE_RULE_SET_NAME
FROM ALL_STREAMS_MESSAGE_CONSUMERS