VIEW: APPS.FND_IMP_DIAGMAP_VL

Source

View Text - Preformatted

SELECT p."SNAPSHOT_ID",p."BUG_NO",p."APPNAME",p."GROUPNAME",p."TESTCLASSNAME",p."PATCH_CNT",p."PATCH_ID", (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

View Text - HTML Formatted

SELECT P."SNAPSHOT_ID"
, P."BUG_NO"
, P."APPNAME"
, P."GROUPNAME"
, P."TESTCLASSNAME"
, P."PATCH_CNT"
, P."PATCH_ID"
, (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