查询EBS的在线用户信息

查询EBS的在线用户信息： 

select distinct fu.user_name
,ap.application_short_name
,fat.application_name
,fr.responsibility_key
,frt.responsibility_name
,fff.function_name
,fft.user_function_name
,icx.function_type
,icx.first_connect
,icx.last_connect
from apps.icx_sessions icx
,apps.fnd_user fu
,apps.fnd_application ap
,apps.fnd_application_tl fat
,apps.fnd_responsibility fr
,apps.fnd_responsibility_tl frt
,apps.fnd_form_functions fff
,apps.fnd_form_functions_tl fft
where 1 = 1
and fu.user_id = icx.user_id
and icx.responsibility_application_id = ap.application_id
and fat.application_id = icx.responsibility_application_id
and fat.language = 'US'
and fr.application_id = icx.responsibility_application_id
and fr.responsibility_id = icx.responsibility_id
and frt.language = 'US'
and fft.language = 'US'
and frt.application_id = icx.responsibility_application_id
and frt.responsibility_id = icx.responsibility_id
and fff.function_id = icx.function_id
and fft.function_id = icx.function_id
and icx.disabled_flag != 'Y'
and icx.pseudo_flag = 'N'
and (icx.last_connect +
decode(apps.fnd_profile.value('ICX_SESSION_TIMEOUT'),
null,
icx.limit_time,
0,
icx.limit_time,
apps.fnd_profile.value('ICX_SESSION_TIMEOUT') / 60) / 24) > sysdate
and icx.counter < icx.limit_connects
;