Query for Which User has assigned which responsibility and report

select  frv.RESPONSIBILITY_NAME,frv.RESPONSIBILITY_ID,fu.USER_NAME, frg.REQUEST_GROUP_NAME,frg.REQUEST_GROUP_CODE,frgu.REQUEST_GROUP_ID,
        decode(frgu.APPLICATION_ID,401,'INV') APPLICATION, frgu.REQUEST_UNIT_ID, a.USER_CONCURRENT_PROGRAM_NAME
from    FND_CONCURRENT_PROGRAMS_VL a,
        FND_REQUEST_GROUP_UNITS frgu,
        FND_REQUEST_GROUPS frg,
        FND_RESPONSIBILITY_VL frv,
        FND_USER_RESP_GROUPS_DIRECT fcr,
        fnd_user fu 
where   frgu.REQUEST_UNIT_ID    =   a.CONCURRENT_PROGRAM_ID
and     frgu.APPLICATION_ID     =   frg.APPLICATION_ID
and     frgu.REQUEST_GROUP_ID   =   frg.REQUEST_GROUP_ID
and     frgu.REQUEST_GROUP_ID   =   frv.REQUEST_GROUP_ID
and     frgu.APPLICATION_ID     =   frv.APPLICATION_ID
and     frv.RESPONSIBILITY_ID   =   fcr.RESPONSIBILITY_ID(+)
and     fcr.USER_ID             =   fu.USER_ID(+)
--and     a.CONCURRENT_PROGRAM_ID =   32427
and     frg.APPLICATION_ID      =   401
--and     frgu.REQUEST_GROUP_ID   =   58