Profile

[@more@]SELECT p.user_profile_option_name profile,
'1 - Site' scope,
'Site' value_scope,
v.level_value,
v.profile_option_value v_profile
FROM fnd_profile_option_values v,
fnd_profile_options_vl p
WHERE v.profile_option_id = p.profile_option_id
AND (v.level_id = 10001)
--and p.user_profile_option_name like '%&&profile%'
UNION ALL
SELECT p.user_profile_option_name,
'2 - Application.',
a.application_short_name,
v.level_value,
v.profile_option_value
FROM fnd_profile_option_values v,
fnd_profile_options_vl p,
fnd_application a
WHERE v.profile_option_id = p.profile_option_id
AND (v.level_id = 10002 AND a.application_id = v.level_value)
--and p.user_profile_option_name like '%&&profile%'
UNION ALL
SELECT p.user_profile_option_name,
'3 - Respon.',
r.responsibility_name,
v.level_value,
v.profile_option_value
FROM fnd_profile_option_values v,
fnd_profile_options_vl p,
fnd_responsibility_vl r
WHERE v.profile_option_id = p.profile_option_id
AND (v.level_id = 10003 AND r.responsibility_id = v.level_value)
--and p.user_profile_option_name like '%&&profile%'
UNION ALL
SELECT p.user_profile_option_name,
'3 - User',
u.user_name,
v.level_value,
v.profile_option_value
FROM fnd_profile_option_values v,
fnd_profile_options_vl p,
fnd_user u
WHERE v.profile_option_id = p.profile_option_id
AND (v.level_id = 10004 AND u.user_id = v.level_value)