One of my old friend dropped me an email to provide him how find list of users and there responsibilities in his EBS system because his company auditors are asking him that. I provided him the query below which I want to share with you. I am using this query to find the same information for last 8 yrs.

SELECT FURRGA.USER_ID,FUR.USER_NAME,FURRGA.RESPONSIBILITY_ID,FREPO.RESPONSIBILITY_NAME,FURRGA.RESPONSIBILITY_APPLICATION_ID,FAPP.APPLICATION_SHORT_NAME,FURRGA.SECURITY_GROUP_ID,FSEQG.SECURITY_GROUP_KEY,FURRGA.START_DATE,FURRGA.END_DATE,FURRGA.CREATED_BY,FURAA.USER_NAME,FURRGA.CREATION_DATE,FURRGA.LAST_UPDATED_BY,FURLAB.USER_NAME,FURRGA.LAST_UPDATE_DATE,FURRGA.LAST_UPDATE_LOGIN,FURLAC.USER_NAME FROM FND_USER_RESP_GROUPS_ALL FURRGA,FND_USER FUR,FND_USER FURAA,FND_USER FURLAB,FND_USER FURLAC,FND_APPLICATION FAPP,FND_RESPONSIBILITY_TL FREPO,FND_SECURITY_GROUPS FSEQG WHERE FURRGA.USER_ID = FUR.USER_ID (+) AND FURRGA.CREATED_BY = FURAA.USER_ID (+) AND FURRGA.LAST_UPDATED_BY = FURLAB.USER_ID (+) AND FURRGA.LAST_UPDATE_LOGIN = FURLAC.USER_ID (+) AND FURRGA.RESPONSIBILITY_APPLICATION_ID = FAPP.APPLICATION_ID (+) AND FURRGA.RESPONSIBILITY_ID = FREPO.RESPONSIBILITY_ID (+) AND FREPO.LANGUAGE = 'US' AND FURRGA.SECURITY_GROUP_ID = FSEQG.SECURITY_GROUP_ID (+) ORDER BY START_DATE;