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.

VIEW: APPLSYS.AD_PATCH_HIST_SNAPS_TEMP#

Source

View Text - Preformatted


select PATCH_RUN_ID PATCH_RUN_ID, BUG_ID BUG_ID, ACTION_CODE ACTION_CODE, FILE_ID FILE_ID, APP_SHORT_NAME APP_SHORT_NAME, FILENAME FILENAME, FILE_VERSION_ID FILE_VERSION_ID, VERSION_SEGMENT1 VERSION_SEGMENT1, VERSION_SEGMENT2 VERSION_SEGMENT2, VERSION_SEGMENT3 VERSION_SEGMENT3, VERSION_SEGMENT4 VERSION_SEGMENT4, VERSION_SEGMENT5 VERSION_SEGMENT5, VERSION_SEGMENT6 VERSION_SEGMENT6, VERSION_SEGMENT7 VERSION_SEGMENT7, VERSION_SEGMENT8 VERSION_SEGMENT8, VERSION_SEGMENT9 VERSION_SEGMENT9, VERSION_SEGMENT10 VERSION_SEGMENT10, TRANSLATION_LEVEL TRANSLATION_LEVEL, CLIB_ARCH_FILE_ID CLIB_ARCH_FILE_ID, DEST_FILE_ID DEST_FILE_ID, FILE_TYPE_FLAG FILE_TYPE_FLAG, IREP_GATHERED_FLAG IREP_GATHERED_FLAG from "APPLSYS"."AD_PATCH_HIST_SNAPS_TEMP"

View Text - HTML Formatted

SELECT PATCH_RUN_ID PATCH_RUN_ID
, BUG_ID BUG_ID
, ACTION_CODE ACTION_CODE
, FILE_ID FILE_ID
, APP_SHORT_NAME APP_SHORT_NAME
, FILENAME FILENAME
, FILE_VERSION_ID FILE_VERSION_ID
, VERSION_SEGMENT1 VERSION_SEGMENT1
, VERSION_SEGMENT2 VERSION_SEGMENT2
, VERSION_SEGMENT3 VERSION_SEGMENT3
, VERSION_SEGMENT4 VERSION_SEGMENT4
, VERSION_SEGMENT5 VERSION_SEGMENT5
, VERSION_SEGMENT6 VERSION_SEGMENT6
, VERSION_SEGMENT7 VERSION_SEGMENT7
, VERSION_SEGMENT8 VERSION_SEGMENT8
, VERSION_SEGMENT9 VERSION_SEGMENT9
, VERSION_SEGMENT10 VERSION_SEGMENT10
, TRANSLATION_LEVEL TRANSLATION_LEVEL
, CLIB_ARCH_FILE_ID CLIB_ARCH_FILE_ID
, DEST_FILE_ID DEST_FILE_ID
, FILE_TYPE_FLAG FILE_TYPE_FLAG
, IREP_GATHERED_FLAG IREP_GATHERED_FLAG
FROM "APPLSYS"."AD_PATCH_HIST_SNAPS_TEMP"