Profile Option Values Query in Oracle Apps

SELECT distinct
fpot.profile_option_name profile_short_name
,substr(fpot.user_profile_option_name,1,60) profile_name
,DECODE(fpov.level_id,10001,'site',10002,'Appl',10003,'Resp',10004,'User') profile_level
,fr.responsibility_name,DECODE(fpov.level_id,10001,
null,
10002,
fa.application_short_name
,10003,
fr.responsibility_name,
10004,
fu.user_name
) level_value,
fpov.profile_option_value profile_value
FROM fnd_profile_option_values fpov
, fnd_profile_options fpo
, fnd_profile_options_tl fpot
, fnd_application fa
, fnd_responsibility_tl fr
, fnd_user fu
WHERE (fpo.profile_option_name like nvl(fpo.profile_option_name,fpo.profile_option_name)
or fpot.user_profile_option_name like nvl(fpot.user_profile_option_name,fpot.user_profile_option_name))
and fpo.profile_option_name=fpot.profile_option_name
and fpo.profile_option_id = fpov.profile_option_id
and fa.application_id(+)=fpov.level_value
and fr.responsibility_id(+)=fpov.level_value
and fu.user_id(+)=fpov.level_value
and fu.end_date is null