DBA Data[Home] [Help]

VIEW: APPS.FEM_DSNP_DIM_ATTR_VRS_V

Source

View Text - Preformatted

SELECT T.CREATED_BY_OBJECT_ID,B.ATTRIBUTE_ID,B.VERSION_DISPLAY_CODE,B.DEFAULT_VERSION_FLAG,B.PERSONAL_FLAG,T.VERSION_ID,T.VERSION_NAME,T.DESCRIPTION,B.CREATION_DATE,B.CREATED_BY,B.LAST_UPDATED_BY,B.LAST_UPDATE_DATE,B.LAST_UPDATE_LOGIN FROM FEM_DIM_ATTR_VERSIONS_B B,FEM_DSNP_DIM_ATTR_VRS_TL T WHERE T.language = userenv('LANG') and T.version_id = B.version_id
View Text - HTML Formatted

SELECT T.CREATED_BY_OBJECT_ID
, B.ATTRIBUTE_ID
, B.VERSION_DISPLAY_CODE
, B.DEFAULT_VERSION_FLAG
, B.PERSONAL_FLAG
, T.VERSION_ID
, T.VERSION_NAME
, T.DESCRIPTION
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM FEM_DIM_ATTR_VERSIONS_B B
, FEM_DSNP_DIM_ATTR_VRS_TL T
WHERE T.LANGUAGE = USERENV('LANG')
AND T.VERSION_ID = B.VERSION_ID