VIEW: APPS.FEM_USER_DIM10_VS

Source

View Text - Preformatted

SELECT B.USER_DIM10_ID,B.DIMENSION_GROUP_ID,B.USER_DIM10_DISPLAY_CODE,B.ENABLED_FLAG,B.PERSONAL_FLAG,TL.USER_DIM10_NAME,TL.DESCRIPTION,B.CREATION_DATE,B.CREATED_BY,B.LAST_UPDATED_BY,B.LAST_UPDATE_DATE,B.LAST_UPDATE_LOGIN,B.OBJECT_VERSION_NUMBER,B.READ_ONLY_FLAG FROM FEM_USER_DIM10_TL TL,FEM_USER_DIM10_B B,FEM_DIMENSIONS_B D WHERE b.VALUE_SET_ID = fem_dimension_util_pkg.dimension_value_set_id(D.dimension_id) AND b.USER_DIM10_ID = tl.USER_DIM10_ID AND b.VALUE_SET_ID = tl.VALUE_SET_ID AND D.dimension_varchar_label = 'USER_DIM10' AND tl.language = USERENV('LANG')

View Text - HTML Formatted

SELECT B.USER_DIM10_ID
, B.DIMENSION_GROUP_ID
, B.USER_DIM10_DISPLAY_CODE
, B.ENABLED_FLAG
, B.PERSONAL_FLAG
, TL.USER_DIM10_NAME
, TL.DESCRIPTION
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.READ_ONLY_FLAG
FROM FEM_USER_DIM10_TL TL
, FEM_USER_DIM10_B B
, FEM_DIMENSIONS_B D
WHERE B.VALUE_SET_ID = FEM_DIMENSION_UTIL_PKG.DIMENSION_VALUE_SET_ID(D.DIMENSION_ID)
AND B.USER_DIM10_ID = TL.USER_DIM10_ID
AND B.VALUE_SET_ID = TL.VALUE_SET_ID
AND D.DIMENSION_VARCHAR_LABEL = 'USER_DIM10'
AND TL.LANGUAGE = USERENV('LANG')