[Home] [Help]
View: BIS_DIMENSIONS_VL
View Text
SELECT DIM.DIMENSION_ID
, DIM.DIM_GRP_ID
, DIM.SHORT_NAME
, DIM.CREATION_DATE
, DIM.CREATED_BY
, DIM.LAST_UPDATE_DATE
, DIM.LAST_UPDATED_BY
, DIM.LAST_UPDATE_LOGIN
, DIM.HIDE_IN_DESIGN
, DIM_TL.NAME
, DIM_TL.DESCRIPTION
, DIM.APPLICATION_ID
FROM BIS_DIMENSIONS DIM
, BIS_DIMENSIONS_TL DIM_TL
WHERE DIM.DIMENSION_ID = DIM_TL.DIMENSION_ID
AND DIM_TL.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
DIMENSION_ID |
SHORT_NAME |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
NAME |
DESCRIPTION |