HWM_TM_REP_M_CUST_ATRB_VAL_V

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name

TM_REC_ID TM_REC_VERSION TM_REP_ATRB_ID ATTRIBUTE_NAME ATTRIBUTE_VARCHAR_VALUE TM_ATRB_FLD_ID OBJECT_VERSION_NUMBER ENTERPRISE_ID MODULE_ID TCSMRS_ID NAME CLASS PARENT_TM_ATRB_FLD_ID GLOBAL_TM_ATRB_FLD_ID VALUE_LOCATION ATTRIBUTE_CATEGORY ALLOWED_SCOPE MANDATORY_FOR_TCSMRS DESCRIPTION ATTRIBUTE_TYPE ATTRIBUTE_GROUP VALUE_SET_ID COMP_DISP_CODE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY

Query

SQL_Statement

SELECT TM_REC_ID, TM_REC_VERSION, TM_REP_ATRB_ID, ATTRIBUTE_NAME, ATTRIBUTE_VARCHAR_VALUE, TM_ATRB_FLD_ID, OBJECT_VERSION_NUMBER, ENTERPRISE_ID, MODULE_ID, TCSMRS_ID, NAME, CLASS, PARENT_TM_ATRB_FLD_ID, GLOBAL_TM_ATRB_FLD_ID, VALUE_LOCATION, ATTRIBUTE_CATEGORY, ALLOWED_SCOPE, MANDATORY_FOR_TCSMRS, DESCRIPTION, ATTRIBUTE_TYPE, ATTRIBUTE_GROUP, VALUE_SET_ID, COMP_DISP_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY FROM (SELECT U.USAGES_SOURCE_ID TM_REC_ID, U.USAGES_SOURCE_VERSION TM_REC_VERSION, U.TM_REP_ATRB_ID, MasterTimeAttributeField.DISPLAY_NAME ATTRIBUTE_NAME, ATT.VARCHAR_ATT_VALUE ATTRIBUTE_VARCHAR_VALUE, MasterTimeAttributeField.* FROM (SELECT TM_REP_ATRB_ID, NULL ATTRIBUTE_CATEGORY, MASTER_ATTRIBUTE_ID, VALUE_LOC, VARCHAR_ATT_VALUE FROM HWM_TM_REP_ATRBS unpivot (VARCHAR_ATT_VALUE FOR VALUE_LOC IN (ATTRIBUTE_CATEGORY AS 'AttributeCategory')) ) ATT INNER JOIN HWM_TM_REP_ATRB_USAGES U ON ATT.TM_REP_ATRB_ID = U.TM_REP_ATRB_ID INNER JOIN HWM_TM_ATRB_FLDS_VL MasterTimeAttributeField ON MasterTimeAttributeField.CLASS = 'MASTER' AND MasterTimeAttributeField.TM_ATRB_FLD_ID = ATT.MASTER_ATTRIBUTE_ID ) WHERE TM_ATRB_FLD_ID IS NOT NULL