Users and there Responsibilities

Script to check Responsibilities assigned to a particular user or users assigned for particular responsibility or all users and their responsibilities:

SELECT fu.user_id,

fu.user_name,

fur.responsibility_id,
          fr.responsibility_name
FROM fnd_user fu,

fnd_user_resp_groups fur,

fnd_responsibility_vl fr
WHERE fu.user_id = fur.user_id
AND fr.application_id = fur.responsibility_application_id
AND fr.responsibility_id = fur.responsibility_id
AND TRUNC (SYSDATE) BETWEEN TRUNC (fr.start_date)
AND TRUNC (NVL ((fr.end_date - 1), SYSDATE))
AND TRUNC (SYSDATE) BETWEEN TRUNC (fur.start_date)
AND TRUNC (NVL ((fur.end_date - 1), SYSDATE))
AND user_name like ‘OPERATIONS’ --- for all user or for particular user
AND fur.responsibility_application_id = 155 –- Check particular resp.

order by user_name