VIEW: APPS.JTF_PF_APP_SUMMARY_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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