Check User -- Application and assigned responsiblity

SELECT
UNIQUE u.user_id,

SUBSTR (u.user_name, 1, 30) user_name,

SUBSTR (A.APPLICATION_NAME, 1, 50) Application,

SUBSTR (R.RESPONSIBILITY_NAME, 1, 60) Responsiblity

FROM
fnd_user u,

FND_USER_RESP_GROUPS G,

fnd_application_tl A,

FND_RESPONSIBILITY_TL R

WHERE
G.User_Id(+) = U.User_ID

AND G.RESPONSIBILITY_APPLICATION_ID = A.Application_Id

AND A.Application_Id = R.Application_Id

AND G.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID

ORDER BY SUBSTR (user_name, 1, 30),

SUBSTR (A.APPLICATION_NAME, 1, 50),

SUBSTR (R.RESPONSIBILITY_NAME, 1, 60)