--Kindly change the highlighted in Yellow to your responsibility name
SELECT fu.user_name "User Name", fr.responsibility_name "Responsibility",
fa.application_name "Application", fur.start_date "From",
fur.end_date "To", fm.user_menu_name "Menu",
frg.request_group_name "Request Group"
FROM fnd_user fu,
fnd_user_resp_groups_all fur,
fnd_responsibility_vl fr,
fnd_application_vl fa,
fnd_menus_vl fm,
fnd_request_groups frg
WHERE fu.user_id = fur.user_id
AND fur.responsibility_id = fr.responsibility_id
AND fr.application_id = fa.application_id
AND fr.menu_id = fm.menu_id
AND fr.request_group_id = frg.request_group_id(+)
AND UPPER (fr.responsibility_name) = UPPER ('Application Developer')
SELECT fu.user_name "User Name", fr.responsibility_name "Responsibility",
fa.application_name "Application", fur.start_date "From",
fur.end_date "To", fm.user_menu_name "Menu",
frg.request_group_name "Request Group"
FROM fnd_user fu,
fnd_user_resp_groups_all fur,
fnd_responsibility_vl fr,
fnd_application_vl fa,
fnd_menus_vl fm,
fnd_request_groups frg
WHERE fu.user_id = fur.user_id
AND fur.responsibility_id = fr.responsibility_id
AND fr.application_id = fa.application_id
AND fr.menu_id = fm.menu_id
AND fr.request_group_id = frg.request_group_id(+)
AND UPPER (fr.responsibility_name) = UPPER ('Application Developer')