SELECT LEV.LEVEL_ID , LEV.SHORT_NAME , LEV.DIMENSION_ID , LEV.LEVEL_VALUES_VIEW_NAME , LEV.WHERE_CLAUSE , LEV.CREATION_DATE , LEV.CREATED_BY , LEV.LAST_UPDATE_DATE , LEV.LAST_UPDATED_BY , LEV.LAST_UPDATE_LOGIN , LEV_TL.NAME , LEV_TL.DESCRIPTION , LEV.SOURCE , LEV.COMPARISON_LABEL_CODE , LEV.ATTRIBUTE_CODE , LEV.APPLICATION_ID , LEV.DEFAULT_SEARCH , LEV.LONG_LOV , LEV.MASTER_LEVEL , LEV.ENABLED , LEV.VIEW_OBJECT_NAME , LEV.DEFAULT_VALUES_API , LEV.DRILL_TO_FORM_FUNCTION , LEV.HIDE_IN_DESIGN FROM BIS_LEVELS LEV, BIS_LEVELS_TL LEV_TL WHERE LEV.LEVEL_ID = LEV_TL.LEVEL_ID AND LEV_TL.LANGUAGE = USERENV('LANG')
SELECT LEV.LEVEL_ID
, LEV.SHORT_NAME
, LEV.DIMENSION_ID
, LEV.LEVEL_VALUES_VIEW_NAME
, LEV.WHERE_CLAUSE
, LEV.CREATION_DATE
, LEV.CREATED_BY
, LEV.LAST_UPDATE_DATE
, LEV.LAST_UPDATED_BY
, LEV.LAST_UPDATE_LOGIN
, LEV_TL.NAME
, LEV_TL.DESCRIPTION
, LEV.SOURCE
, LEV.COMPARISON_LABEL_CODE
, LEV.ATTRIBUTE_CODE
, LEV.APPLICATION_ID
, LEV.DEFAULT_SEARCH
, LEV.LONG_LOV
, LEV.MASTER_LEVEL
, LEV.ENABLED
, LEV.VIEW_OBJECT_NAME
, LEV.DEFAULT_VALUES_API
, LEV.DRILL_TO_FORM_FUNCTION
, LEV.HIDE_IN_DESIGN
FROM BIS_LEVELS LEV
, BIS_LEVELS_TL LEV_TL
WHERE LEV.LEVEL_ID = LEV_TL.LEVEL_ID
AND LEV_TL.LANGUAGE = USERENV('LANG')
|
|
|