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_CAUSE_EFFECT_RELS

Object Details

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

BSC_KPI_CAUSE_EFFECT_RELS stores information about indicator cause & effect relationships.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BSC_KPI_CAUSE_EFFECT_RELS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EFFECT_INDICATOR EFFECT_LEVEL
BSC_KPI_CAUSE_EFFECT_RELS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CAUSE_INDICATOR CAUSE_LEVEL

Columns

Name	Datatype	Length	Mandatory	Comments
CAUSE_INDICATOR	NUMBER	(5)	Yes	Cause indicator code
EFFECT_INDICATOR	NUMBER	(5)	Yes	Effect indicator code
CAUSE_LEVEL	VARCHAR2	(10)		Cause Level. It could be KPI or DATASET
EFFECT_LEVEL	VARCHAR2	(10)		Effect Level. It could be KPI or DATASET

Query Text

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


SELECT CAUSE_INDICATOR
,      EFFECT_INDICATOR
,      CAUSE_LEVEL
,      EFFECT_LEVEL
FROM BSC.BSC_KPI_CAUSE_EFFECT_RELS;

Dependencies

[top of page]

BSC.BSC_KPI_CAUSE_EFFECT_RELS does not reference any database object

BSC.BSC_KPI_CAUSE_EFFECT_RELS is referenced by following:

APPS: BSC_KPI_CAUSE_EFFECT_RELS