DBA Data[Home] [Help] [Dependency Information]

TABLE: BSC.BSC_KPI_TREE_NODES_B

Object Details
Object Name: BSC_KPI_TREE_NODES_B
Object Type: TABLE
Owner: BSC
FND Design Data: TableBSC.BSC_KPI_TREE_NODES_B
Subobject Name:
Status: VALID


BSC_KPI_TREE_NODES_B stores information about simulation tree nodes by indicator.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_KPI_TREE_NODES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINDICATOR
ColumnNODE_ID
BSC_KPI_TREE_NODES_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORMAT_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Yes Indicator code
NODE_ID NUMBER (5) Yes Tree node identifier
SIMULATE_FLAG NUMBER (3) Yes Simulation flag
FORMAT_ID NUMBER (3) Yes Number format Identifier
COLOR_FLAG NUMBER (3) Yes Node color flag
COLOR_METHOD NUMBER (3) Yes Color method identifier
NAVIGATES_TO_TREND NUMBER (3) Yes If Navigation to trend is enabled
TOP_POSITION NUMBER (5) Yes Position -TOP
LEFT_POSITION NUMBER (5) Yes Position -LEFT
WIDTH NUMBER (5) Yes Position -WIDTH
HEIGHT NUMBER (5) Yes Position -HEIGTH
AUTOSCALE_FLAG NUMBER (1)
Flag that indicates if the scale of the graph will be automatic or not
Query Text

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


SELECT INDICATOR
,      NODE_ID
,      SIMULATE_FLAG
,      FORMAT_ID
,      COLOR_FLAG
,      COLOR_METHOD
,      NAVIGATES_TO_TREND
,      TOP_POSITION
,      LEFT_POSITION
,      WIDTH
,      HEIGHT
,      AUTOSCALE_FLAG
FROM BSC.BSC_KPI_TREE_NODES_B;

Dependencies

[top of page]

BSC.BSC_KPI_TREE_NODES_B does not reference any database object

BSC.BSC_KPI_TREE_NODES_B is referenced by following:

SchemaAPPS
SynonymBSC_KPI_TREE_NODES_B