User Responsibility

SELECT DISTINCT u.user_name, wur.role_orig_system_id responsibility_id
, wura.start_date, wura.end_date end_date, wura.created_by created_by
, wura.creation_date creation_date, wura.last_updated_by last_updated_by
, wura.last_update_date last_update_date
, wura.last_update_login last_update_login
, wura.assignment_reason description
, res.responsibility_name
FROM fnd_user u
, wf_user_role_assignments wura
, wf_all_user_roles wur
, fnd_responsibility_tl res
WHERE u.user_name = wura.user_name
AND wura.relationship_id = -1
AND wur.role_orig_system = 'FND_RESP'
AND NOT wura.role_name LIKE 'FND_RESP|%|ANY'
AND wura.role_name = wur.role_name
AND wura.user_name = wur.user_name
AND res.responsibility_id = wur.role_orig_system_id
AND u.user_id = 17879
--AND wur.role_orig_system_id IN ( 53721, 53741 )