ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 查询EBS在线用户(转)

查询EBS在线用户(转)

原创 Linux操作系统 作者:asiaidea 时间:2013-04-17 18:49:28 0 删除 编辑
SELECT u.user_name
      ,app.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 icx_sessions          icx
      ,fnd_user              u
      ,fnd_application       app
      ,fnd_application_tl    fat
      ,fnd_responsibility    fr
      ,fnd_responsibility_tl frt
      ,fnd_form_functions    fff
      ,fnd_form_functions_tl fft
 WHERE 1 = 1
   AND u.user_id = icx.user_id
   AND icx.responsibility_application_id = app.application_id
   AND fat.application_id = icx.responsibility_application_id
   AND fat.language = 'ZHS'
   AND fr.application_id = icx.responsibility_application_id
   AND fr.responsibility_id = icx.responsibility_id
   AND frt.language = 'ZHS'
   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(fnd_profile.value('ICX_SESSION_TIMEOUT'),
               NULL,
               icx.limit_time,
               0,
               icx.limit_time,
               fnd_profile.value('ICX_SESSION_TIMEOUT') / 60) / 24) >
       SYSDATE
   AND icx.counter < icx.limit_connects
   AND u.user_name <> 'SYSADMIN';

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10359218/viewspace-758703/,如需转载,请注明出处,否则将追究法律责任。

全部评论

注册时间:2010-11-04

  • 博文量
    140
  • 访问量
    480808