[Home] [Help]
View: FND_IMP_FILETYPECOUNT_VL
View Text
SELECT SNAPSHOT_ID
, BUG_NO
, FILE_TYPE
, SUM(DECODE(TYPEID
, 'NOT APPLIED'
, 1
, 0)) NOT_APPLIED
, SUM(DECODE(TYPEID
, 'UPGRADE'
, 1
, 0)) UPGRADE
, SUM(DECODE(TYPEID
, 'NEW'
, 1
, 0)) NEW
, PATCH_ID
FROM FND_IMP_PSMASTER2 GROUP BY SNAPSHOT_ID
, BUG_NO
, PATCH_ID
, FILE_TYPE HAVING SUM(DECODE(TYPEID
, 'UPGRADE'
, 1
, 0)) > 0 OR SUM(DECODE(TYPEID
, 'NEW'
, 1
, 0)) > 0
Columns
Name |
SNAPSHOT_ID |
BUG_NO |
FILE_TYPE |
NOT_APPLIED |
UPGRADE |
NEW |
PATCH_ID |