Number of users logged into Oracle E-Business Suite

SELECT

  TO_CHAR(START_TIME,'DD-MON-YYYY') Login_Time,

  COUNT(*) cnt

FROM fnd_logins

WHERE 1=1

  AND START_TIME > ( SELECT TO_DATE('25-AUG-2010 00:00:00','DD-MON-YYYY HH24:MI:SS') FROM dual )

  AND login_type IS NOT NULL

  AND END_TIME IS NULL

GROUP BY TO_CHAR(START_TIME,'DD-MON-YYYY');