Oracle responsibilities - menu and submenu in a FORM on oracle e-business suite 12.2
I am using the following SQLs to get responsibility_name and description fields.
select a.application_name, r.responsibility_name, r.description
from apps.fnd_user u, apps.fnd_user_resp_groups_all ur,
apps.fnd_responsibility_vl r, apps.fnd_application_vl a
where a.application_id = r.application_id
and r.end_date is null
and r.version in ('4','W','M')
and r.application_id = ur.responsibility_application_id
and r.responsibility_id = ur.responsibility_id
and ur.user_id = u.user_id