View: JTF_PF_PAGE_SUMMARY_VL

Product:	JTF - CRM Foundation
Description:
Implementation/DBA Data:	APPS.JTF_PF_PAGE_SUMMARY_VL

View Text

SELECT DAY DAY
, PAGENAME PAGENAME
, TECH_STACK TECH_STACK
, COUNT(PAGENAME) CNT_PAGES
, COUNT(SESSIONID) CNT_SES
, COUNT(UNIQUE(SESSIONID)) UCNT_SES
, COUNT(UNIQUE(USERID)) UCNT_USERS
, COUNT(UNIQUE(APPID)) UCNT_APPS
, COUNT(UNIQUE(RESPID)) UCNT_RESPS
, COUNT(UNIQUE(LANGID)) UCNT_LANGS
, SUM(EXECT) SUM_EXECT
, SUM(THINKT) SUM_THINKT
, COUNT(THINKT) CNT_THINKT
, MIN(STARTT) STARTT
, MAX(STARTT+EXECT) ENDT
, SUM(DECODE(STATUSCODE
, -100
, 1
, 0)) CNT_FAIL
, SUM(DECODE(STATUSCODE
, -200
, 1
, 0)) CNT_FORWARD
FROM JTF_PF_ALL_ACTIVITY_VL GROUP BY DAY
, PAGENAME
, TECH_STACK

Columns