oracleebs通过职责查找用户

  SELECT DISTINCT papf.person_id,
                      papf.employee_number,
                      papf.full_name,
                      su.user_id,
                      res.responsibility_id,
                      res.application_id,
                      su.user_name,
                      res.responsibility_name                     
        FROM hr.per_all_people_f      papf,
             applsys.fnd_user         su,
             fnd_responsibility_vl    res,
             fnd_user_resp_groups_all furg,
             fnd_application_vl       app
       WHERE
          su.employee_id = Papf.person_Id(+)
          AND su.user_id = furg.user_id
         AND res.responsibility_id = furg.responsibility_id
         AND res.application_id = furg.responsibility_application_id
         AND furg.responsibility_application_id = app.application_Id
         And res.responsibility_name  Like '%responsibility_name%' ;

永德网站建设公司创新互联,永德网站设计制作，有大型网站制作公司丰富经验。已为永德上1000家提供企业网站建设服务。企业网站搭建\外贸网站建设要多少钱，请找那个售后服务好的永德做网站的公司定做！