HWM_EXT_ATTRB_HDR_DAY

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_GRP_ID TM_REC_GRP_VERSION GRP_TYPE_ID START_TIME STOP_TIME PARENT_TM_REC_GRP_ID PARENT_TM_REC_GRP_VERSION LAYER_CODE 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 TM_REP_ATRB_ID MASTER_ATTRIBUTE_ID ATTRIBUTE_CATEGORY MASTER_CATEGORY ATTRIBUTE_ROW_TYPE_ID TIME_REPORTER_ID CONSOLIDATE_FLAG DATA_SET_ID 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_DATE21 ATTRIBUTE_DATE22 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_TIMESTAMP12 ATTRIBUTE_TIMESTAMP13 ATTRIBUTE_TIMESTAMP14 ATTRIBUTE_TIMESTAMP15 ATTRIBUTE_TIMESTAMP11 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

Name

TM_REP_ATRB_USAGE_ID

USAGES_TYPE

USAGES_SOURCE_ID

USAGES_SOURCE_VERSION

USAGES_SOURCE_GRP_LEVEL

TM_REC_GRP_ID

TM_REC_GRP_VERSION

GRP_TYPE_ID

START_TIME

STOP_TIME

PARENT_TM_REC_GRP_ID

PARENT_TM_REC_GRP_VERSION

LAYER_CODE

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

TM_REP_ATRB_ID

MASTER_ATTRIBUTE_ID

ATTRIBUTE_CATEGORY

MASTER_CATEGORY

ATTRIBUTE_ROW_TYPE_ID

TIME_REPORTER_ID

CONSOLIDATE_FLAG

DATA_SET_ID

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_DATE21

ATTRIBUTE_DATE22

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_TIMESTAMP12

ATTRIBUTE_TIMESTAMP13

ATTRIBUTE_TIMESTAMP14

ATTRIBUTE_TIMESTAMP15

ATTRIBUTE_TIMESTAMP11

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 , tc.TM_REC_GRP_ID , tc.TM_REC_GRP_VERSION , tc.GRP_TYPE_ID , tc.START_TIME , tc.STOP_TIME , tc.PARENT_TM_REC_GRP_ID , tc.PARENT_TM_REC_GRP_VERSION , tc.LAYER_CODE , tc.DATE_FROM , tc.DATE_TO ,trunc(tc.START_TIME) START_TIME_TRUNC ,trunc(tc.STOP_TIME) STOP_TIME_TRUNC ,trunc(tc.DATE_FROM) DATE_FROM_TRUNC ,trunc(tc.DATE_TO) DATE_TO_TRUNC , tc.TCSMR_SET_ID , tc.TCSMR_CONFIG_SET_ID , tc.RESOURCE_ID , tc.RESOURCE_TYPE , tc.SUBRESOURCE_ID ,hgt.name as grp_type_name , atr. TM_REP_ATRB_ID , atr. MASTER_ATTRIBUTE_ID , atr. ATTRIBUTE_CATEGORY , atr. MASTER_CATEGORY , atr. ATTRIBUTE_ROW_TYPE_ID , atr. TIME_REPORTER_ID , atr. CONSOLIDATE_FLAG , atr. DATA_SET_ID ,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_DATE21 ,atr. ATTRIBUTE_DATE22 ,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_TIMESTAMP12 ,atr. ATTRIBUTE_TIMESTAMP13 ,atr. ATTRIBUTE_TIMESTAMP14 ,atr. ATTRIBUTE_TIMESTAMP15 ,atr. ATTRIBUTE_TIMESTAMP11 ,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_GRP tc ,hwm_grp_type hgt WHERE atr.TM_REP_ATRB_ID = ausg.TM_REP_ATRB_ID AND USAGES_TYPE = 'TIME_RECORD_GROUP' AND ausg.USAGES_SOURCE_ID = tc.TM_REC_GRP_ID AND ausg.USAGES_SOURCE_VERSION = tc.TM_REC_GRP_VERSION AND ausg.LATEST_VERSION = 'Y' AND tc.grp_type_id = hgt.grp_type_id

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

, tc.TM_REC_GRP_ID

, tc.TM_REC_GRP_VERSION

, tc.GRP_TYPE_ID

, tc.START_TIME

, tc.STOP_TIME

, tc.PARENT_TM_REC_GRP_ID

, tc.PARENT_TM_REC_GRP_VERSION

, tc.LAYER_CODE

, tc.DATE_FROM

, tc.DATE_TO

,trunc(tc.START_TIME) START_TIME_TRUNC

,trunc(tc.STOP_TIME) STOP_TIME_TRUNC

,trunc(tc.DATE_FROM) DATE_FROM_TRUNC

,trunc(tc.DATE_TO) DATE_TO_TRUNC

, tc.TCSMR_SET_ID

, tc.TCSMR_CONFIG_SET_ID

, tc.RESOURCE_ID

, tc.RESOURCE_TYPE

, tc.SUBRESOURCE_ID

,hgt.name as grp_type_name

, atr. TM_REP_ATRB_ID

, atr. MASTER_ATTRIBUTE_ID

, atr. ATTRIBUTE_CATEGORY

, atr. MASTER_CATEGORY

, atr. ATTRIBUTE_ROW_TYPE_ID

, atr. TIME_REPORTER_ID

, atr. CONSOLIDATE_FLAG

, atr. DATA_SET_ID

,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_DATE21 ,atr. ATTRIBUTE_DATE22 ,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_TIMESTAMP12 ,atr. ATTRIBUTE_TIMESTAMP13 ,atr. ATTRIBUTE_TIMESTAMP14 ,atr. ATTRIBUTE_TIMESTAMP15 ,atr. ATTRIBUTE_TIMESTAMP11 ,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_GRP tc ,hwm_grp_type hgt

WHERE atr.TM_REP_ATRB_ID = ausg.TM_REP_ATRB_ID

AND USAGES_TYPE = 'TIME_RECORD_GROUP'

AND ausg.USAGES_SOURCE_ID = tc.TM_REC_GRP_ID

AND ausg.USAGES_SOURCE_VERSION = tc.TM_REC_GRP_VERSION

AND ausg.LATEST_VERSION = 'Y'

AND tc.grp_type_id = hgt.grp_type_id