查询EBS 系统在线人数代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】查询EBS 系统在线人数

作者:dezai / 发布于2014/1/26/ 1275

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;

试试其它关键字

　EBS在线人数　

同语言下

可能有用的

dezai贡献的其它代码(1065)