VIEW: SYS.USER_REGISTERED_MVIEWS

Source

View Text - Preformatted

select "OWNER","NAME","MVIEW_SITE","CAN_USE_LOG","UPDATABLE","REFRESH_METHOD","MVIEW_ID","VERSION","QUERY_TXT" from dba_registered_mviews s
where exists (select u.mview_id from user_base_table_mviews u
                  where s.mview_id = u.mview_id)

View Text - HTML Formatted

SELECT "OWNER"
, "NAME"
, "MVIEW_SITE"
, "CAN_USE_LOG"
, "UPDATABLE"
, "REFRESH_METHOD"
, "MVIEW_ID"
, "VERSION"
, "QUERY_TXT"
FROM DBA_REGISTERED_MVIEWS S WHERE EXISTS (SELECT U.MVIEW_ID
FROM USER_BASE_TABLE_MVIEWS U
WHERE S.MVIEW_ID = U.MVIEW_ID)