HWM_TE_ATRB_FLDS_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name
TM_REC_ID TM_REC_VERSION 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 DISPLAY_NAME 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 HWM_TM_REC.TM_REC_ID, HWM_TM_REC.TM_REC_VERSION, HWM_TM_ATRB_FLDS_VL.TM_ATRB_FLD_ID TM_ATRB_FLD_ID, HWM_TM_ATRB_FLDS_VL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HWM_TM_ATRB_FLDS_VL.ENTERPRISE_ID ENTERPRISE_ID, HWM_TM_ATRB_FLDS_VL.MODULE_ID MODULE_ID, HWM_TM_ATRB_FLDS_VL.TCSMRS_ID TCSMRS_ID, HWM_TM_ATRB_FLDS_VL.NAME NAME, HWM_TM_ATRB_FLDS_VL.CLASS CLASS, HWM_TM_ATRB_FLDS_VL.PARENT_TM_ATRB_FLD_ID PARENT_TM_ATRB_FLD_ID, HWM_TM_ATRB_FLDS_VL.GLOBAL_TM_ATRB_FLD_ID GLOBAL_TM_ATRB_FLD_ID, HWM_TM_ATRB_FLDS_VL.VALUE_LOCATION VALUE_LOCATION, HWM_TM_ATRB_FLDS_VL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, HWM_TM_ATRB_FLDS_VL.ALLOWED_SCOPE ALLOWED_SCOPE, HWM_TM_ATRB_FLDS_VL.MANDATORY_FOR_TCSMRS MANDATORY_FOR_TCSMRS, HWM_TM_ATRB_FLDS_VL.DISPLAY_NAME DISPLAY_NAME, HWM_TM_ATRB_FLDS_VL.DESCRIPTION DESCRIPTION, HWM_TM_ATRB_FLDS_VL.ATTRIBUTE_TYPE ATTRIBUTE_TYPE, HWM_TM_ATRB_FLDS_VL.ATTRIBUTE_GROUP ATTRIBUTE_GROUP, HWM_TM_ATRB_FLDS_VL.VALUE_SET_ID VALUE_SET_ID, HWM_TM_ATRB_FLDS_VL.COMP_DISP_CODE COMP_DISP_CODE, HWM_TM_ATRB_FLDS_VL.CREATED_BY CREATED_BY, HWM_TM_ATRB_FLDS_VL.CREATION_DATE CREATION_DATE, HWM_TM_ATRB_FLDS_VL.LAST_UPDATE_DATE LAST_UPDATE_DATE, HWM_TM_ATRB_FLDS_VL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HWM_TM_ATRB_FLDS_VL.LAST_UPDATED_BY LAST_UPDATED_BY FROM HWM_TM_REC, HWM_TM_ATRB_FLDS_VL WHERE NVL(HWM_TM_REC.DELETE_FLAG, 'N') = 'N'