重庆分公司,新征程启航

为企业提供网站建设、域名注册、服务器等服务

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家提供企业网站建设服务。企业网站搭建\外贸网站建设要多少钱,请找那个售后服务好的永德做网站的公司定做!


网页标题:oracleebs通过职责查找用户
网页路径:http://cqcxhl.cn/article/ijijds.html

其他资讯

在线咨询
服务热线
服务热线:028-86922220
TOP