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_SNAPS_TEMP

Object Details

Object Name:	AD_PATCH_HIST_SNAPS_TEMP
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	AD.AD_PATCH_HIST_SNAPS_TEMP
Subobject Name:
Status:	VALID

AD_PATCH_HIST_SNAPS_TEMP is a temporary staging table for updating the "current-view" snapshot using information from the patch-history tables. It is used internally by Autopatch.
.
Autopatch does this by populating the PATCH_RUN_ID and ACTION_CODE columns, and then it calls the PL/SQL package AD_FILE_SYS_SNAPSHOTS_PKG.Update_Current_View.
.
The PL/SQL package in turn creates lots of intermediate rows as part of its processing, and the remaining columns of the table are relevant for that processing.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AD_PATCH_HIST_SNAPS_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ACTION_CODE
AD_PATCH_HIST_SNAPS_TEMP_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BUG_ID
AD_PATCH_HIST_SNAPS_TEMP_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	FILE_ID

Columns

Name	Datatype	Length	Comments
PATCH_RUN_ID	NUMBER		Identifies the specific patch-run's history row, whose information is to be used to update the current-view snapshot
BUG_ID	NUMBER		Bugfix identifier
ACTION_CODE	NUMBER		Code indicating what kind of row this is
FILE_ID	NUMBER		File identifier
APP_SHORT_NAME	VARCHAR2	(50)	Application short name of the file's owning product. Helps in populating CLIB_ARCH_FILE_ID. Relevant only if any file was copied by the patch
FILENAME	VARCHAR2	(250)	File name. Helps in populating CLIB_ARCH_FILE_ID. Relevant only if any file was copied by the patch
FILE_VERSION_ID	NUMBER		File version identifier. Relevant only if any file was copied by the patch
VERSION_SEGMENT1	NUMBER		Version segment 1. Relevant only if any file was copied by the patch
VERSION_SEGMENT2	NUMBER		Version segment 2. Relevant only if any file was copied by the patch
VERSION_SEGMENT3	NUMBER		Version segment 3. Relevant only if any file was copied by the patch
VERSION_SEGMENT4	NUMBER		Version segment 4. Relevant only if any file was copied by the patch
VERSION_SEGMENT5	NUMBER		Version segment 5. Relevant only if any file was copied by the patch
VERSION_SEGMENT6	NUMBER		Version segment 6. Relevant only if any file was copied by the patch
VERSION_SEGMENT7	NUMBER		Version segment 7. Relevant only if any file was copied by the patch
VERSION_SEGMENT8	NUMBER		Version segment 8. Relevant only if any file was copied by the patch
VERSION_SEGMENT9	NUMBER		Version segment 9. Relevant only if any file was copied by the patch
VERSION_SEGMENT10	NUMBER		Version segment 10. Relevant only if any file was copied by the patch
TRANSLATION_LEVEL	NUMBER		Translation level. Relevant only if any file was copied by the patch
CLIB_ARCH_FILE_ID	NUMBER		File identifier of the C archive library that contains the file identified by FILE_ID. Helps in populating the CONTAINING_FILE_ID column in AD_SNAPSHOT_FILES. Relevant only if the file is a C object file copied by the patch
DEST_FILE_ID	NUMBER		File_id for a file in its copy destination location
FILE_TYPE_FLAG	VARCHAR2	(1)	Mirror or NoMirror Flag
IREP_GATHERED_FLAG	VARCHAR2	(1)	Flag determining if the file has been processed by the Interface Repository

Query Text

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


SELECT PATCH_RUN_ID
,      BUG_ID
,      ACTION_CODE
,      FILE_ID
,      APP_SHORT_NAME
,      FILENAME
,      FILE_VERSION_ID
,      VERSION_SEGMENT1
,      VERSION_SEGMENT2
,      VERSION_SEGMENT3
,      VERSION_SEGMENT4
,      VERSION_SEGMENT5
,      VERSION_SEGMENT6
,      VERSION_SEGMENT7
,      VERSION_SEGMENT8
,      VERSION_SEGMENT9
,      VERSION_SEGMENT10
,      TRANSLATION_LEVEL
,      CLIB_ARCH_FILE_ID
,      DEST_FILE_ID
,      FILE_TYPE_FLAG
,      IREP_GATHERED_FLAG
FROM APPLSYS.AD_PATCH_HIST_SNAPS_TEMP;

Dependencies

[top of page]

APPLSYS.AD_PATCH_HIST_SNAPS_TEMP does not reference any database object

APPLSYS.AD_PATCH_HIST_SNAPS_TEMP is referenced by following:

APPLSYS: AD_PATCH_HIST_SNAPS_TEMP#