Verifying Profile Option Values

SELECT DECODE (fpov.level_id,
               10001, ‘Site’,
               10002, ‘Appl’,
               10003, ‘Resp’,
               10004, ‘User’,
               ‘Unkown’
              ) “Level”,
       DECODE (fpov.level_id,
               10002, fa.application_name,
               10003, fr.responsibility_name,
               10004, fu.user_name,
               ‘-‘
              ) “Location”,
       fpov.profile_option_value “Value”
  FROM apps.fnd_profile_option_values fpov,
       apps.fnd_profile_options fpo,
       apps.fnd_profile_options_tl fpot,
       apps.fnd_responsibility_tl fr,
       apps.fnd_user fu,
       apps.fnd_application_tl fa
 WHERE fpov.profile_option_id = fpo.profile_option_id
   AND fpo.profile_option_name = fpot.profile_option_name
   AND fpov.level_value = fr.responsibility_id(+)
   AND fpov.level_value = fu.user_id(+)
   AND fpov.level_value = fa.application_id(+)
   AND fpot.user_profile_option_name = ‘<Profile Option Name>‘;