VIEW: APPS.FEM_USER_DIM8_ATTR_VS

Source

View Text - Preformatted

SELECT A.ATTRIBUTE_ID, A.VERSION_ID, A.USER_DIM8_ID, A.DIM_ATTRIBUTE_NUMERIC_MEMBER, A.DIM_ATTRIBUTE_VALUE_SET_ID, A.DIM_ATTRIBUTE_VARCHAR_MEMBER, A.NUMBER_ASSIGN_VALUE, A.VARCHAR_ASSIGN_VALUE, A.DATE_ASSIGN_VALUE, A.creation_date, A.created_by, A.last_updated_by, A.last_update_date, A.last_update_login, A.object_version_number FROM fem_USER_DIM8_attr A, FEM_DIMENSIONS_B D WHERE VALUE_SET_ID = fem_dimension_util_pkg.dimension_value_set_id(D.dimension_id) AND D.dimension_varchar_label = 'USER_DIM8'

View Text - HTML Formatted

SELECT A.ATTRIBUTE_ID
, A.VERSION_ID
, A.USER_DIM8_ID
, A.DIM_ATTRIBUTE_NUMERIC_MEMBER
, A.DIM_ATTRIBUTE_VALUE_SET_ID
, A.DIM_ATTRIBUTE_VARCHAR_MEMBER
, A.NUMBER_ASSIGN_VALUE
, A.VARCHAR_ASSIGN_VALUE
, A.DATE_ASSIGN_VALUE
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.OBJECT_VERSION_NUMBER
FROM FEM_USER_DIM8_ATTR A
, FEM_DIMENSIONS_B D
WHERE VALUE_SET_ID = FEM_DIMENSION_UTIL_PKG.DIMENSION_VALUE_SET_ID(D.DIMENSION_ID)
AND D.DIMENSION_VARCHAR_LABEL = 'USER_DIM8'