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: BSC.BSC_COLOR_RANGES

Object Details

Object Name:	BSC_COLOR_RANGES
Object Type:	TABLE
Owner:	BSC
FND Design Data:	BSC.BSC_COLOR_RANGES
Subobject Name:
Status:	VALID

Table to store the color tresholds/ranges

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BSC_COLOR_RANGES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COLOR_RANGE_ID COLOR_RANGE_SEQUENCE

Columns

Name	Datatype	Length	Mandatory	Comments
COLOR_RANGE_ID	NUMBER		Yes	Color Range Id
COLOR_RANGE_SEQUENCE	NUMBER		Yes	Sequence to identify a threshold within a color range
LOW	NUMBER			Lower Range Value
HIGH	NUMBER			Higher Range Value
COLOR_ID	NUMBER	(8)		Color Id for the color range

Query Text

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


SELECT COLOR_RANGE_ID
,      COLOR_RANGE_SEQUENCE
,      LOW
,      HIGH
,      COLOR_ID
FROM BSC.BSC_COLOR_RANGES;

Dependencies

[top of page]

BSC.BSC_COLOR_RANGES does not reference any database object

BSC.BSC_COLOR_RANGES is referenced by following:

APPS: BSC_COLOR_RANGES