ALL_REFRESH_DEPENDENCIES

Description of the detail tables that materialized views depend on for refresh

Columns
   ___________________________
 
   TABLE_NAME
      Name of the dependent table
   PARENT_OBJECT_TYPE
      Materialized View
   OLDEST_REFRESH_SCN
      The oldest scn of a dependent materialized view
   OLDEST_REFRESH_DATE
      The oldest date scn of a dependent materialized view