Sunday 14 February 2016

Find Profile Option values using SQL queries

http://dbissues.blogspot.com/2016/02/find-profile-option-values-using-sql.html

SELECT e.profile_option_name Profile,
        f.user_profile_option_name User_Profile_Name, c.application_short_name,
        decode(a.level_id,10001,'Site',10002,'Application',10003,'Resp',10004,'User') LevelSet_At,
        decode(a.level_id,10001,'Site',10002,c.application_short_name,
        10003,b.responsibility_name,10004,d.user_name) LValue,
        nvl(a.profile_option_value,'Is Null') Value
   FROM  fnd_profile_option_values a, fnd_responsibility_tl b,
        fnd_application c, fnd_user d, fnd_profile_options e, fnd_profile_options_vl f
      WHERE  f.user_profile_option_name like 'OS%'
             AND  e.profile_option_id = a.profile_option_id
          AND  e.profile_option_id = f.profile_option_id
       AND  a.level_value = b.responsibility_id (+)
       AND  a.level_value = c.application_id (+)
    AND  a.level_value = d.user_id (+)
   ORDER BY 1,2;

No comments:

Post a Comment