View: BIS_LEVELS_VL

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_LEVELS_VL

View Text

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

Columns