[Home] [Help] [Dependency Information]
Object Name: | AD_PATCH_RUNS# |
---|---|
Object Type: | VIEW |
Owner: | APPLSYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PATCH_RUN_ID | NUMBER | Yes | ||
RELEASE_ID | NUMBER | Yes | ||
SESSION_ID | NUMBER | Yes | ||
RAPID_INSTALL_FLAG | VARCHAR2 | (1) | ||
UPDATED_TO_RELEASE_ID | NUMBER | |||
PATCH_TOP | VARCHAR2 | (250) | Yes | |
START_DATE | DATE | Yes | ||
END_DATE | DATE | |||
PATCH_DRIVER_ID | NUMBER | Yes | ||
PATCH_ACTION_OPTIONS | VARCHAR2 | (250) | ||
APPS_SYSTEM_NAME | VARCHAR2 | (8) | ||
APPL_TOP_ID | NUMBER | Yes | ||
SERVER_TYPE_ADMIN_FLAG | VARCHAR2 | (1) | ||
SERVER_TYPE_FORMS_FLAG | VARCHAR2 | (1) | ||
SERVER_TYPE_NODE_FLAG | VARCHAR2 | (1) | ||
SERVER_TYPE_WEB_FLAG | VARCHAR2 | (1) | ||
SOURCE_CODE | VARCHAR2 | (3) | Yes | |
CREATION_DATE | DATE | Yes | ||
SUCCESS_FLAG | VARCHAR2 | (1) | Yes | |
FAILURE_COMMENTS | VARCHAR2 | (255) | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
IMPORTED_FLAG | VARCHAR2 | (1) | ||
IMPORTED_FROM_DB | VARCHAR2 | (30) | ||
IMPORTED_ID | NUMBER | |||
IMPORT_SESSION_ID | NUMBER | |||
TASK_NUMBER | NUMBER | |||
PROGRAM_RUN_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PATCH_RUN_ID
, RELEASE_ID
, SESSION_ID
, RAPID_INSTALL_FLAG
, UPDATED_TO_RELEASE_ID
, PATCH_TOP
, START_DATE
, END_DATE
, PATCH_DRIVER_ID
, PATCH_ACTION_OPTIONS
, APPS_SYSTEM_NAME
, APPL_TOP_ID
, SERVER_TYPE_ADMIN_FLAG
, SERVER_TYPE_FORMS_FLAG
, SERVER_TYPE_NODE_FLAG
, SERVER_TYPE_WEB_FLAG
, SOURCE_CODE
, CREATION_DATE
, SUCCESS_FLAG
, FAILURE_COMMENTS
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, IMPORTED_FLAG
, IMPORTED_FROM_DB
, IMPORTED_ID
, IMPORT_SESSION_ID
, TASK_NUMBER
, PROGRAM_RUN_ID
FROM APPLSYS.AD_PATCH_RUNS#;
|
|
|