ALL_REFRESH_DEPENDENCIES

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

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

Related Commands:

Simon Sheppard
SS64.com