DBA Data[Home] [Help] [Dependency Information]

VIEW: APPLSYS.AD_PATCH_RUNS#

Object Details
Object Name: AD_PATCH_RUNS#
Object Type: VIEW
Owner: APPLSYS
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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

Dependencies

[top of page]

APPLSYS.AD_PATCH_RUNS# references the following:

SchemaAPPLSYS
TableAD_PATCH_RUNS
APPLSYS.AD_PATCH_RUNS# is referenced by following:

SchemaAPPS
SynonymAD_PATCH_RUNS