eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: SYS.ORA_KGLR7_DEPENDENCIES

Source

View Text - Preformatted


select u.name, o.name, o.type#,
    decode(o2.linkname, null, u2.name, o2.remoteowner), o2.name, o2.type#,
         o2.linkname, d.p_timestamp, d.order#, o.obj#, d.property
from sys.obj$ o, sys.dependency$ d,
     sys.user$ u, sys.obj$ o2, sys.user$ u2
where o.obj# = d.d_obj#
  and o.owner# = u.user#
  and o.status = 1 /* VALID/AUTHORIZED WITHOUT ERRORS */
  and (o2.obj# = d.p_obj# and o2.owner# = u2.user# and
       (o2.namespace = 1 /* TABLE/PROCEDURE */
       or
       o2.namespace = 2 /* BODY */))
  and (o.owner# in (userenv('SCHEMAID'), 1 /* PUBLIC */)
       or (o.namespace in (1 /* TABLE/PROCEDURE */,
                           2 /* PACKAGE BODY */)
           and (o.type# in (2 /* TABLE */, 4 /* VIEW */, 9 /* PACKAGE */,
                           13 /* TYPE */)
                or
                o.obj# in (select obj# from sys.objauth$
                           where grantee# in (select kzsrorol
                                              from x$kzsro)
                             and privilege# = 12 /* EXECUTE */)
                or
                exists (select null from sys.sysauth$
                        where grantee# in (select kzsrorol
                                           from x$kzsro)
                             and (o.type# in (7 /* PROCEDURE */,
                                             8 /* FUNCTION */,
                                             11 /* PACKAGE BODY */) and
                                  privilege# = -144 /* EXECUTE ANY PROCEDURE */
                                  )))))
union
select u.name, o.name, o.type#, 'SYS', po.name,
      decode(po.type, 'TABLE', 2, 'VIEW', 4, 2),
         null, d.p_timestamp, d.order#, o.obj#, d.property
from sys.obj$ o, sys.v$fixed_table po, sys.dependency$ d,
     sys.user$ u
where o.obj# = d.d_obj#
  and o.owner# = u.user#
  and o.status = 1 /* VALID/AUTHORIZED WITHOUT ERRORS */
  and po.object_id = d.p_obj#
  and (o.owner# in (userenv('SCHEMAID'), 1 /* PUBLIC */)
       or (o.namespace in (1 /* TABLE/PROCEDURE */,
                           2 /* PACKAGE BODY */)
           and (o.type# in (2 /* TABLE */, 4 /* VIEW */, 9 /* PACKAGE */,
                           13 /* TYPE */)
                or
                o.obj# in (select obj# from sys.objauth$
                           where grantee# in (select kzsrorol
                                              from x$kzsro)
                             and privilege# = 12 /* EXECUTE */)
                or
                exists (select null from sys.sysauth$
                        where grantee# in (select kzsrorol
                                           from x$kzsro)
                             and (o.type# in (7 /* PROCEDURE */,
                                             8 /* FUNCTION */,
                                             11 /* PACKAGE BODY */) and
                                  privilege# = -144 /* EXECUTE ANY PROCEDURE */
                                  )))))
union
select u.name, o.name, o.type#, 'SYS', po.name_kqfp,
         po.type_kqfp, /* Note: currently spec=1 and body=2 */
         null, d.p_timestamp, d.order#, o.obj#, d.property
from sys.obj$ o, sys.x$kqfp po, sys.dependency$ d,
     sys.user$ u
