VIEW: SYS.KU$_PROXY_ROLE_LIST_VIEW

Source

View Text - Preformatted

select  prd.role#, uc.name, up.name, ur.name
  from    sys.user$ ur, sys.user$ uc,
          sys.user$ up ,sys.proxy_role_info$ prd
  where   prd.role#   = ur.user# AND
                prd.client# = uc.user# AND
                prd.proxy#  = up.user#

View Text - HTML Formatted

SELECT PRD.ROLE#
, UC.NAME
, UP.NAME
, UR.NAME
FROM SYS.USER$ UR
, SYS.USER$ UC
, SYS.USER$ UP
, SYS.PROXY_ROLE_INFO$ PRD
WHERE PRD.ROLE# = UR.USER# AND PRD.CLIENT# = UC.USER# AND PRD.PROXY# = UP.USER#