[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 |