我们专注攀枝花网站设计 攀枝花网站制作 攀枝花网站建设
成都网站建设公司服务热线:400-028-6601

网站建设知识

十年网站开发经验 + 多家企业客户 + 靠谱的建站团队

量身定制 + 运营维护+专业推广+无忧售后,网站问题一站解决

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://mswzjz.cn/article/ijijds.html

其他资讯