Query to check Active users

PROMPT Active Users:-

/* Formatted on 7/4/2014 2:19:13 PM (QP5 v5.115.810.9015) */
SELECT fnd.user_name,
       icx.responsibility_application_id,
       icx.responsibility_id,
       frt.responsibility_name,
       icx.session_id,
       icx.first_connect,
       icx.last_connect,
       DECODE ( (icx.disabled_flag), 'N', 'ACTIVE', 'Y', 'INACTIVE') status
FROM fnd_user fnd, icx_sessions icx, fnd_responsibility_tl frt
WHERE     fnd.user_id = icx.user_id
      AND icx.responsibility_id = frt.responsibility_id
      AND icx.disabled_flag <> 'Y'
      AND TRUNC (icx.last_connect) = TRUNC (SYSDATE)
ORDER BY icx.last_connect;