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]

TABLE: APPLSYS.AD_PATCH_HIST_TEMP

Object Details

Object Name:	AD_PATCH_HIST_TEMP
Object Type:	TABLE
Owner:	APPLSYS
Subobject Name:
Status:	VALID

AD_PATCH_HIST_TEMP is a temporary staging table for recording information in the patch-history tables. It is used internally by Autopatch.
.
Autopatch populates this table and then calls the PL/SQL package AD_FILE_UTIL.Load_Patch_Hist_Action.
.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AD_PATCH_HIST_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	LOADER_DATA_FILE_ID

Columns

Name	Datatype	Length	Comments
PATCH_RUN_ID	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
BUG_NUMBER	VARCHAR2	(30)	Temporary staging area for column values meant to be stored in AD patch history tables
ARU_RELEASE_NAME	VARCHAR2	(30)	Temporary staging area for column values meant to be stored in AD patch history tables
ORIG_BUG_NUMBER	VARCHAR2	(30)	Temporary staging area for column values meant to be stored in AD patch history tables
APPLIED_FLAG	VARCHAR2	(1)	Temporary staging area for column values meant to be stored in AD patch history tables
REASON_NOT_APPLIED	VARCHAR2	(250)	Temporary staging area for column values meant to be stored in AD patch history tables
BUG_APP_SHORT_NAME	VARCHAR2	(50)	Temporary staging area for column values meant to be stored in AD patch history tables
SUCCESS_FLAG	VARCHAR2	(1)	Temporary staging area for column values meant to be stored in AD patch history tables
BUG_ID	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_RUN_BUG_ID	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
FILENAME	VARCHAR2	(250)	Temporary staging area for column values meant to be stored in AD patch history tables
FILE_ID	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
FILE_SUBDIR	VARCHAR2	(256)	Temporary staging area for column values meant to be stored in AD patch history tables
FILE_APPS_SHORT_NAME	VARCHAR2	(50)	Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_FILE_VERS_ID	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT1	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT2	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT3	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT4	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT5	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT6	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT7	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT8	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT9	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_VERSION_SEGMENT10	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_FILE_VERS_ID	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT1	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT2	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT3	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT4	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT5	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT6	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT7	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT8	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT9	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_VERSION_SEGMENT10	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
DB_FILE_VERS_ID	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT1	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT2	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT3	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT4	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT5	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT6	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT7	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT8	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT9	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
DB_VERSION_SEGMENT10	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_FILE_VERS	VARCHAR2	(150)	Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_FILE_VERS	VARCHAR2	(150)	Temporary staging area for column values meant to be stored in AD patch history tables
DB_FILE_VERS	VARCHAR2	(150)	Temporary staging area for column values meant to be stored in AD patch history tables
PATCH_TRANS_LEVEL	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
ONSITE_TRANS_LEVEL	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
DB_TRANS_LEVEL	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
COMMON_ACTION_ID	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
ACTION_CODE	VARCHAR2	(30)	Temporary staging area for column values meant to be stored in AD patch history tables
ACTION_PHASE	VARCHAR2	(10)	Temporary staging area for column values meant to be stored in AD patch history tables
ACTION_ARGUMENTS	VARCHAR2	(2000)	Temporary staging area for column values meant to be stored in AD patch history tables
CHECKFILE_ARGS	VARCHAR2	(255)	Temporary staging area for column values meant to be stored in AD patch history tables
CHECKOBJ	VARCHAR2	(255)	Temporary staging area for column values meant to be stored in AD patch history tables
CHECKOBJ_UN	VARCHAR2	(30)	Temporary staging area for column values meant to be stored in AD patch history tables
CHECKOBJ_PW	VARCHAR2	(30)	Temporary staging area for column values meant to be stored in AD patch history tables
ACTION_MODIFIER	VARCHAR2	(30)	Temporary staging area for column values meant to be stored in AD patch history tables
ACTION_TIERLIST	VARCHAR2	(50)	Temporary staging area for column values meant to be stored in AD patch history tables
ACTION_LANG_CODE	VARCHAR2	(4)	Temporary staging area for column values meant to be stored in AD patch history tables
ACTION_EXECUTED_FLAG	VARCHAR2	(1)	Temporary staging area for column values meant to be stored in AD patch history tables
CONCAT_ATTRIBS	VARCHAR2	(3000)	Temporary staging area for column values meant to be stored in AD patch history tables
MAJOR_PHASE	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
MINOR_PHASE	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
LOADER_DATA_FILE_ID	NUMBER		Temporary staging area for column values meant to be stored in AD patch history tables
LDR_FILENAME	VARCHAR2	(250)	Temporary staging area for column values meant to be stored in AD patch history tables
LDR_SUBDIR	VARCHAR2	(256)	Temporary staging area for column values meant to be stored in AD patch history tables
LDR_APP_SHORT_NAME	VARCHAR2	(50)	Temporary staging area for column values meant to be stored in AD patch history tables
DEST_APPS_SHORT_NAME	VARCHAR2	(50)	Applications Short Name of file at destination
DEST_FILE_ID	NUMBER		File _id of file at destination
DEST_SUBDIR	VARCHAR2	(256)	Subdirectory of file copy destination
DEST_FILENAME	VARCHAR2	(250)	Filename at copy destination
FILE_TYPE_FLAG	VARCHAR2	(1)	Mirror or Nomirror file
GENERIC_PATCH	VARCHAR2	(1)	Flag to indentify generic patches
BASELINE_NAME	VARCHAR2	(150)	Holds the baseline name of the patch
TRACKABLE_ENTITY_NAME	VARCHAR2	(50)	Trackable entity name.
LANGUAGE	VARCHAR2	(4)	Language of the bug number.

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 does not reference any database object

APPLSYS.AD_PATCH_HIST_TEMP is referenced by following:

APPS: AD_PATCH_HIST_TEMP