where o.obj# = d.d_obj#
  and o.owner# = u.user#
  and o.status = 1 /* VALID/AUTHORIZED WITHOUT ERRORS */
  and po.kobjn_kqfp = d.p_obj#
  and (o.owner# in (userenv('SCHEMAID'), 1 /* PUBLIC */)
       or (o.namespace in (1 /* TABLE/PROCEDURE */,
                           2 /* PACKAGE BODY */)
           and (o.type# in (2 /* TABLE */, 4 /* VIEW */, 9 /* PACKAGE */,
                           13 /* TYPE */)
                or
                o.obj# in (select obj# from sys.objauth$
                           where grantee# in (select kzsrorol
                                              from x$kzsro)
                             and privilege# = 12 /* EXECUTE */)
                or
                exists (select null from sys.sysauth$
                        where grantee# in (select kzsrorol
                                           from x$kzsro)
                             and (o.type# in (7 /* PROCEDURE */,
                                             8 /* FUNCTION */,
                                             11 /* PACKAGE BODY */) and
                                  privilege# = -144 /* EXECUTE ANY PROCEDURE */
                                  )))))

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, O.TYPE#
, DECODE(O2.LINKNAME
, NULL
, U2.NAME
, O2.REMOTEOWNER)
, O2.NAME
, O2.TYPE#
, O2.LINKNAME
, D.P_TIMESTAMP
, D.ORDER#
, O.OBJ#
, D.PROPERTY FROM SYS.OBJ$ O
, SYS.DEPENDENCY$ D
, SYS.USER$ U
, SYS.OBJ$ O2
, SYS.USER$ U2 WHERE O.OBJ# = D.D_OBJ#
AND O.OWNER# = U.USER#
AND O.STATUS = 1 /* VALID/AUTHORIZED WITHOUT ERRORS */
AND (O2.OBJ# = D.P_OBJ#
AND O2.OWNER# = U2.USER# AND (O2.NAMESPACE = 1 /* TABLE/PROCEDURE */ OR O2.NAMESPACE = 2 /* BODY */))
AND (O.OWNER# IN (USERENV('SCHEMAID')
, 1 /* PUBLIC */) OR (O.NAMESPACE IN (1 /* TABLE/PROCEDURE */
, 2 /* PACKAGE BODY */)
AND (O.TYPE# IN (2 /* TABLE */
, 4 /* VIEW */
, 9 /* PACKAGE */
, 13 /* TYPE */) OR O.OBJ# IN (SELECT OBJ#
FROM SYS.OBJAUTH$
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND PRIVILEGE# = 12 /* EXECUTE */) OR EXISTS (SELECT NULL
FROM SYS.SYSAUTH$
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND (O.TYPE# IN (7 /* PROCEDURE */
, 8 /* FUNCTION */
, 11 /* PACKAGE BODY */) AND PRIVILEGE# = -144 /* EXECUTE ANY PROCEDURE */ ))))) UNION SELECT U.NAME
, O.NAME
, O.TYPE#
, 'SYS'
, PO.NAME
, DECODE(PO.TYPE
, 'TABLE'
, 2
, 'VIEW'
, 4
, 2)
, NULL
, D.P_TIMESTAMP
, D.ORDER#
, O.OBJ#
, D.PROPERTY FROM SYS.OBJ$ O
, SYS.V$FIXED_TABLE PO
, SYS.DEPENDENCY$ D
, SYS.USER$ U WHERE O.OBJ# = D.D_OBJ#
AND O.OWNER# = U.USER#
AND O.STATUS = 1 /* VALID/AUTHORIZED WITHOUT ERRORS */
AND PO.OBJECT_ID = D.P_OBJ#
AND (O.OWNER# IN (USERENV('SCHEMAID')
, 1 /* PUBLIC */) OR (O.NAMESPACE IN (1 /* TABLE/PROCEDURE */
, 2 /* PACKAGE BODY */)
AND (O.TYPE# IN (2 /* TABLE */
, 4 /* VIEW */
, 9 /* PACKAGE */
, 13 /* TYPE */) OR O.OBJ# IN (SELECT OBJ#
FROM SYS.OBJAUTH$
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND PRIVILEGE# = 12 /* EXECUTE */) OR EXISTS (SELECT NULL
FROM SYS.SYSAUTH$
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND (O.TYPE# IN (7 /* PROCEDURE */
, 8 /* FUNCTION */
, 11 /* PACKAGE BODY */) AND PRIVILEGE# = -144 /* EXECUTE ANY PROCEDURE */ ))))) UNION SELECT U.NAME
, O.NAME
, O.TYPE#
, 'SYS'
, PO.NAME_KQFP
, PO.TYPE_KQFP
, /* NOTE: CURRENTLY SPEC=1
AND BODY=2 */ NULL
, D.P_TIMESTAMP
, D.ORDER#
, O.OBJ#
, D.PROPERTY FROM SYS.OBJ$ O
, SYS.X$KQFP PO
, SYS.DEPENDENCY$ D
, SYS.USER$ U WHERE O.OBJ# = D.D_OBJ#
AND O.OWNER# = U.USER#
AND O.STATUS = 1 /* VALID/AUTHORIZED WITHOUT ERRORS */
AND PO.KOBJN_KQFP = D.P_OBJ#
AND (O.OWNER# IN (USERENV('SCHEMAID')
, 1 /* PUBLIC */) OR (O.NAMESPACE IN (1 /* TABLE/PROCEDURE */
, 2 /* PACKAGE BODY */)
AND (O.TYPE# IN (2 /* TABLE */
, 4 /* VIEW */
, 9 /* PACKAGE */
, 13 /* TYPE */) OR O.OBJ# IN (SELECT OBJ#
FROM SYS.OBJAUTH$
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND PRIVILEGE# = 12 /* EXECUTE */) OR EXISTS (SELECT NULL
FROM SYS.SYSAUTH$
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND (O.TYPE# IN (7 /* PROCEDURE */
, 8 /* FUNCTION */
, 11 /* PACKAGE BODY */) AND PRIVILEGE# = -144 /* EXECUTE ANY PROCEDURE */ )))))