VIEW: SYS.KU$_XSUSER_VIEW

Source

View Text - Preformatted

select '1','0',
          o.name,
          o.ws,
          o.owner,
          o.tenant,
          o.id,
          o.type,
          o.status,
          (select value(p)
              from ku$_xsprin_view p
              where p.prin_id=o.id)
  from xs$obj o, xs$prin p
  where o.id = p.prin#
  and   bitand(o.flags,1)=0                           /* not Oracle supplied */
  and   o.type=1
  and   p.type=0

View Text - HTML Formatted

SELECT '1'
, '0'
, O.NAME
, O.WS
, O.OWNER
, O.TENANT
, O.ID
, O.TYPE
, O.STATUS
, (SELECT VALUE(P)
FROM KU$_XSPRIN_VIEW P
WHERE P.PRIN_ID=O.ID)
FROM XS$OBJ O
, XS$PRIN P
WHERE O.ID = P.PRIN#
AND BITAND(O.FLAGS
, 1)=0 /* NOT ORACLE SUPPLIED */
AND O.TYPE=1
AND P.TYPE=0