[Home] [Help]
View: FND_IMP_DIAGMAP_VL
Product: | FND - Application Object Library |
Description: | FND_DIAGMAP_VL |
Implementation/DBA Data: |
APPS.FND_IMP_DIAGMAP_VL
|
View Text
SELECT P.*
, (SELECT COUNT(*)
FROM JTF_DIAGNOSTIC_CMAP TMP
WHERE TMP.APPNAME = P.APPNAME
AND TMP.GROUPNAME = P.GROUPNAME
AND TMP.TESTCLASSNAME = P.TESTCLASSNAME) TOT_CNT
FROM ( SELECT SNAPSHOT_ID
, BUG_NO
, APPNAME
, GROUPNAME
, TESTCLASSNAME
, COUNT(*) PATCH_CNT
, PATCH_ID
FROM FND_IMP_PSMASTER2 MASTER
, JTF_DIAGNOSTIC_CMAP CMAP
WHERE TYPEID <> 'NOT APPLIED'
AND CLASSNAME = TRANS_NAME GROUP BY SNAPSHOT_ID
, BUG_NO
, PATCH_ID
, APPNAME
, GROUPNAME
, TESTCLASSNAME ) P
Columns
Name |
SNAPSHOT_ID |
BUG_NO |
APPNAME |
GROUPNAME |
TESTCLASSNAME |
PATCH_CNT |
TOT_CNT |
PATCH_ID |