VIEW: SYS.ALL_MVIEW_REFRESH_TIMES

Source

View Text - Preformatted

select s."OWNER",s."NAME",s."MASTER_OWNER",s."MASTER",s."LAST_REFRESH" from dba_mview_refresh_times s, all_mviews a
where s.owner = a.owner
and   s.name  = a.mview_name

View Text - HTML Formatted

SELECT S."OWNER"
, S."NAME"
, S."MASTER_OWNER"
, S."MASTER"
, S."LAST_REFRESH"
FROM DBA_MVIEW_REFRESH_TIMES S
, ALL_MVIEWS A WHERE S.OWNER = A.OWNER AND S.NAME = A.MVIEW_NAME