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_TE_LEVEL_HISTORY

Object Details

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

Holds the history information of trackable entity codelevels. Whenever a row is updated in AD_TRACKABLE_ENTITIES, the row before updating is inserted in this table for history purposes

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ABBREVIATION	VARCHAR2	(8)	Yes	Product Abbreviation
NAME	VARCHAR2	(50)	Yes	trackable entity name
CODELEVEL	VARCHAR2	(150)	Yes	Holds the codelevel of the trackable entity
BASELINE	VARCHAR2	(150)	Yes	Holds the baseline of the trackable entity
PATCH_RUN_ID	NUMBER		Yes	Identifies the AD_PATCH_RUNS record

Query Text

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


SELECT ABBREVIATION
,      NAME
,      CODELEVEL
,      BASELINE
,      PATCH_RUN_ID
FROM APPLSYS.AD_TE_LEVEL_HISTORY;

Dependencies

[top of page]

APPLSYS.AD_TE_LEVEL_HISTORY does not reference any database object

APPLSYS.AD_TE_LEVEL_HISTORY is referenced by following:

APPLSYS: AD_TE_LEVEL_HISTORY#