Query to get list of EBS users with responsibility and last login date (responsibility wise)

Script:

SELECT

    usr.user_name,

    rsp.responsibility_name,

    MAX(ful.start_time) "LAST_CONNECT"

FROM

    apps.icx_sessions ses,

    apps.fnd_user usr,

    apps.fnd_logins ful,

    apps.fnd_responsibility_tl rsp

WHERE

     ses.login_id (+) = ful.login_id

    AND

        ses.responsibility_id = rsp.responsibility_id (+)

    AND

        ses.responsibility_application_id = rsp.application_id (+)

    AND

        usr.user_id = ful.user_id

 and rsp.responsibility_name is not null

GROUP BY

    usr.user_name,

    rsp.responsibility_name

ORDER BY

    usr.user_name,

    rsp.responsibility_name,

    last_connect;

Based on user active or not active

SELECT 

    fu.user_name,

    fu.description,

    fu.user_id,

    DECODE(fu.end_date, NULL, 'ACTIVE', 'INACTIVE') AS account_status,

    fu.start_date,

    fu.end_date,

    fu.last_logon_date,

    CASE 

        WHEN EXISTS (

            SELECT 1

            FROM fnd_user_resp_groups_direct furg

            JOIN fnd_responsibility fr 

                ON furg.responsibility_id = fr.responsibility_id

            WHERE furg.user_id = fu.user_id

              AND fr.responsibility_key = 'SYSTEM_ADMINISTRATOR'

        )

        THEN 'ADMIN'

        ELSE 'STANDARD'

    END AS role

FROM fnd_user fu

ORDER BY fu.user_name;