VIEW: APPLSYS.AD_PATCH_HIST_TEMP#

Source

View Text - Preformatted

select PATCH_RUN_ID PATCH_RUN_ID, BUG_NUMBER BUG_NUMBER, ARU_RELEASE_NAME ARU_RELEASE_NAME, ORIG_BUG_NUMBER ORIG_BUG_NUMBER, APPLIED_FLAG APPLIED_FLAG, REASON_NOT_APPLIED REASON_NOT_APPLIED, BUG_APP_SHORT_NAME BUG_APP_SHORT_NAME, SUCCESS_FLAG SUCCESS_FLAG, BUG_ID BUG_ID, PATCH_RUN_BUG_ID PATCH_RUN_BUG_ID, FILENAME FILENAME, FILE_ID FILE_ID, FILE_SUBDIR FILE_SUBDIR, FILE_APPS_SHORT_NAME FILE_APPS_SHORT_NAME, PATCH_FILE_VERS_ID PATCH_FILE_VERS_ID, PATCH_VERSION_SEGMENT1 PATCH_VERSION_SEGMENT1, PATCH_VERSION_SEGMENT2 PATCH_VERSION_SEGMENT2, PATCH_VERSION_SEGMENT3 PATCH_VERSION_SEGMENT3, PATCH_VERSION_SEGMENT4 PATCH_VERSION_SEGMENT4, PATCH_VERSION_SEGMENT5 PATCH_VERSION_SEGMENT5, PATCH_VERSION_SEGMENT6 PATCH_VERSION_SEGMENT6, PATCH_VERSION_SEGMENT7 PATCH_VERSION_SEGMENT7, PATCH_VERSION_SEGMENT8 PATCH_VERSION_SEGMENT8, PATCH_VERSION_SEGMENT9 PATCH_VERSION_SEGMENT9, PATCH_VERSION_SEGMENT10 PATCH_VERSION_SEGMENT10, ONSITE_FILE_VERS_ID ONSITE_FILE_VERS_ID, ONSITE_VERSION_SEGMENT1 ONSITE_VERSION_SEGMENT1, ONSITE_VERSION_SEGMENT2 ONSITE_VERSION_SEGMENT2, ONSITE_VERSION_SEGMENT3 ONSITE_VERSION_SEGMENT3, ONSITE_VERSION_SEGMENT4 ONSITE_VERSION_SEGMENT4, ONSITE_VERSION_SEGMENT5 ONSITE_VERSION_SEGMENT5, ONSITE_VERSION_SEGMENT6 ONSITE_VERSION_SEGMENT6, ONSITE_VERSION_SEGMENT7 ONSITE_VERSION_SEGMENT7, ONSITE_VERSION_SEGMENT8 ONSITE_VERSION_SEGMENT8, ONSITE_VERSION_SEGMENT9 ONSITE_VERSION_SEGMENT9, ONSITE_VERSION_SEGMENT10 ONSITE_VERSION_SEGMENT10, DB_FILE_VERS_ID DB_FILE_VERS_ID, DB_VERSION_SEGMENT1 DB_VERSION_SEGMENT1, DB_VERSION_SEGMENT2 DB_VERSION_SEGMENT2, DB_VERSION_SEGMENT3 DB_VERSION_SEGMENT3, DB_VERSION_SEGMENT4 DB_VERSION_SEGMENT4, DB_VERSION_SEGMENT5 DB_VERSION_SEGMENT5, DB_VERSION_SEGMENT6 DB_VERSION_SEGMENT6, DB_VERSION_SEGMENT7 DB_VERSION_SEGMENT7, DB_VERSION_SEGMENT8 DB_VERSION_SEGMENT8, DB_VERSION_SEGMENT9 DB_VERSION_SEGMENT9, DB_VERSION_SEGMENT10 DB_VERSION_SEGMENT10, PATCH_FILE_VERS PATCH_FILE_VERS, ONSITE_FILE_VERS ONSITE_FILE_VERS, DB_FILE_VERS DB_FILE_VERS, PATCH_TRANS_LEVEL PATCH_TRANS_LEVEL, ONSITE_TRANS_LEVEL ONSITE_TRANS_LEVEL, DB_TRANS_LEVEL DB_TRANS_LEVEL, COMMON_ACTION_ID COMMON_ACTION_ID, ACTION_CODE ACTION_CODE, ACTION_PHASE ACTION_PHASE, ACTION_ARGUMENTS ACTION_ARGUMENTS, CHECKFILE_ARGS CHECKFILE_ARGS, CHECKOBJ CHECKOBJ, CHECKOBJ_UN CHECKOBJ_UN, CHECKOBJ_PW CHECKOBJ_PW, ACTION_MODIFIER ACTION_MODIFIER, ACTION_TIERLIST ACTION_TIERLIST, ACTION_LANG_CODE ACTION_LANG_CODE, ACTION_EXECUTED_FLAG ACTION_EXECUTED_FLAG, CONCAT_ATTRIBS CONCAT_ATTRIBS, MAJOR_PHASE MAJOR_PHASE, MINOR_PHASE MINOR_PHASE, LOADER_DATA_FILE_ID LOADER_DATA_FILE_ID, LDR_FILENAME LDR_FILENAME, LDR_SUBDIR LDR_SUBDIR, LDR_APP_SHORT_NAME LDR_APP_SHORT_NAME, DEST_APPS_SHORT_NAME DEST_APPS_SHORT_NAME, DEST_FILE_ID DEST_FILE_ID, DEST_SUBDIR DEST_SUBDIR, DEST_FILENAME DEST_FILENAME, FILE_TYPE_FLAG FILE_TYPE_FLAG, GENERIC_PATCH GENERIC_PATCH, BASELINE_NAME BASELINE_NAME, TRACKABLE_ENTITY_NAME TRACKABLE_ENTITY_NAME, LANGUAGE LANGUAGE from "APPLSYS"."AD_PATCH_HIST_TEMP"

