Product: | BIS - Applications BIS |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT TGLV.ROWID ROW_ID
, TGLV.TARGET_LEVEL_ID
, TGLV.INDICATOR_ID
, TGLV.SHORT_NAME
, TGLV.ORG_LEVEL_ID
, TGLV.TIME_LEVEL_ID
, TGLV.DIMENSION1_LEVEL_ID
, TGLV.DIMENSION2_LEVEL_ID
, TGLV.DIMENSION3_LEVEL_ID
, TGLV.DIMENSION4_LEVEL_ID
, TGLV.DIMENSION5_LEVEL_ID
, TGLV.DIMENSION6_LEVEL_ID
, TGLV.DIMENSION7_LEVEL_ID
, TGLV.WF_PROCESS
, TGLV.DEFAULT_ROLE_ID
, TGLV.DEFAULT_ROLE
, TGLV.SYSTEM_FLAG
, TGLV.CREATION_DATE
, TGLV.CREATED_BY
, TGLV.LAST_UPDATE_DATE
, TGLV.LAST_UPDATED_BY
, TGLV.LAST_UPDATE_LOGIN
, TGLV_TL.NAME
, TGLV_TL.DESCRIPTION
FROM BIS_TARGET_LEVELS TGLV
, BIS_TARGET_LEVELS_TL TGLV_TL
WHERE TGLV.TARGET_LEVEL_ID = TGLV_TL.TARGET_LEVEL_ID
AND TGLV_TL.LANGUAGE = USERENV('LANG')