View: BIS_TARGETS_V

View Text

SELECT BI.INDICATOR_ID
, BI.SHORT_NAME
, BTL.TARGET_LEVEL_ID
, BTL.SHORT_NAME
, BP.PLAN_ID
, BP.SHORT_NAME
, NVL(BTV.ROLE1_ID
, BTL.DEFAULT_ROLE_ID)
, NVL(BTV.ROLE1
, BTL.DEFAULT_ROLE)
, NVL(BTV.ROLE2_ID
, BTL.DEFAULT_ROLE_ID)
, NVL(BTV.ROLE2
, BTL.DEFAULT_ROLE)
, NVL(BTV.ROLE3_ID
, BTL.DEFAULT_ROLE_ID)
, NVL(BTV.ROLE3
, BTL.DEFAULT_ROLE)
, DORGL.SHORT_NAME
, BTV.DIMENSION1_LEVEL_VALUE
, DTIMEL.SHORT_NAME
, BTV.DIMENSION1_LEVEL_VALUE
, D1L.SHORT_NAME
, BTV.DIMENSION1_LEVEL_VALUE
, D2L.SHORT_NAME
, BTV.DIMENSION2_LEVEL_VALUE
, D3L.SHORT_NAME
, BTV.DIMENSION3_LEVEL_VALUE
, D4L.SHORT_NAME
, BTV.DIMENSION4_LEVEL_VALUE
, D5L.SHORT_NAME
, BTV.DIMENSION5_LEVEL_VALUE
, D6L.SHORT_NAME
, BTV.DIMENSION6_LEVEL_VALUE
, D7L.SHORT_NAME
, BTV.DIMENSION7_LEVEL_VALUE
, NVL(BTV.TARGET
, 0)
, NVL(BTV.RANGE1_LOW
, NVL(BTV.TARGET
, 0))
, NVL(BTV.RANGE1_HIGH
, NVL(BTV.TARGET
, 0))
, NVL(BTV.RANGE2_LOW
, NVL(BTV.TARGET
, 0))
, NVL(BTV.RANGE2_HIGH
, NVL(BTV.TARGET
, 0))
, NVL(BTV.RANGE3_LOW
, NVL(BTV.TARGET
, 0))
, NVL(BTV.RANGE3_HIGH
, NVL(BTV.TARGET
, 0))
, BTL.WF_PROCESS
FROM BIS_LEVELS D6L
, BIS_LEVELS D7L
, BIS_LEVELS D1L
, BIS_LEVELS D2L
, BIS_LEVELS D3L
, BIS_LEVELS D4L
, BIS_LEVELS D5L
, BIS_LEVELS DORGL
, BIS_LEVELS DTIMEL
, BIS_INDICATORS BI
, BIS_BUSINESS_PLANS BP
, BIS_TARGET_LEVELS BTL
, BIS_TARGET_VALUES BTV
WHERE D1L.LEVEL_ID(+) = NVL(BTL.DIMENSION1_LEVEL_ID
, -1)
AND D2L.LEVEL_ID(+) = NVL(BTL.DIMENSION2_LEVEL_ID
, -1)
AND D3L.LEVEL_ID(+) = NVL(BTL.DIMENSION3_LEVEL_ID
, -1)
AND D4L.LEVEL_ID(+) = NVL(BTL.DIMENSION4_LEVEL_ID
, -1)
AND D5L.LEVEL_ID(+) = NVL(BTL.DIMENSION5_LEVEL_ID
, -1)
AND D6L.LEVEL_ID(+) = NVL(BTL.DIMENSION6_LEVEL_ID
, -1)
AND D7L.LEVEL_ID(+) = NVL(BTL.DIMENSION7_LEVEL_ID
, -1)
AND DORGL.LEVEL_ID(+) = NVL(BTL.ORG_LEVEL_ID
, -1)
AND DTIMEL.LEVEL_ID(+) = NVL(BTL.TIME_LEVEL_ID
, -1)
AND BI.INDICATOR_ID = BTL.INDICATOR_ID
AND BP.PLAN_ID = BTV.PLAN_ID
AND BTL.TARGET_LEVEL_ID = BTV.TARGET_LEVEL_ID

Columns