This content has been marked as final. Show 3 replies
WHERE USER_NAME = '-WF_DEFAULT-'
--AND PREFERENCE_NAME = p_preference_name
AND MODULE_NAME = 'WF';
For the for the admin role:
That was excatly what i was looking for - Thanks
Whould you happen to know that table that matches up the following data?
'QUERY', 'Do Not Send Me mail',
'MAILHTM2', 'HTML Mail',
'MAILHTML', 'HTML Mail with Attachments',
'SUMHTML', 'HTML Summay Mail',
'MAILTEXT', 'Plain Text Mail',
'MAILATTH', 'Plain Text Mail with Attachments',
'SUMMARY', 'Plan Text Summay Mail'
The first column is the preference_value from the fnd_user_preferences table the second is the setting in the Global preferences notificaion style
Thanks in advance