EBS R12 Online user checking query

select usr.user_name,last_connect,
resp.RESPONSIBILITY_NAME,
function_type,fun.USER_FUNCTION_NAME
–icx.*
from apps.fnd_form_functions_vl
fun,apps.icx_sessions
icx
join apps.fnd_user
usr on
usr.user_id=icx.user_id
left join
apps.fnd_responsibility_vl
resp on
resp.responsibility_id=icx.responsibility_id
where last_connect>sysdate-nvl(apps.FND_PROFILE.VALUE(‘ICX_SESSION_TIMEOUT’),30)/60/24
and disabled_flag
!=
‘Y’
and
pseudo_flag =
‘N’
and icx.FUNCTION_ID=fun.FUNCTION_ID
order by
1

  • April 5, 2017 | 17 views
  • Comments