--查看在线EBS用户的相关信息

SELECT PAP.FULL_NAME,

       FU.USER_NAME,

       FAT.APPLICATION_NAME,

       FRT.RESPONSIBILITY_NAME,

       FFT.USER_FUNCTION_NAME,

       ICX.FUNCTION_TYPE,

       ICX.FIRST_CONNECT,

       ICX.LAST_CONNECT,

       ICX.ORG_ID,

       FFF.FUNCTION_NAME,

       APP.APPLICATION_SHORT_NAME,

       ICX.RESPONSIBILITY_ID,

       FR.RESPONSIBILITY_KEY

  FROM ICX_SESSIONS          ICX,

       FND_USER              FU,

       PER_ALL_PEOPLE_F      PAP,

       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 FU.USER_ID = ICX.USER_ID

   AND PAP.PERSON_ID = FU.EMPLOYEE_ID

   AND SYSDATE BETWEEN NVL(PAP.EFFECTIVE_START_DATE, (SYSDATE - 1)) AND

       NVL(PAP.EFFECTIVE_END_DATE, (SYSDATE + 1))

   AND ICX.RESPONSIBILITY_APPLICATION_ID = APP.APPLICATION_ID

   AND FAT.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID

   AND FR.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID

   AND FR.RESPONSIBILITY_ID = ICX.RESPONSIBILITY_ID

   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 FRT.LANGUAGE = 'ZHS'

   AND FFT.LANGUAGE = 'ZHS'

   AND FAT.LANGUAGE = 'ZHS'

   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;