[Home] [Help]
View: JTF_PF_WA_INFO_VL
View Text
( SELECT
X.PAGEOBJECT.INFO.RECID
,
X.PAGEOBJECT.INFO.DAY
,
X.PAGEOBJECT.INFO.TIMESTAMP
,
X.PAGEOBJECT.DPF.PHYSICALPAGEID
,
X.PAGEOBJECT.DPF.LOGICALPAGEID
,
X.PAGEOBJECT.DPF.FLOWID
,
X.PAGEOBJECT.SES.APPID
,
X.PAGEOBJECT.SES.RESPID
,
X.PAGEOBJECT.SES.USERID
,
X.PAGEOBJECT.SES.SESSIONID
,
X.PAGEOBJECT.SES.LANGID
,
X.PAGEOBJECT.JSP.SCHEME
,
X.PAGEOBJECT.JSP.METHOD
,
X.PAGEOBJECT.JSP.NAME
,
X.PAGEOBJECT.JSP.STARTTIME
,
X.PAGEOBJECT.JSP.EXECUTIONTIME
,
X.PAGEOBJECT.JSP.STATUSCODE
,
X.PAGEOBJECT.JSP.CONTENTTYPE
,
X.PAGEOBJECT.JSP.CONTENTLENGTH
,
X.PAGEOBJECT.LOC.SERVERNAME
,
X.PAGEOBJECT.LOC.SERVERPORT
,
X.PAGEOBJECT.LOC.JSERVPORT
,
X.PAGEOBJECT.LOC.CLIENTNAME
,
X.PAGEOBJECT.LOC.CLIENTIP
,
X.PAGEOBJECT.LANG.SESSIONLANGUAGECODE
,
X.PAGEOBJECT.LANG.SERVERCHARACTERENCODING
,
X.PAGEOBJECT.LANG.PAGECHARACTERENCODING
,
X.PAGEOBJECT.LANG.CLIENTCHARACTERENCODING
,
X.PAGEOBJECT.LANG.CLIENTACCEPTEDLANGUAGES
,
X.PAGEOBJECT.LANG.CLIENTACCEPTEDCHARSETS
,
X.PAGEOBJECT.CLIENT.AUTHTYPE
,
X.PAGEOBJECT.CLIENT.PROTOCOL
,
X.PAGEOBJECT.CLIENT.REFERER
,
X.PAGEOBJECT.CLIENT.USERAGENT
,
X.PAGEOBJECT.CLIENT.CONTENTTYPE
,
X.PAGEOBJECT.CLIENT.CONTENTLENGTH
,
X.PAGEOBJECT.PRODINFO.ATTR1
,
X.PAGEOBJECT.PRODINFO.ATTR2
,
X.PAGEOBJECT.PRODINFO.ATTR3
,
X.PAGEOBJECT.PRODINFO.ATTR4
,
X.PAGEOBJECT.PRODINFO.ATTR5
,
X.PAGEOBJECT.PRODINFO.ATTR6
,
X.PAGEOBJECT.PRODINFO.ATTR7
,
X.PAGEOBJECT.PRODINFO.ATTR8
,
X.PAGEOBJECT.PRODINFO.ATTR9
,
X.PAGEOBJECT.PRODINFO.ATTR10
,
X.PAGEOBJECT.PRODINFO.ATTR11
,
X.PAGEOBJECT.PRODINFO.ATTR12
,
X.PAGEOBJECT.PRODINFO.ATTR13
,
X.PAGEOBJECT.PRODINFO.ATTR14
,
X.PAGEOBJECT.PRODINFO.ATTR15
,
X.PAGEOBJECT.PRODINFO.ATTR16
,
X.PAGEOBJECT.PRODINFO.ATTR17
,
X.PAGEOBJECT.PRODINFO.ATTR18
,
X.PAGEOBJECT.PRODINFO.ATTR19
,
X.PAGEOBJECT.PRODINFO.ATTR20
,
X.PAGEOBJECT.PRODINFO.ATTR21
,
X.PAGEOBJECT.PRODINFO.ATTR22
,
X.PAGEOBJECT.PRODINFO.ATTR23
,
X.PAGEOBJECT.PRODINFO.ATTR24
,
X.PAGEOBJECT.PRODINFO.ATTR25
,
X.PAGEOBJECT.PRODINFO.PARAMS
,
X.PAGEOBJECT.PARAMS
,
X.PAGEOBJECT.COOKIES
,
X.PAGEOBJECT.HEADERS
,
X.TRACK_PURPOSE
,
X.CREATED_BY
,
X.CREATION_DATE
,
X.LAST_UPDATED_BY
,
X.LAST_UPDATE_DATE
,
X.LAST_UPDATE_LOGIN
FROM JTF_PF_REPOSITORY X
WHERE X.TRACK_PURPOSE IN (2
, 3
, 4)
)