eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: JTF_IMP_PSNEW_VL

Product:	JTF - CRM Foundation
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PATCH_FILES.BUG_NO
, SNAP_IDS.SNAPSHOT_ID SNAPSHOT_ID
, PATCH_FILES.APP_SHORT_NAME
, PATCH_FILES.DIRECTORY DIRECTORY
, PATCH_FILES.FILENAME FILENAME
, PATCH_FILES.VERSION NEW_VERSION FROM JTF_IMP_PFILEINFO2 PATCH_FILES
, (SELECT DISTINCT SNAPSHOT_ID
FROM AD_SNAPSHOTS) SNAP_IDS
WHERE (PATCH_FILES.APP_SHORT_NAME
, PATCH_FILES.DIRECTORY
, PATCH_FILES.FILENAME) NOT IN (SELECT SNAP_FILES.APP_SHORT_NAME
, SNAP_FILES.DIRECTORY
, SNAP_FILES.FILENAME FROM JTF_IMP_SFILEINFO_VL SNAP_FILES WHERE SNAP_FILES.SNAPSHOT_ID = SNAP_IDS.SNAPSHOT_ID)

Columns

Name
BUG_NO
SNAPSHOT_ID
APP_SHORT_NAME
DIRECTORY
FILENAME
NEW_VERSION