Check Workflow Notification Preference for FND User

Query To Check Workflow Notification Preference for FND User

select * from fnd_user_preferences
where user_name = 'SYSADMIN'  --Enter FND User Name here
AND PREFERENCE_NAME = 'MAILTYPE';

SELECT name,email_address, 

       nvl(WF_PREF.get_pref(name, 'MAILTYPE'),notification_preference) 

       as "Notification_Preference"

FROM wf_roles
WHERE name = upper('&recipient_role') --Enter FND User Name here

/

Query To Check Notification Status

select * from WF_NOTIFICATIONS
where ORIGINAL_RECIPIENT='SYSADMIN' --Enter FND User Name here

/