To get user responsibilities and details

SELECT fu.user_name,
       he.full_name person_name,
       fu.description,
       fu.start_date user_start_date,
       fu.end_date user_end_date,
       fu.last_logon_date user_logon_date,
       fu.email_address,
       (CASE
           WHEN TRUNC (fu.end_date) < SYSDATE THEN 'IN-ACTIVE'
           ELSE 'ACTIVE'
        END)
          status,
       frv.responsibility_name,
       fav.application_name,
       fur.start_date user_resp_start_date,
       fur.end_date user_resp_end_date,
       (SELECT MAX (last_update_date)
        FROM fnd_concurrent_requests
        WHERE requested_by = fu.user_id)
          last_concurrent_req_date
FROM fnd_user fu,
     fnd_user_resp_groups_direct fur,
     per_all_people_f he,
     fnd_responsibility_vl frv,
     fnd_application_vl fav
WHERE    fu.user_id = fur.user_id
      AND fu.employee_id = he.person_id(+)
      AND fur.responsibility_id = frv.responsibility_id
      AND fav.application_id = frv.application_id
      AND fu.user_name in ('')
ORDER BY fu.user_name