取用户对应职责sql

SELECT fu.user_name
      ,fe.last_name
      ,fr.responsibility_name
      ,fr.description
      ,fr.start_date
      ,fr.end_date
FROM   fnd_user                    fu
      ,hr_employees                fe
      ,fnd_user_resp_groups_direct ugd
      ,fnd_responsibility_vl       fr
WHERE  to_char(fu.creation_date
              ,'YYYY') >= '2018'
AND    fu.employee_id = fe.employee_id(+)
AND    fu.user_id = ugd.user_id
AND    ugd.responsibility_id = fr.responsibility_id
AND    ugd.responsibility_application_id = fr.application_id
AND    user_name = 'EBS-TEST' --- 登录用户名,可变量
ORDER  BY responsibility_name