Wednesday, December 28, 2022

Find EBS Profile Value in All Level


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) LIKE UPPER('&ProfileName%');