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