EBS responsibility SQL Query
SELECT
fa.application_short_name,
fr.responsibility_key,
frt.responsibility_name,
frg.request_group_name,
fdg.data_group_name,
fmt.user_menu_name
FROM applsys.fnd_responsibility fr,
applsys.fnd_responsibility_tl frt,
apps.fnd_application fa,
apps.fnd_request_groups frg,
applsys.fnd_data_groups fdg,
apps.fnd_menus_tl fmt
WHERE fr.RESPONSIBILITY_ID=frt.RESPONSIBILITY_ID
AND fr.APPLICATION_ID=frt.APPLICATION_ID
AND fr.application_id = fa.application_id
AND nvl(fr.end_date, sysdate) >= sysdate
and frg.request_group_id = fr.request_group_id
and frg.application_id = fr.group_application_id
and fdg.data_group_id = fr.data_group_id
and fr.menu_id = fmt.menu_id
;