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_AFFECTEDFILES_VL

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

View Text

SELECT A.BUG_NO
, S.SNAPSHOT_ID
, S.APP_SHORT_NAME DEP_APP_SHORT_NAME
, S.DIRECTORY DEP_DIRECTORY
, S.FILENAME DEP_FILENAME
, A.APP_SHORT_NAME PATCHED_APP_SHORT_NAME
, A.DIRECTORY PATCHED_DIRECTORY
, A.FILENAME PATCHED_FILENAME
, A.TYPEID
, 'RECOMPILE' ACTION_REQUIRED
FROM JTF_IMP_PSMASTER2 A
, JTF_IMP_SFILEDEP S
FROM JTF_IMP_PSMASTER2 A
, JTF_IMP_SFILEDEP S
WHERE A.SNAPSHOT_ID = S.SNAPSHOT_ID
AND S.DEP_FILENAME = A.FILENAME
AND S.DEP_DIRECTORY = A.DIRECTORY
AND S.DEP_APP_SHORT_NAME = A.APP_SHORT_NAME
AND A.TYPEID IN ('NEW'
, 'UPGRADE'
, 'OVERWRITE')

Columns

Name
BUG_NO
SNAPSHOT_ID
DEP_APP_SHORT_NAME
DEP_DIRECTORY
DEP_FILENAME
PATCHED_APP_SHORT_NAME
PATCHED_DIRECTORY
PATCHED_FILENAME
TYPEID
ACTION_REQUIRED