DBA Data[Home] [Help] [Dependency Information]

TABLE: JTF.JTF_PF_ANON_ACTIVITY

Object Details
Object Name: JTF_PF_ANON_ACTIVITY
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTF_PF_ANON_ACTIVITY
Subobject Name:
Status: VALID


Activities that do not fall under any session


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTF_PF_ANON_ACTIVITY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSEQID
JTF_PF_ANON_ACTIVITY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDAY
JTF_PF_ANON_ACTIVITY_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATUSCODE
Columns
Name Datatype Length Mandatory Comments
SEQID NUMBER
Yes Sequence Id
DAY DATE
Yes The day
TIMESTAMP DATE
Yes Timestamp
SERVERNAME VARCHAR2 (300)
Apache server name
SERVERPORT NUMBER

Apache port
JSERVPORT NUMBER

Jserv port
FLOWID NUMBER

DPF Flowid
SESSIONID NUMBER

session id
USERID NUMBER

user id
APPID NUMBER

app id
RESPID NUMBER

resp id
LANGID VARCHAR2 (20)
language id
STARTT NUMBER
Yes start time
PAGENAME VARCHAR2 (300) Yes Name of page
STATUSCODE NUMBER
Yes status of request (whether it was an exception etc)
EXECT NUMBER
Yes Execution time
THINKT NUMBER

Think time. Time between the previous request in this session to this request
PO NUMBER
Yes Page Object link
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
PROXYID NUMBER

Proxy ID
Query Text

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
,      PROXYID
FROM JTF.JTF_PF_ANON_ACTIVITY;

Dependencies

[top of page]

JTF.JTF_PF_ANON_ACTIVITY does not reference any database object

JTF.JTF_PF_ANON_ACTIVITY is referenced by following:

SchemaAPPS
SynonymJTF_PF_ANON_ACTIVITY