VIEW: SYS.KU$_PROCOBJ_AUDIT_VIEW

Source

View Text - Preformatted

select '1','0',
         o.obj#,
         (select value(o1) from sys.ku$_schemaobj_view o1
          where o1.obj_num=o.obj#),
         (select p.class from sys.exppkgobj$ p where p.type#=o.type#
               and (p.class=1 or p.class=2)),
         (select p.prepost from sys.exppkgobj$ p where p.type#=o.type#
               and (p.class=1 or p.class=2)),
         o.type#,
         (select p.level# from sys.exppkgobj$ p where p.type#=o.type#
               and (p.class=1 or p.class=2)),
         (select p.package from sys.exppkgobj$ p where p.type#=o.type#
               and (p.class=1 or p.class=2)),
         (select p.schema from sys.exppkgobj$ p where p.type#=o.type#
               and (p.class=1 or p.class=2)),
         (select sys.dbms_metadata.get_procobj
                (p.package, p.schema,'AUDIT_EXP', o.obj#,
                  (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.exppkgobj$ p where p.type#=o.type#
                   and (p.class=1 or p.class=2))
  from   obj$ o
  where  (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner#, 0) OR
              EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, O.OBJ#
, (SELECT VALUE(O1)
FROM SYS.KU$_SCHEMAOBJ_VIEW O1
WHERE O1.OBJ_NUM=O.OBJ#)
, (SELECT P.CLASS
FROM SYS.EXPPKGOBJ$ P
WHERE P.TYPE#=O.TYPE#
AND (P.CLASS=1 OR P.CLASS=2))
, (SELECT P.PREPOST
FROM SYS.EXPPKGOBJ$ P
WHERE P.TYPE#=O.TYPE#
AND (P.CLASS=1 OR P.CLASS=2))
, O.TYPE#
, (SELECT P.LEVEL#
FROM SYS.EXPPKGOBJ$ P
WHERE P.TYPE#=O.TYPE#
AND (P.CLASS=1 OR P.CLASS=2))
, (SELECT P.PACKAGE
FROM SYS.EXPPKGOBJ$ P
WHERE P.TYPE#=O.TYPE#
AND (P.CLASS=1 OR P.CLASS=2))
, (SELECT P.SCHEMA
FROM SYS.EXPPKGOBJ$ P
WHERE P.TYPE#=O.TYPE#
AND (P.CLASS=1 OR P.CLASS=2))
, (SELECT SYS.DBMS_METADATA.GET_PROCOBJ (P.PACKAGE
, P.SCHEMA
, 'AUDIT_EXP'
, O.OBJ#
, (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.EXPPKGOBJ$ P
WHERE P.TYPE#=O.TYPE#
AND (P.CLASS=1 OR P.CLASS=2))
FROM OBJ$ O
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))