VIEW: SYS.ALL_STREAMS_KEEP_COLUMNS

Source

View Text - Preformatted

select skc."RULE_OWNER",skc."RULE_NAME",skc."SCHEMA_NAME",skc."TABLE_NAME",skc."COLUMN_NAME",skc."VALUE_TYPE",skc."PRECEDENCE",skc."STEP_NUMBER"
  from DBA_STREAMS_KEEP_COLUMNS skc, ALL_APPLY aa, ALL_CAPTURE ca
  where (aa.apply_user = skc.rule_owner) or (ca.capture_user = skc.rule_owner)

View Text - HTML Formatted

SELECT SKC."RULE_OWNER"
, SKC."RULE_NAME"
, SKC."SCHEMA_NAME"
, SKC."TABLE_NAME"
, SKC."COLUMN_NAME"
, SKC."VALUE_TYPE"
, SKC."PRECEDENCE"
, SKC."STEP_NUMBER"
FROM DBA_STREAMS_KEEP_COLUMNS SKC
, ALL_APPLY AA
, ALL_CAPTURE CA
WHERE (AA.APPLY_USER = SKC.RULE_OWNER) OR (CA.CAPTURE_USER = SKC.RULE_OWNER)