VIEW: APPS.BIS_TARGETS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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