VIEW: APPS.BSC_KPI_TREE_NODES_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')