[Home] [Help]
View: BSC_KPI_TREE_NODES_VL
| Product: | BSC - Balanced Scorecard (Obsolete) |
|---|
| Description: | View of BSC_KPI_TREE_NODES_B and BSC_KPI_TREE_NODES_TL. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT B.INDICATOR
, B.NODE_ID
, TL.NAME
, TL.HELP
, B.SIMULATE_FLAG
, B.FORMAT_ID
, B.COLOR_FLAG
, B.COLOR_METHOD
, B.NAVIGATES_TO_TREND
, B.TOP_POSITION
, B.LEFT_POSITION
, B.WIDTH
, B.HEIGHT
, NVL(B.AUTOSCALE_FLAG
, 0) AS AUTOSCALE_FLAG
, TL.Y_AXIS_TITLE FROM BSC_KPI_TREE_NODES_B B
, BSC_KPI_TREE_NODES_TL TL
WHERE B.INDICATOR = TL.INDICATOR
AND B.NODE_ID = TL.NODE_ID
AND TL.LANGUAGE =USERENV('LANG')
Columns
| Name |
| INDICATOR |
| NODE_ID |
| NAME |
| HELP |
| SIMULATE_FLAG |
| FORMAT_ID |
| COLOR_FLAG |
| COLOR_METHOD |
| NAVIGATES_TO_TREND |
| TOP_POSITION |
| LEFT_POSITION |
| WIDTH |
| HEIGHT |
| AUTOSCALE_FLAG |
| Y_AXIS_TITLE |