View: JTF_IMP_PISUMMARY_VL

View Text

SELECT A.BUG_NO
, A.SNAPSHOT_ID
, A.NEW
, A.UPGRADE
, A.OVERWRITE
, A.NOT_APPLIED
, A.NEW+A.UPGRADE+A.OVERWRITE INSTALL_CNT
, A.NEW+A.UPGRADE+A.OVERWRITE+A.NOT_APPLIED FILES_CNT
, A.AFFECTED
, B.APP_CNT
FROM (SELECT BUG_NO
, SNAPSHOT_ID
, SUM(DECODE(TYPEID
, 'NEW'
, 1
, 0)) NEW
, SUM(DECODE(TYPEID
, 'UPGRADE'
, 1
, 0)) UPGRADE
, SUM(DECODE(TYPEID
, 'OVERWRITE'
, 1
, 0)) OVERWRITE
, SUM(DECODE(TYPEID
, 'NOT APPLIED'
, 1
, 0)) NOT_APPLIED
, SUM(FILES_AFFECTED) AFFECTED FROM JTF_IMP_PSMASTER2 P GROUP BY BUG_NO
, SNAPSHOT_ID) A
, (SELECT BUG_NO
, SNAPSHOT_ID
, COUNT(UNIQUE(APP_SHORT_NAME)) APP_CNT FROM JTF_IMP_PSMASTER2 P WHERE TYPEID IN ('NEW'
, 'UPGRADE'
, 'OVERWRITE') GROUP BY BUG_NO
, SNAPSHOT_ID) B
WHERE A.BUG_NO = B.BUG_NO AND A.SNAPSHOT_ID = B.SNAPSHOT_ID

Columns