VIEW: APPS.BIS_DIMENSIONS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')