Query to find Profile Options and its values

SELECT DISTINCT

pro1.profile_option_name,

pov.profile_option_id,

    substr(pro1.user_profile_option_name,1,35) profile,

    DECODE(pov.level_id,10001,'Site',10002,'Application',10003,'Resp',10004,'User') option_level,    DECODE(pov.level_id,10001,'Site',10002,appl.application_short_name,10003,resp.responsibility_name,10004,u.user_name) level_value,

    nvl(pov.profile_option_value,'Is Null') profile_option_value

FROM

    fnd_profile_option_values pov,

    fnd_responsibility_tl resp,

    fnd_application appl,

    fnd_user u,

    fnd_profile_options pro,

    fnd_profile_options_tl pro1

WHERE

    pro.profile_option_name = pro1.profile_option_name

    AND   pro.profile_option_id = pov.profile_option_id

    AND   pov.level_value = resp.responsibility_id (+)

    AND   pov.level_value = appl.application_id (+)

    AND   pov.level_value = u.user_id (+)

    AND pro1.profile_option_name IN ('profile_option_name')

ORDER BY

    1,

    2;