HWM_TM_REP_WORK_TM_CORE

Details

Schema: FUSION
Object owner: HWM
Object type: VIEW

Columns

Name
PERSON_ID ASSIGNMENT_ID MEASURE UNIT_OF_MEASURE START_TIME STOP_TIME TM_REC_ID TM_REC_VERSION DAY_GRP_TYPE_ID STATUS_DATE_FROM STATUS_DATE_TO STATUS_VALUE TM_STATUS_DEF_ID ORIG_TM_REC_ID ORIG_TM_REC_VERSION

Name

PERSON_ID

ASSIGNMENT_ID

MEASURE

UNIT_OF_MEASURE

START_TIME

STOP_TIME

TM_REC_ID

TM_REC_VERSION

DAY_GRP_TYPE_ID

STATUS_DATE_FROM

STATUS_DATE_TO

STATUS_VALUE

TM_STATUS_DEF_ID

ORIG_TM_REC_ID

ORIG_TM_REC_VERSION

Query

SQL_Statement
SELECT TIME_RECORDS.RESOURCE_ID as PERSON_ID , TIME_RECORDS.SUBRESOURCE_ID as ASSIGNMENT_ID , TIME_RECORDS.MEASURE , TIME_RECORDS.UNIT_OF_MEASURE , TIME_RECORDS.START_TIME , TIME_RECORDS.STOP_TIME , TIME_RECORDS.TM_REC_ID , TIME_RECORDS.TM_REC_VERSION , DAY_REC.GRP_TYPE_ID DAY_GRP_TYPE_ID , STATUS_VAL.DATE_FROM as STATUS_DATE_FROM , STATUS_VAL.DATE_TO as STATUS_DATE_TO , STATUS_VAL.STATUS_VALUE ,STATUS_VAL.TM_STATUS_DEF_ID , TIME_RECORDS.ORIG_TM_REC_ID as ORIG_TM_REC_ID , TIME_RECORDS.ORIG_TM_REC_VERSION as ORIG_TM_REC_VERSION from HWM_TM_REC TIME_RECORDS, HWM_TM_REC_GRP_USAGES GROUP_USAGES, HWM_TM_REC_GRP TIME_CARD, HWM_TM_STATUSES STATUS_VAL , HWM_TM_REC_GRP DAY_REC where GROUP_USAGES.TM_REC_ID = TIME_RECORDS.TM_REC_ID AND GROUP_USAGES.TM_REC_VERSION = TIME_RECORDS.TM_REC_VERSION AND GROUP_USAGES.LATEST_VERSION = 'Y' AND DAY_REC.TM_REC_GRP_ID = GROUP_USAGES.TM_REC_GRP_ID AND DAY_REC.TM_REC_GRP_VERSION = GROUP_USAGES.TM_REC_GRP_VERSION AND (NVL(DAY_REC.DELETE_FLAG,'N')) = 'N' AND DAY_REC.LATEST_VERSION = 'Y' AND TIME_CARD.TM_REC_GRP_ID = DAY_REC.PARENT_TM_REC_GRP_ID AND TIME_CARD.TM_REC_GRP_VERSION = DAY_REC.PARENT_TM_REC_GRP_VERSION AND (NVL(TIME_CARD.DELETE_FLAG,'N')) = 'N' AND TIME_CARD.LATEST_VERSION = 'Y' AND ( ( DAY_REC.GRP_TYPE_ID = '101' AND TIME_CARD.TM_REC_GRP_ID = STATUS_VAL.TM_BLDG_BLK_ID AND TIME_CARD.TM_REC_GRP_VERSION = STATUS_VAL.TM_BLDG_BLK_VERSION ) OR ( DAY_REC.GRP_TYPE_ID = '201' AND TIME_CARD.ORIG_TM_REC_GRP_ID = STATUS_VAL.TM_BLDG_BLK_ID AND TIME_CARD.ORIG_TM_REC_GRP_VERSION = STATUS_VAL.TM_BLDG_BLK_VERSION ) ) AND TIME_RECORDS.RESOURCE_TYPE = 'PERSON'

SQL_Statement

SELECT TIME_RECORDS.RESOURCE_ID as PERSON_ID

, TIME_RECORDS.SUBRESOURCE_ID as ASSIGNMENT_ID

, TIME_RECORDS.MEASURE

, TIME_RECORDS.UNIT_OF_MEASURE

, TIME_RECORDS.START_TIME

, TIME_RECORDS.STOP_TIME

, TIME_RECORDS.TM_REC_ID

, TIME_RECORDS.TM_REC_VERSION

, DAY_REC.GRP_TYPE_ID DAY_GRP_TYPE_ID

, STATUS_VAL.DATE_FROM as STATUS_DATE_FROM

, STATUS_VAL.DATE_TO as STATUS_DATE_TO

, STATUS_VAL.STATUS_VALUE

,STATUS_VAL.TM_STATUS_DEF_ID

, TIME_RECORDS.ORIG_TM_REC_ID as ORIG_TM_REC_ID

, TIME_RECORDS.ORIG_TM_REC_VERSION as ORIG_TM_REC_VERSION

from HWM_TM_REC TIME_RECORDS,

HWM_TM_REC_GRP_USAGES GROUP_USAGES,

HWM_TM_REC_GRP TIME_CARD,

HWM_TM_STATUSES STATUS_VAL ,

HWM_TM_REC_GRP DAY_REC

where GROUP_USAGES.TM_REC_ID = TIME_RECORDS.TM_REC_ID

AND GROUP_USAGES.TM_REC_VERSION = TIME_RECORDS.TM_REC_VERSION

AND GROUP_USAGES.LATEST_VERSION = 'Y'

AND DAY_REC.TM_REC_GRP_ID = GROUP_USAGES.TM_REC_GRP_ID

AND DAY_REC.TM_REC_GRP_VERSION = GROUP_USAGES.TM_REC_GRP_VERSION

AND (NVL(DAY_REC.DELETE_FLAG,'N')) = 'N'

AND DAY_REC.LATEST_VERSION = 'Y'

AND TIME_CARD.TM_REC_GRP_ID = DAY_REC.PARENT_TM_REC_GRP_ID

AND TIME_CARD.TM_REC_GRP_VERSION = DAY_REC.PARENT_TM_REC_GRP_VERSION

AND (NVL(TIME_CARD.DELETE_FLAG,'N')) = 'N'

AND TIME_CARD.LATEST_VERSION = 'Y'

AND ( ( DAY_REC.GRP_TYPE_ID = '101'

AND TIME_CARD.TM_REC_GRP_ID = STATUS_VAL.TM_BLDG_BLK_ID

AND TIME_CARD.TM_REC_GRP_VERSION = STATUS_VAL.TM_BLDG_BLK_VERSION )

OR ( DAY_REC.GRP_TYPE_ID = '201'

AND TIME_CARD.ORIG_TM_REC_GRP_ID = STATUS_VAL.TM_BLDG_BLK_ID

AND TIME_CARD.ORIG_TM_REC_GRP_VERSION = STATUS_VAL.TM_BLDG_BLK_VERSION )

)

AND TIME_RECORDS.RESOURCE_TYPE = 'PERSON'