Query To get User Name, Resp Name , Request Group Name ,Concurrent Program Name

select fcp.LAST_UPDATE_DATE,u.USER_NAME,frt.RESPONSIBILITY_ID,frt.RESPONSIBILITY_NAME,frg.REQUEST_GROUP_NAME ,fcp.CONCURRENT_PROGRAM_NAME
from fnd_user u,fnd_responsibility_tl frt , FND_RESPONSIBILITY fr,fnd_request_groups frg,fnd_concurrent_programs fcp,FND_REQUEST_GROUP_UNITS frgu,FND_USER_RESP_GROUPS_DIRECT furgd
where u.user_name='SHIVAJI'
and frt.RESPONSIBILITY_NAME like'Purc%'
and fr.RESPONSIBILITY_ID=frt.RESPONSIBILITY_ID
and fr.REQUEST_GROUP_ID=frg.REQUEST_GROUP_ID
and furgd.RESPONSIBILITY_ID=frt.RESPONSIBILITY_ID
and u.USER_ID=furgd.USER_ID
and fcp.CONCURRENT_PROGRAM_ID=frgu.REQUEST_UNIT_ID
and fcp.APPLICATION_ID=fr.APPLICATION_ID
order by fcp.LAST_UPDATE_DATE desc;

select * from FND_USER_RESP_GROUPS;

select * from FND_USER_RESP_GROUPS_DIRECT;