View: JTF_PF_APP_SUMMARY_VL

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

View Text

SELECT MASTER.DAY DAY
, CNT_PAGES_JTF
, CNT_PAGES_OAF
, CNT_PAGES_FORM
, NVL(CNT_FLOWS
, 0) CNT_FLOWS
, CNT_USERS
, CNT_APPS
, CNT_RESPS
, CNT_SESSIONS
, CNT_LANGS
FROM (SELECT DAY
, SUM(DECODE(TECH_STACK
, 'JTF'
, 1
, 0)) CNT_PAGES_JTF
, SUM(DECODE(TECH_STACK
, 'OAF'
, 1
, 0)) CNT_PAGES_OAF
, SUM(DECODE(TECH_STACK
, 'FORM'
, 1
, 0)) CNT_PAGES_FORM
, COUNT(UNIQUE(FLOWID)) UCNT_FLOWS
, COUNT(UNIQUE(USERID)) CNT_USERS
, COUNT(UNIQUE(APPID)) CNT_APPS
, COUNT(UNIQUE(RESPID)) CNT_RESPS
, COUNT(UNIQUE(SESSIONID)) CNT_SESSIONS
, COUNT(UNIQUE(LANGID)) CNT_LANGS
FROM JTF_PF_ALL_ACTIVITY_VL GROUP BY DAY) MASTER
, (SELECT DAY
, SUM(UCNT_FLOWS) CNT_FLOWS
FROM JTF_PF_SESSION_SUMMARY_VL GROUP BY DAY) SES
WHERE MASTER.DAY = SES.DAY(+)

Columns