1 Reply Latest reply on Jul 31, 2008 3:41 PM by 628428

    what table matches the notificaion style to the preference_value ?

    user487555
      Whould anyone happen to know that table that matches up the following data?


      'QUERY', 'Do Not Send Me mail',
      'DISABLED', 'Disabled',
      '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

      Ruth
        • 1. Re: what table matches the notificaion style to the preference_value ?
          628428
          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',
          'DISABLED', 'Disabled',
          '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'
          from fnd_user_preferences....

          Thanks
          Nagamohan