VIEW: SYS.ALL_COMPARISON_SCAN_SUMMARY

Source

View Text - Preformatted

SELECT css."OWNER",css."COMPARISON_NAME",css."SCAN_ID",css."PARENT_SCAN_ID",css."ROOT_SCAN_ID",css."STATUS",css."CURRENT_DIF_COUNT",css."INITIAL_DIF_COUNT",css."COUNT_ROWS",css."SCAN_NULLS",css."LAST_UPDATE_TIME"
FROM dba_comparison_scan_summary css, ALL_APPLY aa, ALL_CAPTURE ca
  where (aa.apply_user = css.owner) or (ca.capture_user = css.owner)

View Text - HTML Formatted

SELECT CSS."OWNER"
, CSS."COMPARISON_NAME"
, CSS."SCAN_ID"
, CSS."PARENT_SCAN_ID"
, CSS."ROOT_SCAN_ID"
, CSS."STATUS"
, CSS."CURRENT_DIF_COUNT"
, CSS."INITIAL_DIF_COUNT"
, CSS."COUNT_ROWS"
, CSS."SCAN_NULLS"
, CSS."LAST_UPDATE_TIME" FROM DBA_COMPARISON_SCAN_SUMMARY CSS
, ALL_APPLY AA
, ALL_CAPTURE CA
WHERE (AA.APPLY_USER = CSS.OWNER) OR (CA.CAPTURE_USER = CSS.OWNER)