[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AD_TRACKABLE_ENTITIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ABBREVIATION |
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 |
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;
APPLSYS.AD_TRACKABLE_ENTITIES does not reference any database object
APPLSYS.AD_TRACKABLE_ENTITIES is referenced by following:
|
|
|