VIEW: APPS.FEM_XDIM_DIMENSIONS_VL

Source

View Text - Preformatted

SELECT B.DIMENSION_ID,B.DIMENSION_VARCHAR_LABEL,B.DIM_OWNER_APPLICATION_ID,B.OBJECT_VERSION_NUMBER,TL.DIMENSION_NAME,TL.DESCRIPTION,X.MEMBER_DATA_TYPE_CODE,X.MEMBER_B_TABLE_NAME,X.MEMBER_TL_TABLE_NAME,X.MEMBER_VL_OBJECT_NAME,X.MEMBER_COL,X.MEMBER_DISPLAY_CODE_COL,X.MEMBER_NAME_COL,X.MEMBER_DESCRIPTION_COL,X.HIERARCHY_TABLE_NAME,X.ATTRIBUTE_TABLE_NAME,X.DIMENSION_TYPE_CODE,X.SIMPLE_DIMENSION_FLAG,X.COMPOSITE_DIMENSION_FLAG,X.VALUE_SET_REQUIRED_FLAG,X.GROUP_USE_CODE,X.HIER_TYPE_ALLOWED_CODE,X.HIER_VERSIONING_TYPE_CODE,X.HIER_EDITOR_MANAGED_FLAG,X.SEEDED_CATEGORY_CODE,X.RESERVED_LOWER_BOUND,X.RESERVED_UPPER_BOUND,X.READ_ONLY_FLAG,X.ID_FLEX_CODE,X.ID_FLEX_NUM,X.ID_FLEX_STRUCTURE_CODE,X.DIMENSION_ACTIVE_FLAG,X.VS_MEMBER_VL_OBJECT_NAME,X.VS_HIERARCHY_OBJECT_NAME,X.VS_ATTRIBUTE_OBJECT_NAME,X.LOGICAL_DELETE_APPLICABLE_FLAG,X.PERSONAL_HIERARCHY_TABLE_NAME,X.VS_PERSONAL_HIER_OBJECT_NAME,X.USER_DEFINED_FLAG,X.READ_ONLY_APPLICABLE_FLAG,X.DEFAULT_MVS_HIERARCHY_OBJ_ID,X.MEMBER_ID_METHOD_CODE,X.MEMBER_ID_SOURCE_CODE,X.MEMBER_PRIV_TABLE_NAME,X.DEFAULT_MEMBER_DISPLAY_CODE,B.CREATION_DATE,B.CREATED_BY,B.LAST_UPDATED_BY,B.LAST_UPDATE_DATE,B.LAST_UPDATE_LOGIN,X.LOADER_OBJECT_DEF_ID,X.INTF_MEMBER_B_TABLE_NAME,X.INTF_MEMBER_TL_TABLE_NAME,X.INTF_ATTRIBUTE_TABLE_NAME,X.DEFAULT_VALUE_SET_ID,X.DIM_TYPE_CONFIGURABLE_FLAG,X.DSNP_ATTRIBUTE_TABLE_NAME,X.DSNP_PRS_ATTR_VIEW_NAME,X.SEED_LAST_UPDATE_DATE,X.OWB_DIM_MEM_MAPPING_NAME,X.OWB_DIM_MEM_STAGING_TABLE_NAME FROM FEM_DIMENSIONS_TL TL,FEM_DIMENSIONS_B B,FEM_XDIM_DIMENSIONS X WHERE b.dimension_id = tl.dimension_id AND tl.language = USERENV('LANG') AND b.dimension_id = x.dimension_id

View Text - HTML Formatted

SELECT B.DIMENSION_ID
, B.DIMENSION_VARCHAR_LABEL
, B.DIM_OWNER_APPLICATION_ID
, B.OBJECT_VERSION_NUMBER
, TL.DIMENSION_NAME
, TL.DESCRIPTION
, X.MEMBER_DATA_TYPE_CODE
, X.MEMBER_B_TABLE_NAME
, X.MEMBER_TL_TABLE_NAME
, X.MEMBER_VL_OBJECT_NAME
, X.MEMBER_COL
, X.MEMBER_DISPLAY_CODE_COL
, X.MEMBER_NAME_COL
, X.MEMBER_DESCRIPTION_COL
, X.HIERARCHY_TABLE_NAME
, X.ATTRIBUTE_TABLE_NAME
, X.DIMENSION_TYPE_CODE
, X.SIMPLE_DIMENSION_FLAG
, X.COMPOSITE_DIMENSION_FLAG
, X.VALUE_SET_REQUIRED_FLAG
, X.GROUP_USE_CODE
, X.HIER_TYPE_ALLOWED_CODE
, X.HIER_VERSIONING_TYPE_CODE
, X.HIER_EDITOR_MANAGED_FLAG
, X.SEEDED_CATEGORY_CODE
, X.RESERVED_LOWER_BOUND
, X.RESERVED_UPPER_BOUND
, X.READ_ONLY_FLAG
, X.ID_FLEX_CODE
, X.ID_FLEX_NUM
, X.ID_FLEX_STRUCTURE_CODE
, X.DIMENSION_ACTIVE_FLAG
, X.VS_MEMBER_VL_OBJECT_NAME
, X.VS_HIERARCHY_OBJECT_NAME
, X.VS_ATTRIBUTE_OBJECT_NAME
, X.LOGICAL_DELETE_APPLICABLE_FLAG
, X.PERSONAL_HIERARCHY_TABLE_NAME
, X.VS_PERSONAL_HIER_OBJECT_NAME
, X.USER_DEFINED_FLAG
, X.READ_ONLY_APPLICABLE_FLAG
, X.DEFAULT_MVS_HIERARCHY_OBJ_ID
, X.MEMBER_ID_METHOD_CODE
, X.MEMBER_ID_SOURCE_CODE
, X.MEMBER_PRIV_TABLE_NAME
, X.DEFAULT_MEMBER_DISPLAY_CODE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, X.LOADER_OBJECT_DEF_ID
, X.INTF_MEMBER_B_TABLE_NAME
, X.INTF_MEMBER_TL_TABLE_NAME
, X.INTF_ATTRIBUTE_TABLE_NAME
, X.DEFAULT_VALUE_SET_ID
, X.DIM_TYPE_CONFIGURABLE_FLAG
, X.DSNP_ATTRIBUTE_TABLE_NAME
, X.DSNP_PRS_ATTR_VIEW_NAME
, X.SEED_LAST_UPDATE_DATE
, X.OWB_DIM_MEM_MAPPING_NAME
, X.OWB_DIM_MEM_STAGING_TABLE_NAME
FROM FEM_DIMENSIONS_TL TL
, FEM_DIMENSIONS_B B
, FEM_XDIM_DIMENSIONS X
WHERE B.DIMENSION_ID = TL.DIMENSION_ID
AND TL.LANGUAGE = USERENV('LANG')
AND B.DIMENSION_ID = X.DIMENSION_ID