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.

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

VIEW: APPLSYS.AD_PATCH_HIST_TEMP#

Object Details

Object Name:	AD_PATCH_HIST_TEMP#
Object Type:	VIEW
Owner:	APPLSYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
PATCH_RUN_ID	NUMBER
BUG_NUMBER	VARCHAR2	(30)
ARU_RELEASE_NAME	VARCHAR2	(30)
ORIG_BUG_NUMBER	VARCHAR2	(30)
APPLIED_FLAG	VARCHAR2	(1)
REASON_NOT_APPLIED	VARCHAR2	(250)
BUG_APP_SHORT_NAME	VARCHAR2	(50)
SUCCESS_FLAG	VARCHAR2	(1)
BUG_ID	NUMBER
PATCH_RUN_BUG_ID	NUMBER
FILENAME	VARCHAR2	(250)
FILE_ID	NUMBER
FILE_SUBDIR	VARCHAR2	(256)
FILE_APPS_SHORT_NAME	VARCHAR2	(50)
PATCH_FILE_VERS_ID	NUMBER
PATCH_VERSION_SEGMENT1	NUMBER
PATCH_VERSION_SEGMENT2	NUMBER
PATCH_VERSION_SEGMENT3	NUMBER
PATCH_VERSION_SEGMENT4	NUMBER
PATCH_VERSION_SEGMENT5	NUMBER
PATCH_VERSION_SEGMENT6	NUMBER
PATCH_VERSION_SEGMENT7	NUMBER
PATCH_VERSION_SEGMENT8	NUMBER
PATCH_VERSION_SEGMENT9	NUMBER
PATCH_VERSION_SEGMENT10	NUMBER
ONSITE_FILE_VERS_ID	NUMBER
ONSITE_VERSION_SEGMENT1	NUMBER
ONSITE_VERSION_SEGMENT2	NUMBER
ONSITE_VERSION_SEGMENT3	NUMBER
ONSITE_VERSION_SEGMENT4	NUMBER
ONSITE_VERSION_SEGMENT5	NUMBER
ONSITE_VERSION_SEGMENT6	NUMBER
ONSITE_VERSION_SEGMENT7	NUMBER
ONSITE_VERSION_SEGMENT8	NUMBER
ONSITE_VERSION_SEGMENT9	NUMBER
ONSITE_VERSION_SEGMENT10	NUMBER
DB_FILE_VERS_ID	NUMBER
DB_VERSION_SEGMENT1	NUMBER
DB_VERSION_SEGMENT2	NUMBER
DB_VERSION_SEGMENT3	NUMBER
DB_VERSION_SEGMENT4	NUMBER
DB_VERSION_SEGMENT5	NUMBER
DB_VERSION_SEGMENT6	NUMBER
DB_VERSION_SEGMENT7	NUMBER
DB_VERSION_SEGMENT8	NUMBER
DB_VERSION_SEGMENT9	NUMBER
DB_VERSION_SEGMENT10	NUMBER
PATCH_FILE_VERS	VARCHAR2	(150)
ONSITE_FILE_VERS	VARCHAR2	(150)
DB_FILE_VERS	VARCHAR2	(150)
PATCH_TRANS_LEVEL	NUMBER
ONSITE_TRANS_LEVEL	NUMBER
DB_TRANS_LEVEL	NUMBER
COMMON_ACTION_ID	NUMBER
ACTION_CODE	VARCHAR2	(30)
ACTION_PHASE	VARCHAR2	(10)
ACTION_ARGUMENTS	VARCHAR2	(2000)
CHECKFILE_ARGS	VARCHAR2	(255)
CHECKOBJ	VARCHAR2	(255)
CHECKOBJ_UN	VARCHAR2	(30)
CHECKOBJ_PW	VARCHAR2	(30)
ACTION_MODIFIER	VARCHAR2	(30)
ACTION_TIERLIST	VARCHAR2	(50)
ACTION_LANG_CODE	VARCHAR2	(4)
ACTION_EXECUTED_FLAG	VARCHAR2	(1)
CONCAT_ATTRIBS	VARCHAR2	(3000)
MAJOR_PHASE	NUMBER
MINOR_PHASE	NUMBER
LOADER_DATA_FILE_ID	NUMBER
LDR_FILENAME	VARCHAR2	(250)
LDR_SUBDIR	VARCHAR2	(256)
LDR_APP_SHORT_NAME	VARCHAR2	(50)
DEST_APPS_SHORT_NAME	VARCHAR2	(50)
DEST_FILE_ID	NUMBER
DEST_SUBDIR	VARCHAR2	(256)
DEST_FILENAME	VARCHAR2	(250)
FILE_TYPE_FLAG	VARCHAR2	(1)
GENERIC_PATCH	VARCHAR2	(1)
BASELINE_NAME	VARCHAR2	(150)
TRACKABLE_ENTITY_NAME	VARCHAR2	(50)
LANGUAGE	VARCHAR2	(4)

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

APPLSYS.AD_PATCH_HIST_TEMP# references the following:

APPLSYS: AD_PATCH_HIST_TEMP

APPLSYS.AD_PATCH_HIST_TEMP# is referenced by following:

APPS: AD_PATCH_HIST_TEMP