Query to find the profile assigned to a Responsibility in Oracle Apps

 Query to find the profile assigned to a Responsibility in Oracle Apps

Query:

select distinct * from (SELECT  b.user_profile_option_name "Long Name" ,

  a.profile_option_name "Short Name" ,

  NVL(g.responsibility_name,c.level_value)  "Level Value" ,

  c.PROFILE_OPTION_VALUE "Profile Value"

FROM apps.fnd_profile_options a ,

  apps.FND_PROFILE_OPTIONS_tL b ,

  apps.FND_PROFILE_OPTION_VALUES c ,

  apps.FND_USER d ,

  apps.FND_USER e ,

  apps.FND_RESPONSIBILITY_tL g ,

  apps.FND_APPLICATION h

WHERE 1                   =1

AND a.profile_option_name = b.profile_option_name

AND a.profile_option_id   = c.profile_option_id

AND a.application_id      = c.application_id

AND c.last_updated_by     = d.user_id (+)

AND c.level_value         = e.user_id (+)

AND c.level_value         = g.responsibility_id (+)

AND c.level_value         = h.application_id (+)

  --

AND c.level_id            = 10003

and b.language='US'

AND g.responsibility_name = '%&Responsibility Name%'

ORDER BY b.user_profile_option_name,  c.level_id

);