VIEW: SYS.KU$_FULL_PKG_VIEW

Source

View Text - Preformatted

select '1','1',
         oo.obj#,
         value(o),
         value(p),
         (select value(pb) from ku$_pkgbdy_view pb
          where oo.name  = pb.schema_obj.name
          and o.owner_name  = pb.schema_obj.owner_name)
  from   sys.ku$_edition_obj_view oo, ku$_edition_schemaobj_view o, ku$_pkg_view p
  where oo.type# = 9
    and oo.obj#  = o.obj_num
    and oo.obj#  = p.schema_obj.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' ))

View Text - HTML Formatted

SELECT '1'
, '1'
, OO.OBJ#
, VALUE(O)
, VALUE(P)
, (SELECT VALUE(PB)
FROM KU$_PKGBDY_VIEW PB
WHERE OO.NAME = PB.SCHEMA_OBJ.NAME
AND O.OWNER_NAME = PB.SCHEMA_OBJ.OWNER_NAME)
FROM SYS.KU$_EDITION_OBJ_VIEW OO
, KU$_EDITION_SCHEMAOBJ_VIEW O
, KU$_PKG_VIEW P
WHERE OO.TYPE# = 9
AND OO.OBJ# = O.OBJ_NUM
AND OO.OBJ# = P.SCHEMA_OBJ.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' ))