DBA Data[Home] [Help]

VIEW: APPS.BISFV_IND_CUSTOMIZATIONS_V

Source

View Text - Preformatted

SELECT IND.INDICATOR_ID , IND.SHORT_NAME , IND.CREATION_DATE , IND.CREATED_BY , IND.LAST_UPDATE_DATE , IND.LAST_UPDATED_BY , IND.LAST_UPDATE_LOGIN , IND_TL.NAME ,IND_TL.DESCRIPTION , NVL(BIS_MEASURE_PUB.GET_CUSTOMIZED_ENABLED(IND.INDICATOR_ID),IND.enabled) as enabled, IND.DATASET_ID FROM BIS_INDICATORS IND , BIS_INDICATORS_TL IND_TL WHERE IND.INDICATOR_ID = IND_TL.INDICATOR_ID AND IND_TL.LANGUAGE = USERENV('LANG') AND NVL(IND.OBSOLETE,'F') = 'F'
   
View Text - HTML Formatted

SELECT IND.INDICATOR_ID
, IND.SHORT_NAME
, IND.CREATION_DATE
, IND.CREATED_BY
, IND.LAST_UPDATE_DATE
, IND.LAST_UPDATED_BY
, IND.LAST_UPDATE_LOGIN
, IND_TL.NAME
, IND_TL.DESCRIPTION
, NVL(BIS_MEASURE_PUB.GET_CUSTOMIZED_ENABLED(IND.INDICATOR_ID)
, IND.ENABLED) AS ENABLED
, IND.DATASET_ID
FROM BIS_INDICATORS IND
, BIS_INDICATORS_TL IND_TL
WHERE IND.INDICATOR_ID = IND_TL.INDICATOR_ID
AND IND_TL.LANGUAGE = USERENV('LANG')
AND NVL(IND.OBSOLETE
, 'F') = 'F'