[Home] [Help] [Dependency Information]
Object Name: | JTF_PF_TMP_ACTIVITY |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_PF_TMP_ACTIVITY |
Subobject Name: | |
Status: | VALID |
Temporary
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQID | NUMBER | Yes | Sequence Id | |
DAY | DATE | Yes | Day of request | |
TIMESTAMP | DATE | Yes | Timestamp | |
SERVERNAME | VARCHAR2 | (300) | Apache server name | |
SERVERPORT | NUMBER | Apache port | ||
JSERVPORT | NUMBER | Jserv port | ||
FLOWID | NUMBER | DPF Flow id | ||
SESSIONID | NUMBER | Session id | ||
USERID | NUMBER | User id | ||
APPID | NUMBER | application id | ||
RESPID | NUMBER | responsibility id | ||
LANGID | VARCHAR2 | (20) | Language Id | |
STARTT | NUMBER | Yes | start time | |
PAGENAME | VARCHAR2 | (300) | Yes | Page name |
STATUSCODE | NUMBER | Yes | status code of request (succeeded/failed etc.) | |
EXECT | NUMBER | Yes | Page execution time | |
THINKT | NUMBER | Think time. Time between last requset on the same session and this request | ||
PO | NUMBER | Yes | Link to page object | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Standard who col | |
CREATED_BY | NUMBER | (15) | Yes | Standard who col |
CREATION_DATE | DATE | Yes | Standard who col | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who col |
LAST_UPDATE_DATE | DATE | Yes | Standard who col | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who col | |
SECURITY_GROUP_ID | NUMBER | Standard who col | ||
TECH_STACK | VARCHAR2 | (20) | Yes | Tech Stack |
Cut, paste (and edit) the following text to query this object:
SELECT SEQID
, DAY
, TIMESTAMP
, SERVERNAME
, SERVERPORT
, JSERVPORT
, FLOWID
, SESSIONID
, USERID
, APPID
, RESPID
, LANGID
, STARTT
, PAGENAME
, STATUSCODE
, EXECT
, THINKT
, PO
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, TECH_STACK
FROM JTF.JTF_PF_TMP_ACTIVITY;
JTF.JTF_PF_TMP_ACTIVITY does not reference any database object
JTF.JTF_PF_TMP_ACTIVITY is referenced by following:
|
|
|