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%' ;

永德網站建設公司創(chuàng)新互聯(lián),永德網站設計制作，有大型網站制作公司豐富經驗。已為永德上1000家提供企業(yè)網站建設服務。企業(yè)網站搭建\外貿網站建設要多少錢，請找那個售后服務好的永德做網站的公司定做！