Profile Option Values for Responsibility
SELECT resp.responsibility_name,
SUBSTR (pro1.user_profile_option_name, 1, 60) 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 1 = 1
--AND pro1.user_profile_option_name LIKE ('%MO: Operating Unit%')
AND pro.profile_option_name = pro1.profile_option_name
AND pro.profile_option_id = pov.profile_option_id
AND UPPER (resp.responsibility_name) LIKE
UPPER ('%INV') /* comment this line if you need to check profiles for all responsibilities */
AND pov.level_value = resp.responsibility_id(+)
AND pov.level_value = appl.application_id(+)
AND pov.level_value = u.user_id(+) and resp.language='US' and pro1.language='US'
ORDER BY 1, 2
SELECT resp.responsibility_name,
SUBSTR (pro1.user_profile_option_name, 1, 60) 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 1 = 1
--AND pro1.user_profile_option_name LIKE ('%MO: Operating Unit%')
AND pro.profile_option_name = pro1.profile_option_name
AND pro.profile_option_id = pov.profile_option_id
AND UPPER (resp.responsibility_name) LIKE
UPPER ('%INV') /* comment this line if you need to check profiles for all responsibilities */
AND pov.level_value = resp.responsibility_id(+)
AND pov.level_value = appl.application_id(+)
AND pov.level_value = u.user_id(+) and resp.language='US' and pro1.language='US'
ORDER BY 1, 2
No comments:
Post a Comment