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_KPI_MEASURE_WEIGHTS

Object Details

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

Table to store weights of the KPI Measure. Same KPI can have more than one weight if this KPI belongs to more than one Weighted Average KPI; or, there can be possible multiple weights for a KPI for different dimension object combination in future.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BSC_KPI_MEASURE_WEIGHTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INDICATOR KPI_MEASURE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INDICATOR	NUMBER	(5)	Yes	Objective Id
KPI_MEASURE_ID	NUMBER		Yes	Kpi Measure Id
WEIGHT	NUMBER			Weight of the Kpi Measure
CREATION_DATE	DATE		Yes	Creation Date
CREATED_BY	NUMBER	(15)	Yes	Created By
LAST_UPDATE_DATE	DATE		Yes	Last Update Date
LAST_UPDATED_BY	NUMBER	(15)	Yes	Last Updated By
LAST_UPDATE_LOGIN	NUMBER	(15)		Last Update Login

Query Text

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


SELECT INDICATOR
,      KPI_MEASURE_ID
,      WEIGHT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM BSC.BSC_KPI_MEASURE_WEIGHTS;

Dependencies

[top of page]

BSC.BSC_KPI_MEASURE_WEIGHTS does not reference any database object

BSC.BSC_KPI_MEASURE_WEIGHTS is referenced by following:

APPS: BSC_KPI_MEASURE_WEIGHTS