[Home] [Help]
View: BISFV_DIMENSIONS
View Text
SELECT BIS_DIMENSIONS.DIMENSION_ID
, BIS_DIMENSIONS.SHORT_NAME
, BIS_DIMENSIONS_TL.NAME
, BIS_DIMENSIONS_TL.DESCRIPTION
, BIS_DIMENSIONS.CREATION_DATE
, BIS_DIMENSIONS.CREATED_BY
, BIS_DIMENSIONS.LAST_UPDATE_DATE
, BIS_DIMENSIONS.LAST_UPDATED_BY
, BIS_DIMENSIONS.LAST_UPDATE_LOGIN
FROM BIS_DIMENSIONS BIS_DIMENSIONS
, BIS_DIMENSIONS_TL BIS_DIMENSIONS_TL
WHERE BIS_DIMENSIONS.DIMENSION_ID = BIS_DIMENSIONS_TL.DIMENSION_ID
AND BIS_DIMENSIONS_TL.LANGUAGE = USERENV('LANG') WITH READ ONLY
Columns
| Name |
| DIMENSION_ID |
| DIMENSION_SHORT_NAME |
| DIMENSION_NAME |
| DESCRIPTION |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |