EBS 查询用户具备的职责和用户相关信息

查看所有用户的ID、用户名、职责名和姓

SELECT fu.user_id
      ,fu.user_name
      ,frv.responsibility_name
      ,ppf.last_name
  FROM fnd_user                         fu
      ,apps.fnd_user_resp_groups_direct furg
      ,fnd_responsibility_vl            frv
      ,per_people_f                     ppf
 WHERE fu.user_id = furg.user_id
   AND furg.responsibility_id = frv.responsibility_id
   AND fu.user_name = 'xxxx'
   AND fu.employee_id = ppf.person_id;

根据用户名查找

SELECT DISTINCT users.user_id
               ,users.user_name
               ,users.description
               ,users.start_date            user_start_date
               ,users.end_date              user_end_date
               ,users.email_address
               ,resp.responsibility_name
               ,user_resp.start_date
               ,user_resp.end_date
               ,user_resp.last_update_date
               ,appl.application_short_name
               ,appl.application_name
  FROM apps.fnd_user                    users
      ,apps.fnd_user_resp_groups_direct user_resp
      ,apps.fnd_responsibility_vl       resp
      ,apps.fnd_application_vl          appl
 WHERE users.user_id = user_resp.user_id
   AND user_resp.responsibility_application_id = resp.application_id
   AND user_resp.responsibility_id = resp.responsibility_id
   AND resp.application_id = appl.application_id
   AND users.user_name = 'xxx';