[Home] [Help]
View: JTF_MON_SSTAT
Product: | JTF - CRM Foundation |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT HIT.SESKEY
, SNAME.SESSION_ID
, HIT.PAGE_ID
, HIT.START_TIME
, HIT.USER_ID
, HIT.APP_ID
, HIT.RESP_ID
FROM (SELECT SESKEY
, PAGE_ID
, START_TIME
, USER_ID
, APP_ID
, RESP_ID
FROM JTF_MON_ACT_LOG) HIT
, JTF_MON_SES_LOOKUP SNAME
WHERE HIT.SESKEY = SNAME.SESKEY
Columns
Name |
SESKEY |
SESSION_NAME |
PAGE_ID |
START_TIME |
USER_ID |
APP_ID |
RESP_ID |