Thursday, 30 April 2015

How do get user level Profile option

Hi Folks,

Below is the query to get User Profile Option.



/* How do get user level Profile option  */

 SELECT   p.user_profile_option_name, '3 - User', u.user_name, v.level_value,
         v.profile_option_value
    FROM fnd_profile_option_values v, fnd_profile_options_vl p, fnd_user u
   WHERE v.profile_option_id = p.profile_option_id
     AND (v.level_id = 10004 AND u.user_id = v.level_value)
     AND u.user_name = :User_ID
ORDER BY 1, 2, 3

No comments:

Post a Comment