VIEW: SYS.KU$_PROCDEPOBJ_AUDIT_VIEW

Source

View Text - Preformatted

select '1','0',
         o.obj_num,
         value(o),
         p.class, p.prepost, p.type#, p.level#, p.package, p.schema,
         value(oo),
         sys.dbms_metadata.get_procobj
          ( p.package, p.schema,'AUDIT_EXP', o.obj_num,
            (select 1 from dual
                where  (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0
                OR EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))))
  from   sys.ku$_schemaobj_view o, sys.ku$_schemaobj_view oo,
         sys.exppkgobj$ p, sys.expdepobj$ d
  where  p.class = 3 and p.type# = o.type_num and
                d.d_obj# = o.obj_num AND
                d.p_obj# = oo.obj_num
         AND (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0) OR
              EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))
  order by p.level#, p.type#

View Text - HTML Formatted

SELECT '1'
, '0'
, O.OBJ_NUM
, VALUE(O)
, P.CLASS
, P.PREPOST
, P.TYPE#
, P.LEVEL#
, P.PACKAGE
, P.SCHEMA
, VALUE(OO)
, SYS.DBMS_METADATA.GET_PROCOBJ ( P.PACKAGE
, P.SCHEMA
, 'AUDIT_EXP'
, O.OBJ_NUM
, (SELECT 1
FROM DUAL
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))))
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.KU$_SCHEMAOBJ_VIEW OO
, SYS.EXPPKGOBJ$ P
, SYS.EXPDEPOBJ$ D
WHERE P.CLASS = 3
AND P.TYPE# = O.TYPE_NUM AND D.D_OBJ# = O.OBJ_NUM AND D.P_OBJ# = OO.OBJ_NUM
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' )) ORDER BY P.LEVEL#
, P.TYPE#