[Home] [Help]
View: JTF_IMP_PISUMMARY_VL
Product: | JTF - CRM Foundation |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
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
Name |
BUG_NO |
SNAPSHOT_ID |
NEW |
UPGRADE |
OVERWRITE |
NOT_APPLIED |
INSTALL_CNT |
FILES_CNT |
AFFECTED |
APP_CNT |