Query to find the User preferences set for a User in Oracle Apps/EBS

Query to find the User preferences set for a User in Oracle Apps/EBS

We can use below query to check preferences set for a user.  In this example I am checking the preferences set for user related to workflow/mails.

select * from fnd_user_preferences where PREFERENCE_NAME='MAILTYPE' and MODULE_NAME = 'WF' and user_name in  ('HIMANSHU.SINGH');

select preference_value

from fnd_user_preferences

where user_name='HIMANSHU.SINGH'

and preference_name='MAILTYPE';

select distinct PREFERENCE_VALUE from fnd_user_preferences where PREFERENCE_VALUE  like '%MAI%'

select PREFERENCE_VALUE

from FND_USER_PREFERENCES

where USER_NAME='-WF_DEFAULT-'

and MODULE_NAME='WF'

and PREFERENCE_NAME='MAILTYPE' ;

select * from wf_local_roles

where notification_preference in ('DISABLED','QUERY')

and orig_system='PER' and name in ('HIMANSHU.SINGH');