VIEW: APPS.BIS_TARGET_LEVELS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')