Thursday, 27 September 2018

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;

No comments:

Post a Comment