Просмотр полномочий пользователя

SELECT distinct
       u.user_id,
       u.user_name,
       r.responsibility_name as responsiblity,
       a.application_name    as application
FROM fnd_user u,
       fnd_user_resp_groups g,
       fnd_application_tl a,
       fnd_responsibility_tl r
WHERE g.user_id(+) = u.user_id
      AND g.responsibility_application_id = a.application_id
      AND a.application_id = r.application_id
      AND g.responsibility_id = r.responsibility_id
      AND a.LANGUAGE = 'RU'
      AND r.LANGUAGE = 'RU'
      AND u.user_name = '!!!USER_NAME'
ORDER BY user_name, responsiblity, application