VIEW: APPS.BISBV_DIMENSION_LEVELS

Source

View Text - Preformatted

SELECT bis_levels.LEVEL_ID , bis_levels.SHORT_NAME , bis_levels_tl.NAME , bis_levels_tl.DESCRIPTION , bis_levels.DIMENSION_ID , 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.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 FROM bis_levels bis_levels , bis_levels_tl bis_levels_tl WHERE bis_levels.LEVEL_ID = bis_levels_tl.LEVEL_ID AND bis_levels_tl.LANGUAGE = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT BIS_LEVELS.LEVEL_ID
, BIS_LEVELS.SHORT_NAME
, BIS_LEVELS_TL.NAME
, BIS_LEVELS_TL.DESCRIPTION
, BIS_LEVELS.DIMENSION_ID
, 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.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
FROM BIS_LEVELS BIS_LEVELS
, BIS_LEVELS_TL BIS_LEVELS_TL
WHERE BIS_LEVELS.LEVEL_ID = BIS_LEVELS_TL.LEVEL_ID
AND BIS_LEVELS_TL.LANGUAGE = USERENV('LANG') WITH READ ONLY