SQL to get profile option values at responsibility level in Oracle Apps R12

 

--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 1=1

    AND 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    = 'OM SuperUser, UK'

ORDER BY

    frv.responsibility_name;