VIEW: APPLSYS.AD_PATCH_RUNS#

Source

View Text - Preformatted

select PATCH_RUN_ID PATCH_RUN_ID, RELEASE_ID RELEASE_ID, SESSION_ID SESSION_ID, RAPID_INSTALL_FLAG RAPID_INSTALL_FLAG, UPDATED_TO_RELEASE_ID UPDATED_TO_RELEASE_ID, PATCH_TOP PATCH_TOP, START_DATE START_DATE, END_DATE END_DATE, PATCH_DRIVER_ID PATCH_DRIVER_ID, PATCH_ACTION_OPTIONS PATCH_ACTION_OPTIONS, APPS_SYSTEM_NAME APPS_SYSTEM_NAME, APPL_TOP_ID APPL_TOP_ID, SERVER_TYPE_ADMIN_FLAG SERVER_TYPE_ADMIN_FLAG, SERVER_TYPE_FORMS_FLAG SERVER_TYPE_FORMS_FLAG, SERVER_TYPE_NODE_FLAG SERVER_TYPE_NODE_FLAG, SERVER_TYPE_WEB_FLAG SERVER_TYPE_WEB_FLAG, SOURCE_CODE SOURCE_CODE, CREATION_DATE CREATION_DATE, SUCCESS_FLAG SUCCESS_FLAG, FAILURE_COMMENTS FAILURE_COMMENTS, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, IMPORTED_FLAG IMPORTED_FLAG, IMPORTED_FROM_DB IMPORTED_FROM_DB, IMPORTED_ID IMPORTED_ID, IMPORT_SESSION_ID IMPORT_SESSION_ID, TASK_NUMBER TASK_NUMBER, PROGRAM_RUN_ID PROGRAM_RUN_ID from "APPLSYS"."AD_PATCH_RUNS"

View Text - HTML Formatted

SELECT PATCH_RUN_ID PATCH_RUN_ID
, RELEASE_ID RELEASE_ID
, SESSION_ID SESSION_ID
, RAPID_INSTALL_FLAG RAPID_INSTALL_FLAG
, UPDATED_TO_RELEASE_ID UPDATED_TO_RELEASE_ID
, PATCH_TOP PATCH_TOP
, START_DATE START_DATE
, END_DATE END_DATE
, PATCH_DRIVER_ID PATCH_DRIVER_ID
, PATCH_ACTION_OPTIONS PATCH_ACTION_OPTIONS
, APPS_SYSTEM_NAME APPS_SYSTEM_NAME
, APPL_TOP_ID APPL_TOP_ID
, SERVER_TYPE_ADMIN_FLAG SERVER_TYPE_ADMIN_FLAG
, SERVER_TYPE_FORMS_FLAG SERVER_TYPE_FORMS_FLAG
, SERVER_TYPE_NODE_FLAG SERVER_TYPE_NODE_FLAG
, SERVER_TYPE_WEB_FLAG SERVER_TYPE_WEB_FLAG
, SOURCE_CODE SOURCE_CODE
, CREATION_DATE CREATION_DATE
, SUCCESS_FLAG SUCCESS_FLAG
, FAILURE_COMMENTS FAILURE_COMMENTS
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, IMPORTED_FLAG IMPORTED_FLAG
, IMPORTED_FROM_DB IMPORTED_FROM_DB
, IMPORTED_ID IMPORTED_ID
, IMPORT_SESSION_ID IMPORT_SESSION_ID
, TASK_NUMBER TASK_NUMBER
, PROGRAM_RUN_ID PROGRAM_RUN_ID
FROM "APPLSYS"."AD_PATCH_RUNS"