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_TRACKABLE_ENTITIES

Object Details

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

Stores Oracle Applications Entities and their Code Levels

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AD_TRACKABLE_ENTITIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ABBREVIATION

Columns

Name	Datatype	Length	Mandatory	Comments
ABBREVIATION	VARCHAR2	(8)	Yes	Product Abbreviation
NAME	VARCHAR2	(50)	Yes	Holds the name of the trackable entity
TYPE	VARCHAR2	(30)	Yes	Holds the type of the trackable entity
USED_FLAG	VARCHAR2	(1)		Flag to indicate whether the trackable entity is used
LOAD_FLAG	VARCHAR2	(1)		Flag to identify whether to load the trackable entity
CODELEVEL	VARCHAR2	(150)	Yes	Holds the codelevel of the trackable entity
BASELINE	VARCHAR2	(150)	Yes	Holds the baseline of the trackable entity

Query Text

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


SELECT ABBREVIATION
,      NAME
,      TYPE
,      USED_FLAG
,      LOAD_FLAG
,      CODELEVEL
,      BASELINE
FROM APPLSYS.AD_TRACKABLE_ENTITIES;

Dependencies

[top of page]

APPLSYS.AD_TRACKABLE_ENTITIES does not reference any database object

APPLSYS.AD_TRACKABLE_ENTITIES is referenced by following:

APPLSYS: AD_TRACKABLE_ENTITIES#