VIEW: APPS.BISFV_LEVELS_CUSTOMIZATIONS_V

Source

View Text - Preformatted

SELECT bis_levels.LEVEL_ID , bis_levels.SHORT_NAME , NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_NAME(bis_levels.LEVEL_ID),bis_levels_tl.NAME) NAME , NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_DESCRIPTION(bis_levels.LEVEL_ID), bis_levels_tl.DESCRIPTION) 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 , NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_ENABLED(bis_levels.LEVEL_ID), bis_levels.ENABLED) ENABLED 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')

View Text - HTML Formatted

SELECT BIS_LEVELS.LEVEL_ID
, BIS_LEVELS.SHORT_NAME
, NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_NAME(BIS_LEVELS.LEVEL_ID)
, BIS_LEVELS_TL.NAME) NAME
, NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_DESCRIPTION(BIS_LEVELS.LEVEL_ID)
, BIS_LEVELS_TL.DESCRIPTION) 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
, NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_ENABLED(BIS_LEVELS.LEVEL_ID)
, BIS_LEVELS.ENABLED) ENABLED
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')