( 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)
)
( 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)
)
|
|
|