DBA_MVIEW_JOINS describes a join between two columns in the WHERE clause of a subquery that defines a materialized view. Its columns are the same as those in "ALL_MVIEW_JOINS".
DBA_MVIEW_JOINS
WHERE
Scripting on this page enhances content navigation, but does not change the content in any way.