VIEW: SYS.DBA_MVIEW_JOINS

Source

View Text - Preformatted

select u.name, o.name,
       u1.name, o1.name, c1.name, '=',
       decode(sj.flags, 0, 'I', 1, 'L', 2, 'R'),
       u2.name, o2.name, c2.name
from sys.sumjoin$ sj, sys.obj$ o, sys.user$ u,
     sys.obj$ o1, sys.user$ u1, sys.col$ c1,
     sys.obj$ o2, sys.user$ u2, sys.col$ c2,
     sys.sum$ s
where sj.sumobj# = o.obj#
  AND o.owner# = u.user#
  AND sj.tab1obj# = o1.obj#
  AND o1.owner# = u1.user#
  AND sj.tab1obj# = c1.obj#
  AND sj.tab1col# = c1.intcol#
  AND sj.tab2obj# = o2.obj#
  AND o2.owner# = u2.user#
  AND sj.tab2obj# = c2.obj#
  AND sj.tab2col# = c2.intcol#
  AND s.obj# = sj.sumobj#
  AND bitand(s.xpflags, 8388608) = 0 /* NOT REWRITE EQUIVALENCE SUMMARY */

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, U1.NAME
, O1.NAME
, C1.NAME
, '='
, DECODE(SJ.FLAGS
, 0
, 'I'
, 1
, 'L'
, 2
, 'R')
, U2.NAME
, O2.NAME
, C2.NAME FROM SYS.SUMJOIN$ SJ
, SYS.OBJ$ O
, SYS.USER$ U
, SYS.OBJ$ O1
, SYS.USER$ U1
, SYS.COL$ C1
, SYS.OBJ$ O2
, SYS.USER$ U2
, SYS.COL$ C2
, SYS.SUM$ S WHERE SJ.SUMOBJ# = O.OBJ#
AND O.OWNER# = U.USER#
AND SJ.TAB1OBJ# = O1.OBJ#
AND O1.OWNER# = U1.USER#
AND SJ.TAB1OBJ# = C1.OBJ#
AND SJ.TAB1COL# = C1.INTCOL#
AND SJ.TAB2OBJ# = O2.OBJ#
AND O2.OWNER# = U2.USER#
AND SJ.TAB2OBJ# = C2.OBJ#
AND SJ.TAB2COL# = C2.INTCOL#
AND S.OBJ# = SJ.SUMOBJ#
AND BITAND(S.XPFLAGS
, 8388608) = 0 /* NOT REWRITE EQUIVALENCE SUMMARY */