Query to get user details with responsibility list in Oracle Apps EBS

select fu.user_name, frt.RESPONSIBILITY_NAME, furg.end_date

from

fnd_user_resp_groups furg,

FND_RESPONSIBILITY fr,

fnd_responsibility_tl frt,

fnd_user fu

where fu.user_id = furg.user_id

and furg.responsibility_id = fr.RESPONSIBILITY_ID

and frt.responsibility_id = fr.RESPONSIBILITY_ID

order by 1;

Above query is to list the user with responsibility in Oracle Apps