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_COND_HISTORY

Object Details

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

To store codelevel validation lines of a patch.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
COND_TE_LEVEL	VARCHAR2	(150)	Conditional entity's level.
COND_TE_NAME	VARCHAR2	(8)	Conditional entity name.
CONDITION	VARCHAR2	(6)	Condition name ifload or ifused
REQUIRED_LEVEL	VARCHAR2	(150)	required entity level or baseline.
REQUIRED_TE_ABBR	VARCHAR2	(8)	required entity name
TRACKABLE_ENTITY_ABBR	VARCHAR2	(8)	Trackable entity name for which validation is done.
PATCH_RUN_ID	NUMBER		Patch Run ID

Query Text

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


SELECT COND_TE_LEVEL
,      COND_TE_NAME
,      CONDITION
,      REQUIRED_LEVEL
,      REQUIRED_TE_ABBR
,      TRACKABLE_ENTITY_ABBR
,      PATCH_RUN_ID
FROM APPLSYS.AD_PATCH_COND_HISTORY;

Dependencies

[top of page]

APPLSYS.AD_PATCH_COND_HISTORY does not reference any database object

APPLSYS.AD_PATCH_COND_HISTORY is referenced by following:

APPS: AD_PATCH_COND_HISTORY