[Home] [Help]
View: BISFV_IND_CUSTOMIZATIONS_V
Product: | BIS - Applications BIS |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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'