VIEW: SYS.KU$_SCHEMA_CALLOUT_VIEW

Source

View Text - Preformatted

select '1','0',
  u.name, null, null,
  p.package, p.schema,
  p.level#, p.class, pr.prepost,
  null, null, null, null, null, null, null
  FROM   sys.user$ u, sys.exppkgact$ p, ku$_prepost_view pr
  where p.class=6 and u.type# = 1
         AND (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (u.user#, 0)  OR
              EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))
  order by p.level#

View Text - HTML Formatted

SELECT '1'
, '0'
, U.NAME
, NULL
, NULL
, P.PACKAGE
, P.SCHEMA
, P.LEVEL#
, P.CLASS
, PR.PREPOST
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM SYS.USER$ U
, SYS.EXPPKGACT$ P
, KU$_PREPOST_VIEW PR
WHERE P.CLASS=6
AND U.TYPE# = 1
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (U.USER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' )) ORDER BY P.LEVEL#