Responsibility Profile options Query

Responsibility Profile options Query

    SELECT DISTINCT
         DECODE (fpov.level_id,
                 10001, 'Site',
                 10002, 'Application',
                 10003, 'Resp',
                 10004, 'User')
            option_level,
         tr.responsibility_name,
         r.responsibility_key,
         r.end_date,
         fpotl.user_profile_option_name,
         fpov.profile_option_value,
         psp.security_profile_name
    FROM applsys.fnd_responsibility_tl tr,
         applsys.fnd_responsibility r,
         hr.per_security_profiles psp,
       --  gl_access_sets gas,
         apps.per_business_groups pbg,
         fnd_profile_options_vl fpovl,
         applsys.fnd_profile_option_values fpov,
         applsys.fnd_profile_options fpo,
         applsys.fnd_profile_options_tl fpotl
   WHERE     r.responsibility_id = tr.responsibility_id
         AND r.application_id = tr.application_id
         AND fpov.profile_option_id = fpovl.profile_option_id
         AND fpov.level_value = r.responsibility_id
         AND psp.business_group_id = pbg.business_group_id(+)
         AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)
         AND fpo.profile_option_id = fpov.profile_option_id
         AND fpotl.profile_option_name = fpo.profile_option_name
         AND fpotl.user_profile_option_name IN ('MO: Security Profile')
ORDER BY tr.responsibility_name, fpotl.user_profile_option_name