Logged Users (outside of concurrent manager jobs -- forms and web users) into E-Business System at any One Time and the High Water Mark

select u.user_name, r.responsibility_name, f.user_function_name, s.function_type,

to_char(s.first_connect, 'DD-MON HH24:MI:SS') "First Connect",

to_char(s.last_connect, 'DD-MON HH24:MI:SS') "Last Connect", n.node_name

from icx_sessions s, fnd_user u, fnd_responsibility_vl r, fnd_form_functions_vl f, fnd_nodes n

where u.user_id(+) = s.user_id

AND f.function_id(+) = s.function_id

AND r.responsibility_id(+) = s.responsibility_id

AND n.node_id(+) = s.node_id

AND s.disabled_flag != 'Y'

and s.pseudo_flag = 'N'

and (s.last_connect + decode(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'), NULL,s.limit_time, 0,s.limit_time,FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT')/60)/24) > sysdate

and s.counter < s.limit_connects