VIEW: SYS.ALL_BASE_TABLE_MVIEWS

Source

View Text - Preformatted

select s."OWNER",s."MASTER",s."MVIEW_LAST_REFRESH_TIME",s."MVIEW_ID" from dba_base_table_mviews s, all_mview_logs a
where a.log_owner = s.owner
  and a.master = s.master

View Text - HTML Formatted

SELECT S."OWNER"
, S."MASTER"
, S."MVIEW_LAST_REFRESH_TIME"
, S."MVIEW_ID"
FROM DBA_BASE_TABLE_MVIEWS S
, ALL_MVIEW_LOGS A WHERE A.LOG_OWNER = S.OWNER
AND A.MASTER = S.MASTER