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_PM_PATCHES#

Source

View Text - Preformatted


select PATCH_METADATA_KEY PATCH_METADATA_KEY, BUG_NUMBER BUG_NUMBER, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, ARU_UPDATE_DATE ARU_UPDATE_DATE, PRODUCT_ABBREVIATION PRODUCT_ABBREVIATION, PATCH_NAME PATCH_NAME, UPLOAD_RUN_ID UPLOAD_RUN_ID, BUG_DESCRIPTION BUG_DESCRIPTION, IS_FAMILY_PACK IS_FAMILY_PACK, IS_MINI_PACK IS_MINI_PACK, IS_HIGH_PRIORITY IS_HIGH_PRIORITY, IS_MAINT_PACK IS_MAINT_PACK, IN_REFERENCE_FAMILY_PACK IN_REFERENCE_FAMILY_PACK, REFERENCE_FAMILY_PACK REFERENCE_FAMILY_PACK, IN_REFERENCE_MINI_PACK IN_REFERENCE_MINI_PACK, REFERENCE_MINI_PACK REFERENCE_MINI_PACK, IN_REFERENCE_MAINT_PACK IN_REFERENCE_MAINT_PACK, REFERENCE_MAINT_PACK REFERENCE_MAINT_PACK, INFOBUNDLE_UPLOAD_DATE INFOBUNDLE_UPLOAD_DATE, README_FILE_ID README_FILE_ID, README_UPDATE_DATE README_UPDATE_DATE, PRODUCT_FAMILY_ABBREVIATION PRODUCT_FAMILY_ABBREVIATION, IS_CODE_LEVEL IS_CODE_LEVEL, ENTITY_ABBR ENTITY_ABBR, BASELINE BASELINE, PATCH_ID PATCH_ID, HAS_MSI_STEPS HAS_MSI_STEPS, PATCH_TYPE PATCH_TYPE from "APPLSYS"."AD_PM_PATCHES"

View Text - HTML Formatted

SELECT PATCH_METADATA_KEY PATCH_METADATA_KEY
, BUG_NUMBER BUG_NUMBER
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, ARU_UPDATE_DATE ARU_UPDATE_DATE
, PRODUCT_ABBREVIATION PRODUCT_ABBREVIATION
, PATCH_NAME PATCH_NAME
, UPLOAD_RUN_ID UPLOAD_RUN_ID
, BUG_DESCRIPTION BUG_DESCRIPTION
, IS_FAMILY_PACK IS_FAMILY_PACK
, IS_MINI_PACK IS_MINI_PACK
, IS_HIGH_PRIORITY IS_HIGH_PRIORITY
, IS_MAINT_PACK IS_MAINT_PACK
, IN_REFERENCE_FAMILY_PACK IN_REFERENCE_FAMILY_PACK
, REFERENCE_FAMILY_PACK REFERENCE_FAMILY_PACK
, IN_REFERENCE_MINI_PACK IN_REFERENCE_MINI_PACK
, REFERENCE_MINI_PACK REFERENCE_MINI_PACK
, IN_REFERENCE_MAINT_PACK IN_REFERENCE_MAINT_PACK
, REFERENCE_MAINT_PACK REFERENCE_MAINT_PACK
, INFOBUNDLE_UPLOAD_DATE INFOBUNDLE_UPLOAD_DATE
, README_FILE_ID README_FILE_ID
, README_UPDATE_DATE README_UPDATE_DATE
, PRODUCT_FAMILY_ABBREVIATION PRODUCT_FAMILY_ABBREVIATION
, IS_CODE_LEVEL IS_CODE_LEVEL
, ENTITY_ABBR ENTITY_ABBR
, BASELINE BASELINE
, PATCH_ID PATCH_ID
, HAS_MSI_STEPS HAS_MSI_STEPS
, PATCH_TYPE PATCH_TYPE
FROM "APPLSYS"."AD_PM_PATCHES"