VIEW: SYS.ALL_SYNC_CAPTURE_PREPARED_TABS

Source

View Text - Preformatted

select pt.table_owner, pt.table_name, pt.scn, pt.timestamp
  from all_tables at, dba_sync_capture_prepared_tabs pt
  where pt.table_name = at.table_name
    and pt.table_owner = at.owner

View Text - HTML Formatted

SELECT PT.TABLE_OWNER
, PT.TABLE_NAME
, PT.SCN
, PT.TIMESTAMP
FROM ALL_TABLES AT
, DBA_SYNC_CAPTURE_PREPARED_TABS PT
WHERE PT.TABLE_NAME = AT.TABLE_NAME
AND PT.TABLE_OWNER = AT.OWNER