[Home] [Help] [Dependency Information]
Object Name: | JTF_PF_SESSION_SUMM |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_PF_SESSION_SUMM |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_PF_SESSION_SUMM_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SESSIONID |
JTF_PF_SESSION_SUMM_N1 | BITMAP | NONUNIQUE | APPS_TS_TX_IDX | DAY |
JTF_PF_SESSION_SUMM_N2 | BITMAP | NONUNIQUE | APPS_TS_TX_IDX | USERID |
JTF_PF_SESSION_SUMM_N3 | BITMAP | NONUNIQUE | APPS_TS_TX_IDX | USER_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DAY | DATE | Yes | ||
SEQID | NUMBER | Yes | ||
SESSIONID | NUMBER | |||
USER_NAME | VARCHAR2 | (100) | ||
USERID | NUMBER | |||
SUM_EXECT_JTF | NUMBER | |||
SUM_THINKT_JTF | NUMBER | |||
CNT_PAGES_JTF | NUMBER | |||
SUM_EXECT_OAF | NUMBER | |||
SUM_THINKT_OAF | NUMBER | |||
CNT_PAGES_OAF | NUMBER | |||
SUM_EXECT_FORM | NUMBER | |||
SUM_THINKT_FORM | NUMBER | |||
CNT_PAGES_FORM | NUMBER | |||
CNT_PAGES_ALL | NUMBER | |||
UCNT_PAGES | NUMBER | |||
UCNT_FLOWS | NUMBER | |||
UCNT_USERS | NUMBER | |||
UCNT_APPS | NUMBER | |||
UCNT_RESPS | NUMBER | |||
UCNT_LANGS | NUMBER | |||
STARTT | NUMBER | Yes | ||
ENDT | NUMBER | Yes | ||
CNT_FAIL | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT DAY
, SEQID
, SESSIONID
, USER_NAME
, USERID
, SUM_EXECT_JTF
, SUM_THINKT_JTF
, CNT_PAGES_JTF
, SUM_EXECT_OAF
, SUM_THINKT_OAF
, CNT_PAGES_OAF
, SUM_EXECT_FORM
, SUM_THINKT_FORM
, CNT_PAGES_FORM
, CNT_PAGES_ALL
, UCNT_PAGES
, UCNT_FLOWS
, UCNT_USERS
, UCNT_APPS
, UCNT_RESPS
, UCNT_LANGS
, STARTT
, ENDT
, CNT_FAIL
FROM JTF.JTF_PF_SESSION_SUMM;
JTF.JTF_PF_SESSION_SUMM does not reference any database object
JTF.JTF_PF_SESSION_SUMM is referenced by following:
|
|
|