Wednesday 20 May 2015

SQL Query to retrive profile option value from backend

SELECT
fpot.user_profile_option_name Profile,
decode(fpov.level_id,
10001,'Site',
10002,'Application',
10003,'Responsibility',
10004,'User') Profile_option_level,
decode(fpov.level_id,
10001,'Site',
10002,fa.application_short_name,
10003,frt.Responsibility_name,
10004,fu.user_name) profile_Level_Value,
nvl(fpov.profile_option_value,'Is Null') Profile_option_Value
FROM 
fnd_profile_option_values fpov,
fnd_profile_options_tl fpot ,
fnd_profile_options fpo,
fnd_responsibility_tl frt,
fnd_application fa,
fnd_user fu
WHERE
fpo.profile_option_name = fpot.profile_option_name
and  fpo.profile_option_id = fpov.profile_option_id
and  fpov.level_value = frt.responsibility_id (+)
and  fpov.level_value = fa.application_id (+)
and  fpov.level_value = fu.user_id (+)
and  fpot.user_profile_option_name like ('%FND%Debug%')
order by 1,2;

No comments:

Post a Comment

How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>

 How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>  Sometime these xml data tags automatically chang...