[Home] [Help]
View: BISBV_DIMENSIONS
View Text
SELECT BIS_DIMENSIONS.DIMENSION_ID
, BIS_DIMENSIONS.DIM_GRP_ID
, BIS_DIMENSIONS.SHORT_NAME
, BIS_DIMENSIONS.APPLICATION_ID
, BIS_DIMENSIONS.HIDE_IN_DESIGN
, 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')
AND BIS_DIMENSIONS.DIMENSION_ID <> -1 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 |