Tuesday, 31 March 2020

Query to get the profile option values from backend

 select fpo.profile_option_id 
       ,fpo.profile_option_name 
       ,fpo.user_profile_option_name 
       ,decode(level_id,10001,'Site'           
                       ,10002,'Application'
                       ,10003,'Responsibility'
                       ,10004,'User'
                       ,10006,'Organization') profile_level 
       ,decode(level_id,10002, (select application_name 
                                from apps.fnd_application_vl 
                                where application_id = level_value ) 
                       ,10003, (select responsibility_name 
                                from apps.fnd_responsibility_vl 
                                where responsibility_id = level_value) 
                       ,10004, (select user_name 
                                from apps.fnd_user 
                                where user_id = level_value) 
                       ,10006, (select name   
                                from apps.hr_all_organization_units     
                                where organization_id = level_value)) level_value 
       ,profile_option_value 
  from apps.fnd_profile_options_vl fpo 
      ,apps.fnd_profile_option_values fpov 
  where fpo.profile_option_id = fpov.profile_option_id 
  and   (fpo.profile_option_name like 'Profilename' 
         or fpo.user_profile_option_name like <user Profile Option name>); 

No comments:

Post a Comment