VIEW: SYS.KU$_DEPVIEWS_BASE_VIEW

Source

View Text - Preformatted

select unique o.obj#,o.name,o.owner#,u.name, d.d_obj#, do.name
from obj$ o, obj$ do, user$ u, dependency$ d, view$ v
where o.obj# = v.obj#
  and bitand(o.flags,16)!=16          /* not secondary object */
  and o.owner# != 0                   /* not owned by SYS */
  and o.owner# = u.user#
  and o.obj# = d.p_obj#
  and do.obj# = d.d_obj#
  and bitand(d.property,1)=1          /* only hard dependency */
  and do.type# = 4
union
 select o.obj#,o.name,o.owner#,u.name,0,NULL
from obj$ o, user$ u, view$ v
where o.obj# = v.obj#
  and bitand(o.flags,16)!=16          /* not secondary object */
  and o.owner# != 0                   /* not owned by SYS */
  and o.owner# = u.user#
  and not exists (select * from obj$ do, dependency$ d
                  where o.obj# = d.p_obj#
                  and do.obj# = d.d_obj#
                  and do.type# = 4
                  and bitand(d.property,1)=1 )

View Text - HTML Formatted

SELECT UNIQUE O.OBJ#
, O.NAME
, O.OWNER#
, U.NAME
, D.D_OBJ#
, DO.NAME FROM OBJ$ O
, OBJ$ DO
, USER$ U
, DEPENDENCY$ D
, VIEW$ V WHERE O.OBJ# = V.OBJ#
AND BITAND(O.FLAGS
, 16)!=16 /* NOT SECONDARY OBJECT */
AND O.OWNER# != 0 /* NOT OWNED BY SYS */
AND O.OWNER# = U.USER#
AND O.OBJ# = D.P_OBJ#
AND DO.OBJ# = D.D_OBJ#
AND BITAND(D.PROPERTY
, 1)=1 /* ONLY HARD DEPENDENCY */
AND DO.TYPE# = 4 UNION SELECT O.OBJ#
, O.NAME
, O.OWNER#
, U.NAME
, 0
, NULL FROM OBJ$ O
, USER$ U
, VIEW$ V WHERE O.OBJ# = V.OBJ#
AND BITAND(O.FLAGS
, 16)!=16 /* NOT SECONDARY OBJECT */
AND O.OWNER# != 0 /* NOT OWNED BY SYS */
AND O.OWNER# = U.USER#
AND NOT EXISTS (SELECT *
FROM OBJ$ DO
, DEPENDENCY$ D
WHERE O.OBJ# = D.P_OBJ#
AND DO.OBJ# = D.D_OBJ#
AND DO.TYPE# = 4
AND BITAND(D.PROPERTY
, 1)=1 )