Table: ALL_REFRESH_DEPENDENCIES
Description of the detail tables that materialized views depend on for refresh
| Column Name | Description |
|---|---|
| OLDEST_REFRESH_DATE | The oldest date scn of a dependent materialized view |
| OLDEST_REFRESH_SCN | The oldest scn of a dependent materialized view |
| OWNER | Owner of the dependent table |
| PARENT_OBJECT_TYPE | Materialized View |
| TABLE_NAME | Name of the dependent table |