HWM_EXT_ATTRB_DETAIL_V

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name

TM_REP_ATRB_USAGE_ID USAGES_TYPE USAGES_SOURCE_ID USAGES_SOURCE_VERSION USAGES_SOURCE_GRP_LEVEL TM_REC_ID TM_REC_VERSION TM_REC_TYPE ACTIVITY_TYPE START_TIME STOP_TIME DATE_FROM DATE_TO START_TIME_TRUNC STOP_TIME_TRUNC DATE_FROM_TRUNC DATE_TO_TRUNC TCSMR_SET_ID TCSMR_CONFIG_SET_ID RESOURCE_ID RESOURCE_TYPE SUBRESOURCE_ID GRP_TYPE_NAME LAYER_CODE GRP_TYPE_ID PARENT_TM_REC_GRP_ID PARENT_TM_REC_GRP_VERSION TM_REC_GRP_ID TM_REC_GRP_VERSION TM_REP_ATRB_ID MASTER_ATTRIBUTE_ID ATTRIBUTE_ROW_TYPE_ID TIME_REPORTER_ID CONSOLIDATE_FLAG DATA_SET_ID MASTER_CATEGORY ATTRIBUTE_CATEGORY ATTRIBUTE_VARCHAR1 ATTRIBUTE_VARCHAR2 ATTRIBUTE_VARCHAR3 ATTRIBUTE_VARCHAR4 ATTRIBUTE_VARCHAR5 ATTRIBUTE_VARCHAR6 ATTRIBUTE_VARCHAR7 ATTRIBUTE_VARCHAR8 ATTRIBUTE_VARCHAR9 ATTRIBUTE_VARCHAR10 ATTRIBUTE_VARCHAR11 ATTRIBUTE_VARCHAR12 ATTRIBUTE_VARCHAR13 ATTRIBUTE_VARCHAR14 ATTRIBUTE_VARCHAR15 ATTRIBUTE_VARCHAR16 ATTRIBUTE_VARCHAR17 ATTRIBUTE_VARCHAR18 ATTRIBUTE_VARCHAR19 ATTRIBUTE_VARCHAR20 ATTRIBUTE_VARCHAR21 ATTRIBUTE_VARCHAR22 ATTRIBUTE_VARCHAR23 ATTRIBUTE_VARCHAR24 ATTRIBUTE_VARCHAR25 ATTRIBUTE_VARCHAR26 ATTRIBUTE_VARCHAR27 ATTRIBUTE_VARCHAR28 ATTRIBUTE_VARCHAR29 ATTRIBUTE_VARCHAR30 ATTRIBUTE_VARCHAR31 ATTRIBUTE_VARCHAR32 ATTRIBUTE_VARCHAR33 ATTRIBUTE_VARCHAR34 ATTRIBUTE_VARCHAR35 ATTRIBUTE_VARCHAR36 ATTRIBUTE_VARCHAR37 ATTRIBUTE_VARCHAR38 ATTRIBUTE_VARCHAR39 ATTRIBUTE_VARCHAR40 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER15 ATTRIBUTE_NUMBER16 ATTRIBUTE_NUMBER17 ATTRIBUTE_NUMBER18 ATTRIBUTE_NUMBER19 ATTRIBUTE_NUMBER20 ATTRIBUTE_NUMBER22 ATTRIBUTE_NUMBER21 ATTRIBUTE_NUMBER23 ATTRIBUTE_NUMBER24 ATTRIBUTE_NUMBER25 ATTRIBUTE_NUMBER26 ATTRIBUTE_NUMBER27 ATTRIBUTE_NUMBER28 ATTRIBUTE_NUMBER29 ATTRIBUTE_NUMBER30 ATTRIBUTE_NUMBER31 ATTRIBUTE_NUMBER32 ATTRIBUTE_NUMBER33 ATTRIBUTE_NUMBER34 ATTRIBUTE_NUMBER35 ATTRIBUTE_NUMBER36 ATTRIBUTE_NUMBER37 ATTRIBUTE_NUMBER38 ATTRIBUTE_NUMBER39 ATTRIBUTE_NUMBER40 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_DATE11 ATTRIBUTE_DATE12 ATTRIBUTE_DATE13 ATTRIBUTE_DATE14 ATTRIBUTE_DATE15 ATTRIBUTE_DATE16 ATTRIBUTE_DATE17 ATTRIBUTE_DATE18 ATTRIBUTE_DATE19 ATTRIBUTE_DATE20 ATTRIBUTE_DATE22 ATTRIBUTE_DATE21 ATTRIBUTE_DATE23 ATTRIBUTE_DATE24 ATTRIBUTE_DATE25 ATTRIBUTE_DATE26 ATTRIBUTE_DATE27 ATTRIBUTE_DATE28 ATTRIBUTE_DATE29 ATTRIBUTE_DATE30 ATTRIBUTE_DATE31 ATTRIBUTE_DATE32 ATTRIBUTE_DATE33 ATTRIBUTE_DATE34 ATTRIBUTE_DATE35 ATTRIBUTE_DATE36 ATTRIBUTE_DATE37 ATTRIBUTE_DATE38 ATTRIBUTE_DATE39 ATTRIBUTE_DATE40 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP10 ATTRIBUTE_TIMESTAMP11 ATTRIBUTE_TIMESTAMP12 ATTRIBUTE_TIMESTAMP13 ATTRIBUTE_TIMESTAMP14 ATTRIBUTE_TIMESTAMP15 ATTRIBUTE_TIMESTAMP16 ATTRIBUTE_TIMESTAMP17 ATTRIBUTE_TIMESTAMP18 ATTRIBUTE_TIMESTAMP19 ATTRIBUTE_TIMESTAMP20 ATTRIBUTE_TIMESTAMP24 ATTRIBUTE_TIMESTAMP21 ATTRIBUTE_TIMESTAMP22 ATTRIBUTE_TIMESTAMP23 ATTRIBUTE_TIMESTAMP25 ATTRIBUTE_TIMESTAMP26 ATTRIBUTE_TIMESTAMP27 ATTRIBUTE_TIMESTAMP28 ATTRIBUTE_TIMESTAMP29 ATTRIBUTE_TIMESTAMP30 ATTRIBUTE_TIMESTAMP31 ATTRIBUTE_TIMESTAMP32 ATTRIBUTE_TIMESTAMP33 ATTRIBUTE_TIMESTAMP34 ATTRIBUTE_TIMESTAMP35 ATTRIBUTE_TIMESTAMP36 ATTRIBUTE_TIMESTAMP37 ATTRIBUTE_TIMESTAMP38 ATTRIBUTE_TIMESTAMP39 ATTRIBUTE_TIMESTAMP40 OBJECT_VERSION_NUMBER ENTERPRISE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT ausg.TM_REP_ATRB_USAGE_ID ,ausg.USAGES_TYPE ,ausg.USAGES_SOURCE_ID ,ausg.USAGES_SOURCE_VERSION ,ausg.USAGES_SOURCE_GRP_LEVEL , dtl.TM_REC_ID , dtl.TM_REC_VERSION , dtl.TM_REC_TYPE , dtl.ACTIVITY_TYPE , dtl.START_TIME , dtl.STOP_TIME , dtl.DATE_FROM , dtl.DATE_TO ,trunc(dtl.START_TIME) START_TIME_TRUNC ,trunc(dtl.STOP_TIME) STOP_TIME_TRUNC ,trunc(dtl.DATE_FROM) DATE_FROM_TRUNC ,trunc(dtl.DATE_TO) DATE_TO_TRUNC , dtl.TCSMR_SET_ID , dtl.TCSMR_CONFIG_SET_ID , dtl.RESOURCE_ID , dtl.RESOURCE_TYPE , dtl.SUBRESOURCE_ID ,hgt.name as grp_type_name , hdv.LAYER_CODE ,hdv.GRP_TYPE_ID ,hdv.PARENT_TM_REC_GRP_ID ,hdv.PARENT_TM_REC_GRP_VERSION ,hdv.TM_REC_GRP_ID ,hdv.TM_REC_GRP_VERSION , atr.TM_REP_ATRB_ID ,atr.MASTER_ATTRIBUTE_ID ,atr.ATTRIBUTE_ROW_TYPE_ID ,atr.TIME_REPORTER_ID ,atr.CONSOLIDATE_FLAG ,atr.DATA_SET_ID ,atr.MASTER_CATEGORY ,atr.ATTRIBUTE_CATEGORY ,atr.ATTRIBUTE_VARCHAR1 ,atr.ATTRIBUTE_VARCHAR2 ,atr.ATTRIBUTE_VARCHAR3 ,atr.ATTRIBUTE_VARCHAR4 ,atr.ATTRIBUTE_VARCHAR5 ,atr.ATTRIBUTE_VARCHAR6 ,atr.ATTRIBUTE_VARCHAR7 ,atr.ATTRIBUTE_VARCHAR8 ,atr.ATTRIBUTE_VARCHAR9 ,atr.ATTRIBUTE_VARCHAR10 ,atr.ATTRIBUTE_VARCHAR11 ,atr.ATTRIBUTE_VARCHAR12 ,atr.ATTRIBUTE_VARCHAR13 ,atr.ATTRIBUTE_VARCHAR14 ,atr.ATTRIBUTE_VARCHAR15 ,atr.ATTRIBUTE_VARCHAR16 ,atr.ATTRIBUTE_VARCHAR17 ,atr.ATTRIBUTE_VARCHAR18 ,atr.ATTRIBUTE_VARCHAR19 ,atr.ATTRIBUTE_VARCHAR20 ,atr.ATTRIBUTE_VARCHAR21 ,atr.ATTRIBUTE_VARCHAR22 ,atr.ATTRIBUTE_VARCHAR23 ,atr.ATTRIBUTE_VARCHAR24 ,atr.ATTRIBUTE_VARCHAR25 ,atr.ATTRIBUTE_VARCHAR26 ,atr.ATTRIBUTE_VARCHAR27 ,atr.ATTRIBUTE_VARCHAR28 ,atr.ATTRIBUTE_VARCHAR29 ,atr.ATTRIBUTE_VARCHAR30 ,atr.ATTRIBUTE_VARCHAR31 ,atr.ATTRIBUTE_VARCHAR32 ,atr.ATTRIBUTE_VARCHAR33 ,atr.ATTRIBUTE_VARCHAR34 ,atr.ATTRIBUTE_VARCHAR35 ,atr.ATTRIBUTE_VARCHAR36 ,atr.ATTRIBUTE_VARCHAR37 ,atr.ATTRIBUTE_VARCHAR38 ,atr.ATTRIBUTE_VARCHAR39 ,atr.ATTRIBUTE_VARCHAR40 ,atr.ATTRIBUTE_NUMBER1 ,atr.ATTRIBUTE_NUMBER2 ,atr.ATTRIBUTE_NUMBER3 ,atr.ATTRIBUTE_NUMBER4 ,atr.ATTRIBUTE_NUMBER5 ,atr.ATTRIBUTE_NUMBER6 ,atr.ATTRIBUTE_NUMBER7 ,atr.ATTRIBUTE_NUMBER8 ,atr.ATTRIBUTE_NUMBER9 ,atr.ATTRIBUTE_NUMBER10 ,atr.ATTRIBUTE_NUMBER11 ,atr.ATTRIBUTE_NUMBER12 ,atr.ATTRIBUTE_NUMBER13 ,atr.ATTRIBUTE_NUMBER14 ,atr.ATTRIBUTE_NUMBER15 ,atr.ATTRIBUTE_NUMBER16 ,atr.ATTRIBUTE_NUMBER17 ,atr.ATTRIBUTE_NUMBER18 ,atr.ATTRIBUTE_NUMBER19 ,atr.ATTRIBUTE_NUMBER20 ,atr.ATTRIBUTE_NUMBER22 ,atr.ATTRIBUTE_NUMBER21 ,atr.ATTRIBUTE_NUMBER23 ,atr.ATTRIBUTE_NUMBER24 ,atr.ATTRIBUTE_NUMBER25 ,atr.ATTRIBUTE_NUMBER26 ,atr.ATTRIBUTE_NUMBER27 ,atr.ATTRIBUTE_NUMBER28 ,atr.ATTRIBUTE_NUMBER29 ,atr.ATTRIBUTE_NUMBER30 ,atr.ATTRIBUTE_NUMBER31 ,atr.ATTRIBUTE_NUMBER32 ,atr.ATTRIBUTE_NUMBER33 ,atr.ATTRIBUTE_NUMBER34 ,atr.ATTRIBUTE_NUMBER35 ,atr.ATTRIBUTE_NUMBER36 ,atr.ATTRIBUTE_NUMBER37 ,atr.ATTRIBUTE_NUMBER38 ,atr.ATTRIBUTE_NUMBER39 ,atr.ATTRIBUTE_NUMBER40 ,atr.ATTRIBUTE_DATE1 ,atr.ATTRIBUTE_DATE2 ,atr.ATTRIBUTE_DATE3 ,atr.ATTRIBUTE_DATE4 ,atr.ATTRIBUTE_DATE5 ,atr.ATTRIBUTE_DATE6 ,atr.ATTRIBUTE_DATE7 ,atr.ATTRIBUTE_DATE8 ,atr.ATTRIBUTE_DATE9 ,atr.ATTRIBUTE_DATE10 ,atr.ATTRIBUTE_DATE11 ,atr.ATTRIBUTE_DATE12 ,atr.ATTRIBUTE_DATE13 ,atr.ATTRIBUTE_DATE14 ,atr.ATTRIBUTE_DATE15 ,atr.ATTRIBUTE_DATE16 ,atr.ATTRIBUTE_DATE17 ,atr.ATTRIBUTE_DATE18 ,atr.ATTRIBUTE_DATE19 ,atr.ATTRIBUTE_DATE20 ,atr.ATTRIBUTE_DATE22 ,atr.ATTRIBUTE_DATE21 ,atr.ATTRIBUTE_DATE23 ,atr.ATTRIBUTE_DATE24 ,atr.ATTRIBUTE_DATE25 ,atr.ATTRIBUTE_DATE26 ,atr.ATTRIBUTE_DATE27 ,atr.ATTRIBUTE_DATE28 ,atr.ATTRIBUTE_DATE29 ,atr.ATTRIBUTE_DATE30 ,atr.ATTRIBUTE_DATE31 ,atr.ATTRIBUTE_DATE32 ,atr.ATTRIBUTE_DATE33 ,atr.ATTRIBUTE_DATE34 ,atr.ATTRIBUTE_DATE35 ,atr.ATTRIBUTE_DATE36 ,atr.ATTRIBUTE_DATE37 ,atr.ATTRIBUTE_DATE38 ,atr.ATTRIBUTE_DATE39 ,atr.ATTRIBUTE_DATE40 ,atr.ATTRIBUTE_TIMESTAMP1 ,atr.ATTRIBUTE_TIMESTAMP2 ,atr.ATTRIBUTE_TIMESTAMP3 ,atr.ATTRIBUTE_TIMESTAMP4 ,atr.ATTRIBUTE_TIMESTAMP5 ,atr.ATTRIBUTE_TIMESTAMP6 ,atr.ATTRIBUTE_TIMESTAMP7 ,atr.ATTRIBUTE_TIMESTAMP8 ,atr.ATTRIBUTE_TIMESTAMP9 ,atr.ATTRIBUTE_TIMESTAMP10 ,atr.ATTRIBUTE_TIMESTAMP11 ,atr.ATTRIBUTE_TIMESTAMP12 ,atr.ATTRIBUTE_TIMESTAMP13 ,atr.ATTRIBUTE_TIMESTAMP14 ,atr.ATTRIBUTE_TIMESTAMP15 ,atr.ATTRIBUTE_TIMESTAMP16 ,atr.ATTRIBUTE_TIMESTAMP17 ,atr.ATTRIBUTE_TIMESTAMP18 ,atr.ATTRIBUTE_TIMESTAMP19 ,atr.ATTRIBUTE_TIMESTAMP20 ,atr.ATTRIBUTE_TIMESTAMP24 ,atr.ATTRIBUTE_TIMESTAMP21 ,atr.ATTRIBUTE_TIMESTAMP22 ,atr.ATTRIBUTE_TIMESTAMP23 ,atr.ATTRIBUTE_TIMESTAMP25 ,atr.ATTRIBUTE_TIMESTAMP26 ,atr.ATTRIBUTE_TIMESTAMP27 ,atr.ATTRIBUTE_TIMESTAMP28 ,atr.ATTRIBUTE_TIMESTAMP29 ,atr.ATTRIBUTE_TIMESTAMP30 ,atr.ATTRIBUTE_TIMESTAMP31 ,atr.ATTRIBUTE_TIMESTAMP32 ,atr.ATTRIBUTE_TIMESTAMP33 ,atr.ATTRIBUTE_TIMESTAMP34 ,atr.ATTRIBUTE_TIMESTAMP35 ,atr.ATTRIBUTE_TIMESTAMP36 ,atr.ATTRIBUTE_TIMESTAMP37 ,atr.ATTRIBUTE_TIMESTAMP38 ,atr.ATTRIBUTE_TIMESTAMP39 ,atr.ATTRIBUTE_TIMESTAMP40 ,atr.OBJECT_VERSION_NUMBER ,atr.ENTERPRISE_ID ,atr.CREATED_BY ,atr.CREATION_DATE ,atr.LAST_UPDATED_BY ,atr.LAST_UPDATE_DATE ,atr.LAST_UPDATE_LOGIN FROM HWM_TM_REP_ATRBS atr , HWM_TM_REP_ATRB_USAGES ausg , HWM_TM_REC dtl, HWM_TM_REC_GRP_USAGES usg , HWM_TM_REC_GRP hdv ,hwm_grp_type hgt WHERE atr.TM_REP_ATRB_ID = ausg.TM_REP_ATRB_ID AND ausg.USAGES_SOURCE_ID = dtl.TM_REC_ID AND ausg.USAGES_SOURCE_VERSION = dtl.TM_REC_VERSION AND dtl.TM_REC_ID = USG.TM_REC_ID AND dtl.TM_REC_VERSION = USG.TM_REC_VERSION AND usg.TM_REC_GRP_ID = hdv.TM_REC_GRP_ID AND usg.TM_REC_GRP_VERSION = hdv.TM_REC_GRP_VERSION AND NVL(dtl.DELETE_FLAG, 'N') <> 'Y' AND USG.LATEST_VERSION = 'Y' AND hdv.grp_type_id = hgt.grp_type_id