DBA Data[Home] [Help]

VIEW: APPS.FND_IMP_DIAGDETMAP_VL

Source

View Text - Preformatted

SELECT master.snapshot_id, master.bug_no, map.appName, map.groupName, map.testClassName, map.className, master.patch_id from fnd_imp_psmaster2 master, jtf_diagnostic_cmap map where master.file_type = 'class' and map.classname = master.trans_name
View Text - HTML Formatted

SELECT MASTER.SNAPSHOT_ID
, MASTER.BUG_NO
, MAP.APPNAME
, MAP.GROUPNAME
, MAP.TESTCLASSNAME
, MAP.CLASSNAME
, MASTER.PATCH_ID
FROM FND_IMP_PSMASTER2 MASTER
, JTF_DIAGNOSTIC_CMAP MAP
WHERE MASTER.FILE_TYPE = 'CLASS'
AND MAP.CLASSNAME = MASTER.TRANS_NAME