Table: ALL_MVIEW_JOINS
Description of a join between two columns in the WHERE clause of a materialized view accessible to the user
| Column Name | Description |
|---|---|
| DETAILOBJ1_COLUMN | Name of the 1st detail object column |
| DETAILOBJ1_OWNER | Owner of the 1st detail object |
| DETAILOBJ1_RELATION | Name of the 1st detail object |
| DETAILOBJ2_COLUMN | Name of the 2nd detail object column |
| DETAILOBJ2_OWNER | Owner of the 2nd detail object |
| DETAILOBJ2_RELATION | Name of the 2nd detail object |
| MVIEW_NAME | Name of the materialized view |
| OPERATOR | Name of the join operator. Currently only = is defined |
| OPERATOR_TYPE | |
| OWNER | Owner of the materialized view |