View: BSC_KPI_TREE_NODES_VL

Product:	BSC - Balanced Scorecard
Description:	View of BSC_KPI_TREE_NODES_B and BSC_KPI_TREE_NODES_TL.
Implementation/DBA Data:	APPS.BSC_KPI_TREE_NODES_VL

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