View: BISFV_DIMENSION_LEVELS

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

View Text

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

Columns