View Text - HTML Formatted

SELECT PATCH_RUN_ID PATCH_RUN_ID
, BUG_NUMBER BUG_NUMBER
, ARU_RELEASE_NAME ARU_RELEASE_NAME
, ORIG_BUG_NUMBER ORIG_BUG_NUMBER
, APPLIED_FLAG APPLIED_FLAG
, REASON_NOT_APPLIED REASON_NOT_APPLIED
, BUG_APP_SHORT_NAME BUG_APP_SHORT_NAME
, SUCCESS_FLAG SUCCESS_FLAG
, BUG_ID BUG_ID
, PATCH_RUN_BUG_ID PATCH_RUN_BUG_ID
, FILENAME FILENAME
, FILE_ID FILE_ID
, FILE_SUBDIR FILE_SUBDIR
, FILE_APPS_SHORT_NAME FILE_APPS_SHORT_NAME
, PATCH_FILE_VERS_ID PATCH_FILE_VERS_ID
, PATCH_VERSION_SEGMENT1 PATCH_VERSION_SEGMENT1
, PATCH_VERSION_SEGMENT2 PATCH_VERSION_SEGMENT2
, PATCH_VERSION_SEGMENT3 PATCH_VERSION_SEGMENT3
, PATCH_VERSION_SEGMENT4 PATCH_VERSION_SEGMENT4
, PATCH_VERSION_SEGMENT5 PATCH_VERSION_SEGMENT5
, PATCH_VERSION_SEGMENT6 PATCH_VERSION_SEGMENT6
, PATCH_VERSION_SEGMENT7 PATCH_VERSION_SEGMENT7
, PATCH_VERSION_SEGMENT8 PATCH_VERSION_SEGMENT8
, PATCH_VERSION_SEGMENT9 PATCH_VERSION_SEGMENT9
, PATCH_VERSION_SEGMENT10 PATCH_VERSION_SEGMENT10
, ONSITE_FILE_VERS_ID ONSITE_FILE_VERS_ID
, ONSITE_VERSION_SEGMENT1 ONSITE_VERSION_SEGMENT1
, ONSITE_VERSION_SEGMENT2 ONSITE_VERSION_SEGMENT2
, ONSITE_VERSION_SEGMENT3 ONSITE_VERSION_SEGMENT3
, ONSITE_VERSION_SEGMENT4 ONSITE_VERSION_SEGMENT4
, ONSITE_VERSION_SEGMENT5 ONSITE_VERSION_SEGMENT5
, ONSITE_VERSION_SEGMENT6 ONSITE_VERSION_SEGMENT6
, ONSITE_VERSION_SEGMENT7 ONSITE_VERSION_SEGMENT7
, ONSITE_VERSION_SEGMENT8 ONSITE_VERSION_SEGMENT8
, ONSITE_VERSION_SEGMENT9 ONSITE_VERSION_SEGMENT9
, ONSITE_VERSION_SEGMENT10 ONSITE_VERSION_SEGMENT10
, DB_FILE_VERS_ID DB_FILE_VERS_ID
, DB_VERSION_SEGMENT1 DB_VERSION_SEGMENT1
, DB_VERSION_SEGMENT2 DB_VERSION_SEGMENT2
, DB_VERSION_SEGMENT3 DB_VERSION_SEGMENT3
, DB_VERSION_SEGMENT4 DB_VERSION_SEGMENT4
, DB_VERSION_SEGMENT5 DB_VERSION_SEGMENT5
, DB_VERSION_SEGMENT6 DB_VERSION_SEGMENT6
, DB_VERSION_SEGMENT7 DB_VERSION_SEGMENT7
, DB_VERSION_SEGMENT8 DB_VERSION_SEGMENT8
, DB_VERSION_SEGMENT9 DB_VERSION_SEGMENT9
, DB_VERSION_SEGMENT10 DB_VERSION_SEGMENT10
, PATCH_FILE_VERS PATCH_FILE_VERS
, ONSITE_FILE_VERS ONSITE_FILE_VERS
, DB_FILE_VERS DB_FILE_VERS
, PATCH_TRANS_LEVEL PATCH_TRANS_LEVEL
, ONSITE_TRANS_LEVEL ONSITE_TRANS_LEVEL
, DB_TRANS_LEVEL DB_TRANS_LEVEL
, COMMON_ACTION_ID COMMON_ACTION_ID
, ACTION_CODE ACTION_CODE
, ACTION_PHASE ACTION_PHASE
, ACTION_ARGUMENTS ACTION_ARGUMENTS
, CHECKFILE_ARGS CHECKFILE_ARGS
, CHECKOBJ CHECKOBJ
, CHECKOBJ_UN CHECKOBJ_UN
, CHECKOBJ_PW CHECKOBJ_PW
, ACTION_MODIFIER ACTION_MODIFIER
, ACTION_TIERLIST ACTION_TIERLIST
, ACTION_LANG_CODE ACTION_LANG_CODE
, ACTION_EXECUTED_FLAG ACTION_EXECUTED_FLAG
, CONCAT_ATTRIBS CONCAT_ATTRIBS
, MAJOR_PHASE MAJOR_PHASE
, MINOR_PHASE MINOR_PHASE
, LOADER_DATA_FILE_ID LOADER_DATA_FILE_ID
, LDR_FILENAME LDR_FILENAME
, LDR_SUBDIR LDR_SUBDIR
, LDR_APP_SHORT_NAME LDR_APP_SHORT_NAME
, DEST_APPS_SHORT_NAME DEST_APPS_SHORT_NAME
, DEST_FILE_ID DEST_FILE_ID
, DEST_SUBDIR DEST_SUBDIR
, DEST_FILENAME DEST_FILENAME
, FILE_TYPE_FLAG FILE_TYPE_FLAG
, GENERIC_PATCH GENERIC_PATCH
, BASELINE_NAME BASELINE_NAME
, TRACKABLE_ENTITY_NAME TRACKABLE_ENTITY_NAME
, LANGUAGE LANGUAGE
FROM "APPLSYS"."AD_PATCH_HIST_TEMP"