Monday, September 16, 2013

How to view Profile Option values from Backend for all Levels

SELECT p.profile_option_name short_name, n.user_profile_option_name NAME,
       DECODE (v.level_id,
               10001, 'Site',
               10002, 'Application',
               10003, 'Responsibility',
               10004, 'User',
               'UnDef'
              ) level_set,
       v.level_value level_val, v.profile_option_value VALUE
  FROM fnd_profile_options p,
       fnd_profile_option_values v,
       fnd_profile_options_tl n
 WHERE p.profile_option_id = v.profile_option_id(+)
   AND p.profile_option_name = n.profile_option_name
   AND UPPER(n.user_profile_option_name)LIKEUPPER('%&ProfileName%');

No comments: