Product: | BIS - Applications BIS |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BIS_TARGET_LEVELS_V |
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 (+)