[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 |