[Home] [Help]
View: BIS_INDICATORS_VL
View Text
SELECT IND.ROWID ROW_ID
, 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
, IND.DATASET_ID
, IND.ENABLED
, IND.OBSOLETE
, IND.MEASURE_TYPE
FROM BIS_INDICATORS IND
, BIS_INDICATORS_TL IND_TL
WHERE IND.INDICATOR_ID = IND_TL.INDICATOR_ID
AND IND_TL.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
INDICATOR_ID |
SHORT_NAME |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
NAME |
DESCRIPTION |