[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 |