[Home] [Help]
[Dependency Information]
| Object Name: | JTF_PF_ALL_ACTIVITY_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | JTF.JTF_PF_ALL_ACTIVITY_VL
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SEQID | NUMBER | |||
| DAY | DATE | |||
| TIMESTAMP | DATE | |||
| SERVERNAME | VARCHAR2 | (300) | ||
| SERVERPORT | NUMBER | |||
| JSERVPORT | NUMBER | |||
| FLOWID | NUMBER | |||
| SESSIONID | NUMBER | |||
| USERID | NUMBER | |||
| APPID | NUMBER | |||
| RESPID | NUMBER | |||
| LANGID | VARCHAR2 | (20) | ||
| STARTT | NUMBER | |||
| PAGENAME | VARCHAR2 | (300) | ||
| STATUSCODE | NUMBER | |||
| EXECT | NUMBER | |||
| THINKT | NUMBER | |||
| PO | NUMBER | |||
| TECH_STACK | VARCHAR2 | (20) | ||
| PROXYID | NUMBER | Proxy ID |
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
, TECH_STACK
, PROXYID
FROM APPS.JTF_PF_ALL_ACTIVITY_VL;
APPS
JTF_PF_ANON_ACTIVITY
JTF_PF_SES_ACTIVITY
APPS
JTF_PF_APP_SUMMARY_VL
JTF_PF_HOST_SUMMARY_VL
JTF_PF_PAGE_SUMMARY_VL
JTF_PF_SEQ_VL
JTF_PF_USER_SUMMARY_VL
|
|
|
|