VIEW: APPS.JTF_PF_CLKSTRM_VL

Source

View Text - Preformatted

(
	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,
		jtf_pf_conv_pkg.GetParamString(x.pageobject.params),
		jtf_pf_conv_pkg.GetCookieString(x.pageobject.cookies)
	from jtf_pf_repository x
)

   

View Text - HTML Formatted

( 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
, JTF_PF_CONV_PKG.GETPARAMSTRING(X.PAGEOBJECT.PARAMS)
, JTF_PF_CONV_PKG.GETCOOKIESTRING(X.PAGEOBJECT.COOKIES) FROM JTF_PF_REPOSITORY X )