View: BIS_DIMENSIONS_VL

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_DIMENSIONS_VL

View Text

SELECT DIM.ROWID ROW_ID
, 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