VIEW: APPS.BIS_TARGET_LEVELS_V

Source

View Text - Preformatted

SELECT A.ROWID , A.TARGET_LEVEL_ID , A.INDICATOR_ID , B.NAME , A.SHORT_NAME , A.ORG_LEVEL_ID , A.TIME_LEVEL_ID , A.DIMENSION1_LEVEL_ID , A.DIMENSION2_LEVEL_ID , A.DIMENSION3_LEVEL_ID , A.DIMENSION4_LEVEL_ID , A.DIMENSION5_LEVEL_ID , A.DIMENSION6_LEVEL_ID , A.DIMENSION7_LEVEL_ID , LEVORG.SHORT_NAME , LEVTIME.SHORT_NAME , LEV1.SHORT_NAME , LEV2.SHORT_NAME , LEV3.SHORT_NAME , LEV4.SHORT_NAME , LEV5.SHORT_NAME , LEV6.SHORT_NAME , LEV7.SHORT_NAME , A.WF_PROCESS , A.DEFAULT_ROLE_ID , A.DEFAULT_ROLE , A.SYSTEM_FLAG , A.CREATION_DATE , A.CREATED_BY , A.LAST_UPDATE_DATE , A.LAST_UPDATED_BY , A.LAST_UPDATE_LOGIN , A.NAME , A.DESCRIPTION FROM BIS_TARGET_LEVELS_VL A , BIS_INDICATORS_VL B , BIS_LEVELS LEVORG , BIS_LEVELS LEVTIME , BIS_LEVELS LEV1 , BIS_LEVELS LEV2 , BIS_LEVELS LEV3 , BIS_LEVELS LEV4 , BIS_LEVELS LEV5 , BIS_LEVELS LEV6 , BIS_LEVELS LEV7 WHERE A.INDICATOR_ID = B.INDICATOR_ID AND A.ORG_LEVEL_ID = LEVORG.LEVEL_ID (+) AND A.TIME_LEVEL_ID = LEVTIME.LEVEL_ID (+) AND A.DIMENSION1_LEVEL_ID = LEV1.LEVEL_ID (+) AND A.DIMENSION2_LEVEL_ID = LEV2.LEVEL_ID (+) AND A.DIMENSION3_LEVEL_ID = LEV3.LEVEL_ID (+) AND A.DIMENSION4_LEVEL_ID = LEV4.LEVEL_ID (+) AND A.DIMENSION5_LEVEL_ID = LEV5.LEVEL_ID (+) AND A.DIMENSION6_LEVEL_ID = LEV6.LEVEL_ID (+) AND A.DIMENSION7_LEVEL_ID = LEV7.LEVEL_ID (+)

View Text - HTML Formatted

SELECT A.ROWID
, A.TARGET_LEVEL_ID
, A.INDICATOR_ID
, B.NAME
, A.SHORT_NAME
, A.ORG_LEVEL_ID
, A.TIME_LEVEL_ID
, A.DIMENSION1_LEVEL_ID
, A.DIMENSION2_LEVEL_ID
, A.DIMENSION3_LEVEL_ID
, A.DIMENSION4_LEVEL_ID
, A.DIMENSION5_LEVEL_ID
, A.DIMENSION6_LEVEL_ID
, A.DIMENSION7_LEVEL_ID
, LEVORG.SHORT_NAME
, LEVTIME.SHORT_NAME
, LEV1.SHORT_NAME
, LEV2.SHORT_NAME
, LEV3.SHORT_NAME
, LEV4.SHORT_NAME
, LEV5.SHORT_NAME
, LEV6.SHORT_NAME
, LEV7.SHORT_NAME
, A.WF_PROCESS
, A.DEFAULT_ROLE_ID
, A.DEFAULT_ROLE
, A.SYSTEM_FLAG
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.NAME
, A.DESCRIPTION
FROM BIS_TARGET_LEVELS_VL A
, BIS_INDICATORS_VL B
, BIS_LEVELS LEVORG
, BIS_LEVELS LEVTIME
, BIS_LEVELS LEV1
, BIS_LEVELS LEV2
, BIS_LEVELS LEV3
, BIS_LEVELS LEV4
, BIS_LEVELS LEV5
, BIS_LEVELS LEV6
, BIS_LEVELS LEV7
WHERE A.INDICATOR_ID = B.INDICATOR_ID
AND A.ORG_LEVEL_ID = LEVORG.LEVEL_ID (+)
AND A.TIME_LEVEL_ID = LEVTIME.LEVEL_ID (+)
AND A.DIMENSION1_LEVEL_ID = LEV1.LEVEL_ID (+)
AND A.DIMENSION2_LEVEL_ID = LEV2.LEVEL_ID (+)
AND A.DIMENSION3_LEVEL_ID = LEV3.LEVEL_ID (+)
AND A.DIMENSION4_LEVEL_ID = LEV4.LEVEL_ID (+)
AND A.DIMENSION5_LEVEL_ID = LEV5.LEVEL_ID (+)
AND A.DIMENSION6_LEVEL_ID = LEV6.LEVEL_ID (+)
AND A.DIMENSION7_LEVEL_ID = LEV7.LEVEL_ID (+)