ALL_REFRESH_DEPENDENCIES

ALL_REFRESH_DEPENDENCIES displays the names of the dependent detail or container tables of all the materialized views in the current schema.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the table
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Table name, unique within this schema
`PARENT_OBJECT_TYPE`	`CHAR(17)`		`MATERIALIZED VIEW`
`OLDEST_REFRESH_SCN`	`NUMBER`		Minimum SCN of any summary or materialized view that has `TABLE_NAME` as a detail table
`OLDEST_REFRESH_DATE`	`DATE`		`SYSDATE` when last refreshed