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: BIS.BIS_PARAM_COLOR_TRIGGERS

Object Details

Object Name:	BIS_PARAM_COLOR_TRIGGERS
Object Type:	TABLE
Owner:	BIS
FND Design Data:	BIS.BIS_PARAM_COLOR_TRIGGERS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIS_PARAM_COLOR_TRIGGERS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATASET_ID PLAN_ID COLOR_SET_ID DIM_LEVEL1_KEY DIM_LEVEL1_VALUE DIM_LEVEL2_KEY DIM_LEVEL2_VALUE DIM_LEVEL3_KEY DIM_LEVEL3_VALUE DIM_LEVEL4_KEY DIM_LEVEL4_VALUE DIM_LEVEL5_KEY DIM_LEVEL5_VALUE DIM_LEVEL6_KEY DIM_LEVEL6_VALUE DIM_LEVEL7_KEY DIM_LEVEL7_VALUE DIM_LEVEL8_KEY DIM_LEVEL8_VALUE DIM_LEVEL9_KEY DIM_LEVEL9_VALUE DIM_LEVEL10_KEY DIM_LEVEL10_VALUE

Columns

Name	Datatype	Length
DATASET_ID	NUMBER	(5)
PLAN_ID	NUMBER	(3)
INDICATOR	NUMBER	(5)
COLOR_SET_ID	NUMBER	(15)
DIM_LEVEL1_KEY	VARCHAR2	(100)
DIM_LEVEL1_VALUE	VARCHAR2	(400)
DIM_LEVEL2_KEY	VARCHAR2	(100)
DIM_LEVEL2_VALUE	VARCHAR2	(400)
DIM_LEVEL3_KEY	VARCHAR2	(100)
DIM_LEVEL3_VALUE	VARCHAR2	(400)
DIM_LEVEL4_KEY	VARCHAR2	(100)
DIM_LEVEL4_VALUE	VARCHAR2	(400)
DIM_LEVEL5_KEY	VARCHAR2	(100)
DIM_LEVEL5_VALUE	VARCHAR2	(400)
DIM_LEVEL6_KEY	VARCHAR2	(100)
DIM_LEVEL6_VALUE	VARCHAR2	(400)
DIM_LEVEL7_KEY	VARCHAR2	(100)
DIM_LEVEL7_VALUE	VARCHAR2	(400)
DIM_LEVEL8_KEY	VARCHAR2	(100)
DIM_LEVEL8_VALUE	VARCHAR2	(400)
DIM_LEVEL9_KEY	VARCHAR2	(100)
DIM_LEVEL9_VALUE	VARCHAR2	(400)
DIM_LEVEL10_KEY	VARCHAR2	(100)
DIM_LEVEL10_VALUE	VARCHAR2	(400)

Query Text

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


SELECT DATASET_ID
,      PLAN_ID
,      INDICATOR
,      COLOR_SET_ID
,      DIM_LEVEL1_KEY
,      DIM_LEVEL1_VALUE
,      DIM_LEVEL2_KEY
,      DIM_LEVEL2_VALUE
,      DIM_LEVEL3_KEY
,      DIM_LEVEL3_VALUE
,      DIM_LEVEL4_KEY
,      DIM_LEVEL4_VALUE
,      DIM_LEVEL5_KEY
,      DIM_LEVEL5_VALUE
,      DIM_LEVEL6_KEY
,      DIM_LEVEL6_VALUE
,      DIM_LEVEL7_KEY
,      DIM_LEVEL7_VALUE
,      DIM_LEVEL8_KEY
,      DIM_LEVEL8_VALUE
,      DIM_LEVEL9_KEY
,      DIM_LEVEL9_VALUE
,      DIM_LEVEL10_KEY
,      DIM_LEVEL10_VALUE
FROM BIS.BIS_PARAM_COLOR_TRIGGERS;

Dependencies

[top of page]

BIS.BIS_PARAM_COLOR_TRIGGERS does not reference any database object

BIS.BIS_PARAM_COLOR_TRIGGERS is referenced by following:

APPS: BIS_PARAM_COLOR_TRIGGERS