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 '%系统管理员%' ;