Oracle SQL to get Profile Option Values at Responsibility level

SELECT frv.responsibility_name,
  fpo.profile_option_name,
  fpot.user_profile_option_name,
  fpov.profile_option_value
FROM fnd_profile_options_tl fpot,
  fnd_profile_options fpo,
  fnd_profile_option_values fpov,
  FND_RESPONSIBILITY_VL frv
WHERE fpot.profile_option_name =
fpo.profile_option_name
AND fpo.profile_option_id   
  = fpov.profile_option_id
AND fpov.level_id     
        = ‘10003’
AND fpov.level_value     
     = frv.responsibility_id
–AND frv.responsibility_name   
= ‘General Ledger Super User’
order by frv.responsibility_name;

  • September 27, 2018 | 19 views
  • Comments