Count of Active ERP users

The below query will list out exactly who are all the current users logged in Oracle E-Business Suite system.

sqlplus apps/apps

spool /tmp/Active_Users_ERP_03_July_2014.html

set markup html on 
set echo on 

SELECT DISTINCT 

  fu.user_name User_Name,
  fr.RESPONSIBILITY_KEY Responsibility,
  fu.user_id,
  fu.description,
  fu.employee_id,
  ic.responsibility_application_id,
  ic.responsibility_id,
  ic.org_id,
  ic.function_type,
  ic.counter,
  ic.first_connect,
  ic.last_connect,
  ic.nls_territory,
  ic.time_out,
  fr.menu_id,
  fr.responsibility_key
FROM fnd_user fu,
  fnd_responsibility fr,
  icx_sessions ic
WHERE fu.user_id          = ic.user_id
AND fr.responsibility_id  = ic.responsibility_id
AND ic.disabled_flag      ='N'
and IC.RESPONSIBILITY_ID is not null
AND ic.last_connect      > sysdate - (ic.time_out/60)/96;

set markup html off 
spool off