This content has been marked as final. Show 1 reply
Ruth, I thought we discussed this already in earlier thread, but did not see my update. I scanned apps but not where this info is stored (looks like). I wish I am wrong!
In my opinion there are doing exactly what you pointed like you have shown like..
select decode (preference_value, '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'