HWM_TM_RPT_ENTRY

Details

Schema: FUSION
Object owner: HWM
Object type: VIEW

Columns

Name
TC_TM_REC_GRP_ID TC_TM_REC_GRP_VERSION TC_GRP_TYPE_ID TC_DELETE_FLAG TC_LATEST_VERSION TC_START_TIME TC_STOP_TIME TC_START_DATE TC_STOP_DATE TC_START_TIMEZONE_CODE TC_STOP_TIMEZONE_CODE TC_START_GMT_OFFSET TC_STOP_GMT_OFFSET TC_LAYER_CODE TC_COMMIT_TIMESTAMP TC_COMMENT_TEXT TC_DATE_FROM TC_DATE_TO TC_CREATED_BY TC_CREATION_DATE TC_LAST_UPDATED_BY TC_LAST_UPDATE_DATE TC_LAST_UPDATE_LOGIN DAY_TM_REC_GRP_ID DAY_TM_REC_GRP_VERSION DAY_GRP_TYPE_ID DAY_DELETE_FLAG DAY_LATEST_VERSION DAY_START_TIME DAY_STOP_TIME DAY_START_TIMEZONE_CODE DAY_STOP_TIMEZONE_CODE DAY_START_GMT_OFFSET DAY_STOP_GMT_OFFSET DAY_LAYER_CODE DAY_COMMENT_TEXT DAY_DATE_FROM DAY_DATE_TO DAY_CREATED_BY DAY_CREATION_DATE DAY_LAST_UPDATED_BY DAY_LAST_UPDATE_DATE DAY_LAST_UPDATE_LOGIN TE_TM_REC_ID TE_TM_REC_VERSION TE_DELETE_FLAG TE_LATEST_VERSION TE_START_TIME TE_STOP_TIME TE_START_TIMEZONE_CODE TE_STOP_TIMEZONE_CODE TE_START_GMT_OFFSET TE_STOP_GMT_OFFSET TE_TM_REC_TYPE TE_LAYER_CODE TE_COMMENT_TEXT TE_UNIT_OF_MEASURE TE_MEASURE TE_MEASURE_LABOR TE_MEASURE_ABSENCE RESOURCE_ID TE_SUBRESOURCE_ID TE_TIME_REPORTER_ID TE_TCSMR_SET_ID TE_TCSMR_CONFIG_SET_ID TE_ACTIVITY_IN_ID TE_ACTIVITY_OUT_ID TE_DATE_FROM TE_DATE_TO TE_CREATED_BY TE_CREATION_DATE TE_LAST_UPDATED_BY TE_LAST_UPDATE_DATE TE_LAST_UPDATE_LOGIN ANC_TM_REC_GRP_ID ANC_TM_REC_GRP_VERSION ANC_GRP_TYPE_ID ANC_DELETE_FLAG ANC_LATEST_VERSION

Name

TC_TM_REC_GRP_ID

TC_TM_REC_GRP_VERSION

TC_GRP_TYPE_ID

TC_DELETE_FLAG

TC_LATEST_VERSION

TC_START_TIME

TC_STOP_TIME

TC_START_DATE

TC_STOP_DATE

TC_START_TIMEZONE_CODE

TC_STOP_TIMEZONE_CODE

TC_START_GMT_OFFSET

TC_STOP_GMT_OFFSET

TC_LAYER_CODE

TC_COMMIT_TIMESTAMP

TC_COMMENT_TEXT

TC_DATE_FROM

TC_DATE_TO

TC_CREATED_BY

TC_CREATION_DATE

TC_LAST_UPDATED_BY

TC_LAST_UPDATE_DATE

TC_LAST_UPDATE_LOGIN

DAY_TM_REC_GRP_ID

DAY_TM_REC_GRP_VERSION

DAY_GRP_TYPE_ID

DAY_DELETE_FLAG

DAY_LATEST_VERSION

DAY_START_TIME

DAY_STOP_TIME

DAY_START_TIMEZONE_CODE

DAY_STOP_TIMEZONE_CODE

DAY_START_GMT_OFFSET

DAY_STOP_GMT_OFFSET

DAY_LAYER_CODE

DAY_COMMENT_TEXT

DAY_DATE_FROM

DAY_DATE_TO

DAY_CREATED_BY

DAY_CREATION_DATE

DAY_LAST_UPDATED_BY

DAY_LAST_UPDATE_DATE

DAY_LAST_UPDATE_LOGIN

TE_TM_REC_ID

TE_TM_REC_VERSION

TE_DELETE_FLAG

TE_LATEST_VERSION

TE_START_TIME

TE_STOP_TIME

TE_START_TIMEZONE_CODE

TE_STOP_TIMEZONE_CODE

TE_START_GMT_OFFSET

TE_STOP_GMT_OFFSET

TE_TM_REC_TYPE

TE_LAYER_CODE

TE_COMMENT_TEXT

TE_UNIT_OF_MEASURE

TE_MEASURE

TE_MEASURE_LABOR

TE_MEASURE_ABSENCE

RESOURCE_ID

TE_SUBRESOURCE_ID

TE_TIME_REPORTER_ID

TE_TCSMR_SET_ID

TE_TCSMR_CONFIG_SET_ID

TE_ACTIVITY_IN_ID

TE_ACTIVITY_OUT_ID

TE_DATE_FROM

TE_DATE_TO

TE_CREATED_BY

TE_CREATION_DATE

TE_LAST_UPDATED_BY

TE_LAST_UPDATE_DATE

TE_LAST_UPDATE_LOGIN

ANC_TM_REC_GRP_ID

ANC_TM_REC_GRP_VERSION

ANC_GRP_TYPE_ID

ANC_DELETE_FLAG

ANC_LATEST_VERSION

Query

SQL_Statement
SELECT TimeCardTimeRecordGroupPEO.TM_REC_GRP_ID AS TC_TM_REC_GRP_ID, TimeCardTimeRecordGroupPEO.TM_REC_GRP_VERSION AS TC_TM_REC_GRP_VERSION, TimeCardTimeRecordGroupPEO.GRP_TYPE_ID AS TC_GRP_TYPE_ID, NVL(TimeCardTimeRecordGroupPEO.DELETE_FLAG,'N') AS TC_DELETE_FLAG, TimeCardTimeRecordGroupPEO.LATEST_VERSION AS TC_LATEST_VERSION, TimeCardTimeRecordGroupPEO.START_TIME AS TC_START_TIME, TimeCardTimeRecordGroupPEO.STOP_TIME AS TC_STOP_TIME, trunc(TimeCardTimeRecordGroupPEO.START_TIME) AS TC_START_DATE, trunc(TimeCardTimeRecordGroupPEO.STOP_TIME) AS TC_STOP_DATE, TimeCardTimeRecordGroupPEO.START_TIMEZONE_CODE AS TC_START_TIMEZONE_CODE, TimeCardTimeRecordGroupPEO.STOP_TIMEZONE_CODE AS TC_STOP_TIMEZONE_CODE, TimeCardTimeRecordGroupPEO.START_GMT_OFFSET AS TC_START_GMT_OFFSET, TimeCardTimeRecordGroupPEO.STOP_GMT_OFFSET AS TC_STOP_GMT_OFFSET, TimeCardTimeRecordGroupPEO.LAYER_CODE AS TC_LAYER_CODE, TimeCardTimeRecordGroupPEO.COMMIT_TIMESTAMP AS TC_COMMIT_TIMESTAMP, TimeCardTimeRecordGroupPEO.COMMENT_TEXT AS TC_COMMENT_TEXT, TimeCardTimeRecordGroupPEO.DATE_FROM AS TC_DATE_FROM, TimeCardTimeRecordGroupPEO.DATE_TO AS TC_DATE_TO, TimeCardTimeRecordGroupPEO.CREATED_BY AS TC_CREATED_BY, TimeCardTimeRecordGroupPEO.CREATION_DATE AS TC_CREATION_DATE, TimeCardTimeRecordGroupPEO.LAST_UPDATED_BY AS TC_LAST_UPDATED_BY, TimeCardTimeRecordGroupPEO.LAST_UPDATE_DATE AS TC_LAST_UPDATE_DATE, TimeCardTimeRecordGroupPEO.LAST_UPDATE_LOGIN AS TC_LAST_UPDATE_LOGIN, DayTimeRecordGroupPEO.TM_REC_GRP_ID AS DAY_TM_REC_GRP_ID, DayTimeRecordGroupPEO.TM_REC_GRP_VERSION AS DAY_TM_REC_GRP_VERSION, DayTimeRecordGroupPEO.GRP_TYPE_ID AS DAY_GRP_TYPE_ID, NVL(DayTimeRecordGroupPEO.DELETE_FLAG, 'N') AS DAY_DELETE_FLAG, DayTimeRecordGroupPEO.LATEST_VERSION AS DAY_LATEST_VERSION, DayTimeRecordGroupPEO.START_TIME AS DAY_START_TIME, DayTimeRecordGroupPEO.STOP_TIME AS DAY_STOP_TIME, DayTimeRecordGroupPEO.START_TIMEZONE_CODE AS DAY_START_TIMEZONE_CODE, DayTimeRecordGroupPEO.STOP_TIMEZONE_CODE AS DAY_STOP_TIMEZONE_CODE, DayTimeRecordGroupPEO.START_GMT_OFFSET AS DAY_START_GMT_OFFSET, DayTimeRecordGroupPEO.STOP_GMT_OFFSET AS DAY_STOP_GMT_OFFSET, DayTimeRecordGroupPEO.LAYER_CODE AS DAY_LAYER_CODE, DayTimeRecordGroupPEO.COMMENT_TEXT AS DAY_COMMENT_TEXT, DayTimeRecordGroupPEO.DATE_FROM AS DAY_DATE_FROM, DayTimeRecordGroupPEO.DATE_TO AS DAY_DATE_TO, DayTimeRecordGroupPEO.CREATED_BY AS DAY_CREATED_BY, DayTimeRecordGroupPEO.CREATION_DATE AS DAY_CREATION_DATE, DayTimeRecordGroupPEO.LAST_UPDATED_BY AS DAY_LAST_UPDATED_BY, DayTimeRecordGroupPEO.LAST_UPDATE_DATE AS DAY_LAST_UPDATE_DATE, DayTimeRecordGroupPEO.LAST_UPDATE_LOGIN AS DAY_LAST_UPDATE_LOGIN, TimeEntryTimeRecordPEO.TM_REC_ID AS TE_TM_REC_ID, TimeEntryTimeRecordPEO.TM_REC_VERSION AS TE_TM_REC_VERSION, NVL(TimeEntryTimeRecordPEO.DELETE_FLAG, 'N') AS TE_DELETE_FLAG, TimeEntryTimeRecordPEO.LATEST_VERSION AS TE_LATEST_VERSION, TimeEntryTimeRecordPEO.START_TIME AS TE_START_TIME, TimeEntryTimeRecordPEO.STOP_TIME AS TE_STOP_TIME, TimeEntryTimeRecordPEO.START_TIMEZONE_CODE AS TE_START_TIMEZONE_CODE, TimeEntryTimeRecordPEO.STOP_TIMEZONE_CODE AS TE_STOP_TIMEZONE_CODE, TimeEntryTimeRecordPEO.START_GMT_OFFSET AS TE_START_GMT_OFFSET, TimeEntryTimeRecordPEO.STOP_GMT_OFFSET AS TE_STOP_GMT_OFFSET, TimeEntryTimeRecordPEO.TM_REC_TYPE AS TE_TM_REC_TYPE, TimeEntryTimeRecordPEO.LAYER_CODE AS TE_LAYER_CODE, TimeEntryTimeRecordPEO.COMMENT_TEXT AS TE_COMMENT_TEXT, TimeEntryTimeRecordPEO.UNIT_OF_MEASURE AS TE_UNIT_OF_MEASURE, TimeEntryTimeRecordPEO.MEASURE AS TE_MEASURE, TimeEntryTimeRecordPEO.MEASURE AS TE_MEASURE_LABOR, (NULL) AS TE_MEASURE_ABSENCE, TimeEntryTimeRecordPEO.RESOURCE_ID AS RESOURCE_ID, TimeEntryTimeRecordPEO.SUBRESOURCE_ID AS TE_SUBRESOURCE_ID, TimeEntryTimeRecordPEO.TIME_REPORTER_ID AS TE_TIME_REPORTER_ID, TimeEntryTimeRecordPEO.TCSMR_SET_ID AS TE_TCSMR_SET_ID, TimeEntryTimeRecordPEO.TCSMR_CONFIG_SET_ID AS TE_TCSMR_CONFIG_SET_ID, TimeEntryTimeRecordPEO.ACTIVITY_IN_ID AS TE_ACTIVITY_IN_ID, TimeEntryTimeRecordPEO.ACTIVITY_OUT_ID AS TE_ACTIVITY_OUT_ID, TimeEntryTimeRecordPEO.DATE_FROM AS TE_DATE_FROM, TimeEntryTimeRecordPEO.DATE_TO AS TE_DATE_TO, TimeEntryTimeRecordPEO.CREATED_BY AS TE_CREATED_BY, TimeEntryTimeRecordPEO.CREATION_DATE AS TE_CREATION_DATE, TimeEntryTimeRecordPEO.LAST_UPDATED_BY AS TE_LAST_UPDATED_BY, TimeEntryTimeRecordPEO.LAST_UPDATE_DATE AS TE_LAST_UPDATE_DATE, TimeEntryTimeRecordPEO.LAST_UPDATE_LOGIN AS TE_LAST_UPDATE_LOGIN, (NULL) AS ANC_TM_REC_GRP_ID, (NULL) AS ANC_TM_REC_GRP_VERSION, (NULL) AS ANC_GRP_TYPE_ID, 'N' AS ANC_DELETE_FLAG, 'Y' AS ANC_LATEST_VERSION FROM HWM_TM_REC TimeEntryTimeRecordPEO, HWM_TM_REC_GRP_USAGES TimeRecordGroupUsagePEO, HWM_TM_REC_GRP DayTimeRecordGroupPEO, HWM_TM_REC_GRP TimeCardTimeRecordGroupPEO WHERE TimeRecordGroupUsagePEO.TM_REC_GRP_ID = DayTimeRecordGroupPEO.TM_REC_GRP_ID AND TimeRecordGroupUsagePEO.TM_REC_GRP_VERSION = DayTimeRecordGroupPEO.TM_REC_GRP_VERSION AND DayTimeRecordGroupPEO.PARENT_TM_REC_GRP_ID = TimeCardTimeRecordGroupPEO.TM_REC_GRP_ID AND DayTimeRecordGroupPEO.PARENT_TM_REC_GRP_VERSION = TimeCardTimeRecordGroupPEO.TM_REC_GRP_VERSION AND TimeEntryTimeRecordPEO.TM_REC_ID = TimeRecordGroupUsagePEO.TM_REC_ID AND TimeEntryTimeRecordPEO.TM_REC_VERSION = TimeRecordGroupUsagePEO.TM_REC_VERSION AND UPPER(TimeEntryTimeRecordPEO.UNIT_OF_MEASURE) IN ('UN', 'HR') AND TimeCardTimeRecordGroupPEO.GRP_TYPE_ID = 100 UNION SELECT AbsenceTimeEntryPEO.TIME_CARD_TM_REC_GRP_ID AS TC_TM_REC_GRP_ID, AbsenceTimeEntryPEO.TIME_CARD_TM_REC_GRP_VERSION AS TC_TM_REC_GRP_VERSION, AbsenceTimeEntryPEO.TIME_CARD_GRP_TYPE_ID AS TC_GRP_TYPE_ID, NVL(AbsenceTimeEntryPEO.TIME_CARD_DELETE_FLAG,'N') AS TC_DELETE_FLAG, AbsenceTimeEntryPEO.TIME_CARD_LATEST_VERSION AS TC_LATEST_VERSION, AbsenceTimeEntryPEO.TIME_CARD_START_TIME AS TC_START_TIME, AbsenceTimeEntryPEO.TIME_CARD_STOP_TIME AS TC_STOP_TIME, trunc(AbsenceTimeEntryPEO.TIME_CARD_START_TIME) AS TC_START_DATE, trunc(AbsenceTimeEntryPEO.TIME_CARD_STOP_TIME) AS TC_STOP_DATE, (NULL) AS TC_START_TIMEZONE_CODE, (NULL) AS TC_STOP_TIMEZONE_CODE, (NULL) AS TC_START_GMT_OFFSET, (NULL) AS TC_STOP_GMT_OFFSET, AbsenceTimeEntryPEO.TIME_CARD_LAYER_CODE AS TC_LAYER_CODE, AbsenceTimeEntryPEO.TIME_CARD_COMMIT_TIMESTAMP AS TC_COMMIT_TIMESTAMP, AbsenceTimeEntryPEO.TIME_CARD_COMMENT_TEXT AS TC_COMMENT_TEXT, AbsenceTimeEntryPEO.TIME_CARD_DATE_FROM AS TC_DATE_FROM, AbsenceTimeEntryPEO.TIME_CARD_DATE_TO AS TC_DATE_TO, AbsenceTimeEntryPEO.TIME_CARD_CREATED_BY AS TC_CREATED_BY, AbsenceTimeEntryPEO.TIME_CARD_CREATION_DATE AS TC_CREATION_DATE, AbsenceTimeEntryPEO.TIME_CARD_LAST_UPDATED_BY AS TC_LAST_UPDATED_BY, AbsenceTimeEntryPEO.TIME_CARD_LAST_UPDATE_DATE AS TC_LAST_UPDATE_DATE, AbsenceTimeEntryPEO.TIME_CARD_LAST_UPDATE_LOGIN AS TC_LAST_UPDATE_LOGIN, AbsenceTimeEntryPEO.DAY_TM_REC_GRP_ID AS DAY_TM_REC_GRP_ID, AbsenceTimeEntryPEO.DAY_TM_REC_GRP_VERSION AS DAY_TM_REC_GRP_VERSION, AbsenceTimeEntryPEO.DAY_GRP_TYPE_ID AS DAY_GRP_TYPE_ID, NVL(AbsenceTimeEntryPEO.DAY_DELETE_FLAG, 'N') AS DAY_DELETE_FLAG, AbsenceTimeEntryPEO.DAY_LATEST_VERSION AS DAY_LATEST_VERSION, AbsenceTimeEntryPEO.DAY_START_TIME AS DAY_START_TIME, AbsenceTimeEntryPEO.DAY_STOP_TIME AS DAY_STOP_TIME, (NULL) AS DAY_START_TIMEZONE_CODE, (NULL) AS DAY_STOP_TIMEZONE_CODE, (NULL) AS DAY_START_GMT_OFFSET, (NULL) AS DAY_STOP_GMT_OFFSET, AbsenceTimeEntryPEO.DAY_LAYER_CODE AS DAY_LAYER_CODE, AbsenceTimeEntryPEO.DAY_COMMENT_TEXT AS DAY_COMMENT_TEXT, AbsenceTimeEntryPEO.DAY_DATE_FROM AS DAY_DATE_FROM, AbsenceTimeEntryPEO.DAY_DATE_TO AS DAY_DATE_TO, AbsenceTimeEntryPEO.DAY_CREATED_BY AS DAY_CREATED_BY, AbsenceTimeEntryPEO.DAY_CREATION_DATE AS DAY_CREATION_DATE, AbsenceTimeEntryPEO.DAY_LAST_UPDATED_BY AS DAY_LAST_UPDATED_BY, AbsenceTimeEntryPEO.DAY_LAST_UPDATE_DATE AS DAY_LAST_UPDATE_DATE, AbsenceTimeEntryPEO.DAY_LAST_UPDATE_LOGIN AS DAY_LAST_UPDATE_LOGIN, AbsenceTimeEntryPEO.TIME_ENTRY_TM_REC_ID AS TE_TM_REC_ID, AbsenceTimeEntryPEO.TIME_ENTRY_TM_REC_VERSION AS TE_TM_REC_VERSION, NVL(AbsenceTimeEntryPEO.TIME_ENTRY_DELETE_FLAG, 'N') AS TE_DELETE_FLAG, AbsenceTimeEntryPEO.TIME_ENTRY_LATEST_VERSION AS TE_LATEST_VERSION, AbsenceTimeEntryPEO.TIME_ENTRY_START_TIME AS TE_START_TIME, AbsenceTimeEntryPEO.TIME_ENTRY_STOP_TIME AS TE_STOP_TIME, (NULL) AS TE_START_TIMEZONE_CODE, (NULL) AS TE_STOP_TIMEZONE_CODE, (NULL) AS TE_START_GMT_OFFSET, (NULL) AS TE_STOP_GMT_OFFSET, AbsenceTimeEntryPEO.TIME_ENTRY_TM_REC_TYPE AS TE_TM_REC_TYPE, AbsenceTimeEntryPEO.TIME_ENTRY_LAYER_CODE AS TE_LAYER_CODE, AbsenceTimeEntryPEO.TIME_ENTRY_COMMENT_TEXT AS TE_COMMENT_TEXT, AbsenceTimeEntryPEO.TIME_ENTRY_UNIT_OF_MEASURE AS TE_UNIT_OF_MEASURE, AbsenceTimeEntryPEO.TIME_ENTRY_MEASURE AS TE_MEASURE, (NULL) AS TE_MEASURE_LABOR, AbsenceTimeEntryPEO.TIME_ENTRY_MEASURE AS TE_MEASURE_ABSENCE, AbsenceTimeEntryPEO.RESOURCE_ID AS RESOURCE_ID, AbsenceTimeEntryPEO.TIME_ENTRY_SUBRESOURCE_ID AS TE_SUBRESOURCE_ID, AbsenceTimeEntryPEO.TIME_ENTRY_TIME_REPORTER_ID AS TE_TIME_REPORTER_ID, AbsenceTimeEntryPEO.TIME_ENTRY_TCSMR_SET_ID AS TE_TCSMR_SET_ID, AbsenceTimeEntryPEO.TIME_ENTRY_TCSMR_CONFIG_SET_ID AS TE_TCSMR_CONFIG_SET_ID, (NULL) AS TE_ACTIVITY_IN_ID, (NULL) AS TE_ACTIVITY_OUT_ID, AbsenceTimeEntryPEO.TIME_ENTRY_DATE_FROM AS TE_DATE_FROM, AbsenceTimeEntryPEO.TIME_ENTRY_DATE_TO AS TE_DATE_TO, AbsenceTimeEntryPEO.TIME_ENTRY_CREATED_BY AS TE_CREATED_BY, AbsenceTimeEntryPEO.TIME_ENTRY_CREATION_DATE AS TE_CREATION_DATE, AbsenceTimeEntryPEO.TIME_ENTRY_LAST_UPDATED_BY AS TE_LAST_UPDATED_BY, AbsenceTimeEntryPEO.TIME_ENTRY_LAST_UPDATE_DATE AS TE_LAST_UPDATE_DATE, AbsenceTimeEntryPEO.TIME_ENTRY_LAST_UPDATE_LOGIN AS TE_LAST_UPDATE_LOGIN, AncHeaderTimeRecordGroupPEO.TM_REC_GRP_ID AS ANC_TM_REC_GRP_ID, AncHeaderTimeRecordGroupPEO.TM_REC_GRP_VERSION AS ANC_TM_REC_GRP_VERSION, AncHeaderTimeRecordGroupPEO.GRP_TYPE_ID AS ANC_GRP_TYPE_ID, NVL(AncHeaderTimeRecordGroupPEO.DELETE_FLAG, 'N') AS ANC_DELETE_FLAG, AncHeaderTimeRecordGroupPEO.LATEST_VERSION AS ANC_LATEST_VERSION FROM HWM_TM_ABS_ENTRY_V AbsenceTimeEntryPEO, HWM_TM_REC_GRP_USAGES AncTimeRecordGroupUsagePEO, HWM_TM_REC_GRP AncHeaderTimeRecordGroupPEO WHERE AbsenceTimeEntryPEO.TIME_ENTRY_TM_REC_ID = AncTimeRecordGroupUsagePEO.TM_REC_ID AND AbsenceTimeEntryPEO.TIME_ENTRY_TM_REC_VERSION = AncTimeRecordGroupUsagePEO.TM_REC_VERSION AND AncTimeRecordGroupUsagePEO.TM_REC_GRP_ID = AncHeaderTimeRecordGroupPEO.TM_REC_GRP_ID AND AncTimeRecordGroupUsagePEO.TM_REC_GRP_VERSION = AncHeaderTimeRecordGroupPEO.TM_REC_GRP_VERSION AND AncHeaderTimeRecordGroupPEO.GRP_TYPE_ID = 105

SQL_Statement

SELECT TimeCardTimeRecordGroupPEO.TM_REC_GRP_ID AS TC_TM_REC_GRP_ID,

TimeCardTimeRecordGroupPEO.TM_REC_GRP_VERSION AS TC_TM_REC_GRP_VERSION,

TimeCardTimeRecordGroupPEO.GRP_TYPE_ID AS TC_GRP_TYPE_ID,

NVL(TimeCardTimeRecordGroupPEO.DELETE_FLAG,'N') AS TC_DELETE_FLAG,

TimeCardTimeRecordGroupPEO.LATEST_VERSION AS TC_LATEST_VERSION,

TimeCardTimeRecordGroupPEO.START_TIME AS TC_START_TIME,

TimeCardTimeRecordGroupPEO.STOP_TIME AS TC_STOP_TIME,

trunc(TimeCardTimeRecordGroupPEO.START_TIME) AS TC_START_DATE,

trunc(TimeCardTimeRecordGroupPEO.STOP_TIME) AS TC_STOP_DATE,

TimeCardTimeRecordGroupPEO.START_TIMEZONE_CODE AS TC_START_TIMEZONE_CODE,

TimeCardTimeRecordGroupPEO.STOP_TIMEZONE_CODE AS TC_STOP_TIMEZONE_CODE,

TimeCardTimeRecordGroupPEO.START_GMT_OFFSET AS TC_START_GMT_OFFSET,

TimeCardTimeRecordGroupPEO.STOP_GMT_OFFSET AS TC_STOP_GMT_OFFSET,

TimeCardTimeRecordGroupPEO.LAYER_CODE AS TC_LAYER_CODE,

TimeCardTimeRecordGroupPEO.COMMIT_TIMESTAMP AS TC_COMMIT_TIMESTAMP,

TimeCardTimeRecordGroupPEO.COMMENT_TEXT AS TC_COMMENT_TEXT,

TimeCardTimeRecordGroupPEO.DATE_FROM AS TC_DATE_FROM,

TimeCardTimeRecordGroupPEO.DATE_TO AS TC_DATE_TO,

TimeCardTimeRecordGroupPEO.CREATED_BY AS TC_CREATED_BY,

TimeCardTimeRecordGroupPEO.CREATION_DATE AS TC_CREATION_DATE,

TimeCardTimeRecordGroupPEO.LAST_UPDATED_BY AS TC_LAST_UPDATED_BY,

TimeCardTimeRecordGroupPEO.LAST_UPDATE_DATE AS TC_LAST_UPDATE_DATE,

TimeCardTimeRecordGroupPEO.LAST_UPDATE_LOGIN AS TC_LAST_UPDATE_LOGIN,

DayTimeRecordGroupPEO.TM_REC_GRP_ID AS DAY_TM_REC_GRP_ID,

DayTimeRecordGroupPEO.TM_REC_GRP_VERSION AS DAY_TM_REC_GRP_VERSION,

DayTimeRecordGroupPEO.GRP_TYPE_ID AS DAY_GRP_TYPE_ID,

NVL(DayTimeRecordGroupPEO.DELETE_FLAG, 'N') AS DAY_DELETE_FLAG,

DayTimeRecordGroupPEO.LATEST_VERSION AS DAY_LATEST_VERSION,

DayTimeRecordGroupPEO.START_TIME AS DAY_START_TIME,

DayTimeRecordGroupPEO.STOP_TIME AS DAY_STOP_TIME,

DayTimeRecordGroupPEO.START_TIMEZONE_CODE AS DAY_START_TIMEZONE_CODE,

DayTimeRecordGroupPEO.STOP_TIMEZONE_CODE AS DAY_STOP_TIMEZONE_CODE,

DayTimeRecordGroupPEO.START_GMT_OFFSET AS DAY_START_GMT_OFFSET,

DayTimeRecordGroupPEO.STOP_GMT_OFFSET AS DAY_STOP_GMT_OFFSET,

DayTimeRecordGroupPEO.LAYER_CODE AS DAY_LAYER_CODE,

DayTimeRecordGroupPEO.COMMENT_TEXT AS DAY_COMMENT_TEXT,

DayTimeRecordGroupPEO.DATE_FROM AS DAY_DATE_FROM,

DayTimeRecordGroupPEO.DATE_TO AS DAY_DATE_TO,

DayTimeRecordGroupPEO.CREATED_BY AS DAY_CREATED_BY,

DayTimeRecordGroupPEO.CREATION_DATE AS DAY_CREATION_DATE,

DayTimeRecordGroupPEO.LAST_UPDATED_BY AS DAY_LAST_UPDATED_BY,

DayTimeRecordGroupPEO.LAST_UPDATE_DATE AS DAY_LAST_UPDATE_DATE,

DayTimeRecordGroupPEO.LAST_UPDATE_LOGIN AS DAY_LAST_UPDATE_LOGIN,

TimeEntryTimeRecordPEO.TM_REC_ID AS TE_TM_REC_ID,

TimeEntryTimeRecordPEO.TM_REC_VERSION AS TE_TM_REC_VERSION,

NVL(TimeEntryTimeRecordPEO.DELETE_FLAG, 'N') AS TE_DELETE_FLAG,

TimeEntryTimeRecordPEO.LATEST_VERSION AS TE_LATEST_VERSION,

TimeEntryTimeRecordPEO.START_TIME AS TE_START_TIME,

TimeEntryTimeRecordPEO.STOP_TIME AS TE_STOP_TIME,

TimeEntryTimeRecordPEO.START_TIMEZONE_CODE AS TE_START_TIMEZONE_CODE,

TimeEntryTimeRecordPEO.STOP_TIMEZONE_CODE AS TE_STOP_TIMEZONE_CODE,

TimeEntryTimeRecordPEO.START_GMT_OFFSET AS TE_START_GMT_OFFSET,

TimeEntryTimeRecordPEO.STOP_GMT_OFFSET AS TE_STOP_GMT_OFFSET,

TimeEntryTimeRecordPEO.TM_REC_TYPE AS TE_TM_REC_TYPE,

TimeEntryTimeRecordPEO.LAYER_CODE AS TE_LAYER_CODE,

TimeEntryTimeRecordPEO.COMMENT_TEXT AS TE_COMMENT_TEXT,

TimeEntryTimeRecordPEO.UNIT_OF_MEASURE AS TE_UNIT_OF_MEASURE,

TimeEntryTimeRecordPEO.MEASURE AS TE_MEASURE,

TimeEntryTimeRecordPEO.MEASURE AS TE_MEASURE_LABOR,

(NULL) AS TE_MEASURE_ABSENCE,

TimeEntryTimeRecordPEO.RESOURCE_ID AS RESOURCE_ID,

TimeEntryTimeRecordPEO.SUBRESOURCE_ID AS TE_SUBRESOURCE_ID,

TimeEntryTimeRecordPEO.TIME_REPORTER_ID AS TE_TIME_REPORTER_ID,

TimeEntryTimeRecordPEO.TCSMR_SET_ID AS TE_TCSMR_SET_ID,

TimeEntryTimeRecordPEO.TCSMR_CONFIG_SET_ID AS TE_TCSMR_CONFIG_SET_ID,

TimeEntryTimeRecordPEO.ACTIVITY_IN_ID AS TE_ACTIVITY_IN_ID,

TimeEntryTimeRecordPEO.ACTIVITY_OUT_ID AS TE_ACTIVITY_OUT_ID,

TimeEntryTimeRecordPEO.DATE_FROM AS TE_DATE_FROM,

TimeEntryTimeRecordPEO.DATE_TO AS TE_DATE_TO,

TimeEntryTimeRecordPEO.CREATED_BY AS TE_CREATED_BY,

TimeEntryTimeRecordPEO.CREATION_DATE AS TE_CREATION_DATE,

TimeEntryTimeRecordPEO.LAST_UPDATED_BY AS TE_LAST_UPDATED_BY,

TimeEntryTimeRecordPEO.LAST_UPDATE_DATE AS TE_LAST_UPDATE_DATE,

TimeEntryTimeRecordPEO.LAST_UPDATE_LOGIN AS TE_LAST_UPDATE_LOGIN,

(NULL) AS ANC_TM_REC_GRP_ID,

(NULL) AS ANC_TM_REC_GRP_VERSION,

(NULL) AS ANC_GRP_TYPE_ID,

'N' AS ANC_DELETE_FLAG,

'Y' AS ANC_LATEST_VERSION

FROM HWM_TM_REC TimeEntryTimeRecordPEO,

HWM_TM_REC_GRP_USAGES TimeRecordGroupUsagePEO,

HWM_TM_REC_GRP DayTimeRecordGroupPEO,

HWM_TM_REC_GRP TimeCardTimeRecordGroupPEO

WHERE TimeRecordGroupUsagePEO.TM_REC_GRP_ID = DayTimeRecordGroupPEO.TM_REC_GRP_ID

AND TimeRecordGroupUsagePEO.TM_REC_GRP_VERSION = DayTimeRecordGroupPEO.TM_REC_GRP_VERSION

AND DayTimeRecordGroupPEO.PARENT_TM_REC_GRP_ID = TimeCardTimeRecordGroupPEO.TM_REC_GRP_ID

AND DayTimeRecordGroupPEO.PARENT_TM_REC_GRP_VERSION = TimeCardTimeRecordGroupPEO.TM_REC_GRP_VERSION

AND TimeEntryTimeRecordPEO.TM_REC_ID = TimeRecordGroupUsagePEO.TM_REC_ID

AND TimeEntryTimeRecordPEO.TM_REC_VERSION = TimeRecordGroupUsagePEO.TM_REC_VERSION

AND UPPER(TimeEntryTimeRecordPEO.UNIT_OF_MEASURE) IN ('UN', 'HR')

AND TimeCardTimeRecordGroupPEO.GRP_TYPE_ID = 100

UNION

SELECT AbsenceTimeEntryPEO.TIME_CARD_TM_REC_GRP_ID AS TC_TM_REC_GRP_ID,

AbsenceTimeEntryPEO.TIME_CARD_TM_REC_GRP_VERSION AS TC_TM_REC_GRP_VERSION,

AbsenceTimeEntryPEO.TIME_CARD_GRP_TYPE_ID AS TC_GRP_TYPE_ID,

NVL(AbsenceTimeEntryPEO.TIME_CARD_DELETE_FLAG,'N') AS TC_DELETE_FLAG,

AbsenceTimeEntryPEO.TIME_CARD_LATEST_VERSION AS TC_LATEST_VERSION,

AbsenceTimeEntryPEO.TIME_CARD_START_TIME AS TC_START_TIME,

AbsenceTimeEntryPEO.TIME_CARD_STOP_TIME AS TC_STOP_TIME,

trunc(AbsenceTimeEntryPEO.TIME_CARD_START_TIME) AS TC_START_DATE,

trunc(AbsenceTimeEntryPEO.TIME_CARD_STOP_TIME) AS TC_STOP_DATE,

(NULL) AS TC_START_TIMEZONE_CODE,

(NULL) AS TC_STOP_TIMEZONE_CODE,

(NULL) AS TC_START_GMT_OFFSET,

(NULL) AS TC_STOP_GMT_OFFSET,

AbsenceTimeEntryPEO.TIME_CARD_LAYER_CODE AS TC_LAYER_CODE,

AbsenceTimeEntryPEO.TIME_CARD_COMMIT_TIMESTAMP AS TC_COMMIT_TIMESTAMP,

AbsenceTimeEntryPEO.TIME_CARD_COMMENT_TEXT AS TC_COMMENT_TEXT,

AbsenceTimeEntryPEO.TIME_CARD_DATE_FROM AS TC_DATE_FROM,

AbsenceTimeEntryPEO.TIME_CARD_DATE_TO AS TC_DATE_TO,

AbsenceTimeEntryPEO.TIME_CARD_CREATED_BY AS TC_CREATED_BY,

AbsenceTimeEntryPEO.TIME_CARD_CREATION_DATE AS TC_CREATION_DATE,

AbsenceTimeEntryPEO.TIME_CARD_LAST_UPDATED_BY AS TC_LAST_UPDATED_BY,

AbsenceTimeEntryPEO.TIME_CARD_LAST_UPDATE_DATE AS TC_LAST_UPDATE_DATE,

AbsenceTimeEntryPEO.TIME_CARD_LAST_UPDATE_LOGIN AS TC_LAST_UPDATE_LOGIN,

AbsenceTimeEntryPEO.DAY_TM_REC_GRP_ID AS DAY_TM_REC_GRP_ID,

AbsenceTimeEntryPEO.DAY_TM_REC_GRP_VERSION AS DAY_TM_REC_GRP_VERSION,

AbsenceTimeEntryPEO.DAY_GRP_TYPE_ID AS DAY_GRP_TYPE_ID,

NVL(AbsenceTimeEntryPEO.DAY_DELETE_FLAG, 'N') AS DAY_DELETE_FLAG,

AbsenceTimeEntryPEO.DAY_LATEST_VERSION AS DAY_LATEST_VERSION,

AbsenceTimeEntryPEO.DAY_START_TIME AS DAY_START_TIME,

AbsenceTimeEntryPEO.DAY_STOP_TIME AS DAY_STOP_TIME,

(NULL) AS DAY_START_TIMEZONE_CODE,

(NULL) AS DAY_STOP_TIMEZONE_CODE,

(NULL) AS DAY_START_GMT_OFFSET,

(NULL) AS DAY_STOP_GMT_OFFSET,

AbsenceTimeEntryPEO.DAY_LAYER_CODE AS DAY_LAYER_CODE,

AbsenceTimeEntryPEO.DAY_COMMENT_TEXT AS DAY_COMMENT_TEXT,

AbsenceTimeEntryPEO.DAY_DATE_FROM AS DAY_DATE_FROM,

AbsenceTimeEntryPEO.DAY_DATE_TO AS DAY_DATE_TO,

AbsenceTimeEntryPEO.DAY_CREATED_BY AS DAY_CREATED_BY,

AbsenceTimeEntryPEO.DAY_CREATION_DATE AS DAY_CREATION_DATE,

AbsenceTimeEntryPEO.DAY_LAST_UPDATED_BY AS DAY_LAST_UPDATED_BY,

AbsenceTimeEntryPEO.DAY_LAST_UPDATE_DATE AS DAY_LAST_UPDATE_DATE,

AbsenceTimeEntryPEO.DAY_LAST_UPDATE_LOGIN AS DAY_LAST_UPDATE_LOGIN,

AbsenceTimeEntryPEO.TIME_ENTRY_TM_REC_ID AS TE_TM_REC_ID,

AbsenceTimeEntryPEO.TIME_ENTRY_TM_REC_VERSION AS TE_TM_REC_VERSION,

NVL(AbsenceTimeEntryPEO.TIME_ENTRY_DELETE_FLAG, 'N') AS TE_DELETE_FLAG,

AbsenceTimeEntryPEO.TIME_ENTRY_LATEST_VERSION AS TE_LATEST_VERSION,

AbsenceTimeEntryPEO.TIME_ENTRY_START_TIME AS TE_START_TIME,

AbsenceTimeEntryPEO.TIME_ENTRY_STOP_TIME AS TE_STOP_TIME,

(NULL) AS TE_START_TIMEZONE_CODE,

(NULL) AS TE_STOP_TIMEZONE_CODE,

(NULL) AS TE_START_GMT_OFFSET,

(NULL) AS TE_STOP_GMT_OFFSET,

AbsenceTimeEntryPEO.TIME_ENTRY_TM_REC_TYPE AS TE_TM_REC_TYPE,

AbsenceTimeEntryPEO.TIME_ENTRY_LAYER_CODE AS TE_LAYER_CODE,

AbsenceTimeEntryPEO.TIME_ENTRY_COMMENT_TEXT AS TE_COMMENT_TEXT,

AbsenceTimeEntryPEO.TIME_ENTRY_UNIT_OF_MEASURE AS TE_UNIT_OF_MEASURE,

AbsenceTimeEntryPEO.TIME_ENTRY_MEASURE AS TE_MEASURE,

(NULL) AS TE_MEASURE_LABOR,

AbsenceTimeEntryPEO.TIME_ENTRY_MEASURE AS TE_MEASURE_ABSENCE,

AbsenceTimeEntryPEO.RESOURCE_ID AS RESOURCE_ID,

AbsenceTimeEntryPEO.TIME_ENTRY_SUBRESOURCE_ID AS TE_SUBRESOURCE_ID,

AbsenceTimeEntryPEO.TIME_ENTRY_TIME_REPORTER_ID AS TE_TIME_REPORTER_ID,

AbsenceTimeEntryPEO.TIME_ENTRY_TCSMR_SET_ID AS TE_TCSMR_SET_ID,

AbsenceTimeEntryPEO.TIME_ENTRY_TCSMR_CONFIG_SET_ID AS TE_TCSMR_CONFIG_SET_ID,

(NULL) AS TE_ACTIVITY_IN_ID,

(NULL) AS TE_ACTIVITY_OUT_ID,

AbsenceTimeEntryPEO.TIME_ENTRY_DATE_FROM AS TE_DATE_FROM,

AbsenceTimeEntryPEO.TIME_ENTRY_DATE_TO AS TE_DATE_TO,

AbsenceTimeEntryPEO.TIME_ENTRY_CREATED_BY AS TE_CREATED_BY,

AbsenceTimeEntryPEO.TIME_ENTRY_CREATION_DATE AS TE_CREATION_DATE,

AbsenceTimeEntryPEO.TIME_ENTRY_LAST_UPDATED_BY AS TE_LAST_UPDATED_BY,

AbsenceTimeEntryPEO.TIME_ENTRY_LAST_UPDATE_DATE AS TE_LAST_UPDATE_DATE,

AbsenceTimeEntryPEO.TIME_ENTRY_LAST_UPDATE_LOGIN AS TE_LAST_UPDATE_LOGIN,

AncHeaderTimeRecordGroupPEO.TM_REC_GRP_ID AS ANC_TM_REC_GRP_ID,

AncHeaderTimeRecordGroupPEO.TM_REC_GRP_VERSION AS ANC_TM_REC_GRP_VERSION,

AncHeaderTimeRecordGroupPEO.GRP_TYPE_ID AS ANC_GRP_TYPE_ID,

NVL(AncHeaderTimeRecordGroupPEO.DELETE_FLAG, 'N') AS ANC_DELETE_FLAG,

AncHeaderTimeRecordGroupPEO.LATEST_VERSION AS ANC_LATEST_VERSION

FROM HWM_TM_ABS_ENTRY_V AbsenceTimeEntryPEO,

HWM_TM_REC_GRP_USAGES AncTimeRecordGroupUsagePEO,

HWM_TM_REC_GRP AncHeaderTimeRecordGroupPEO

WHERE AbsenceTimeEntryPEO.TIME_ENTRY_TM_REC_ID = AncTimeRecordGroupUsagePEO.TM_REC_ID

AND AbsenceTimeEntryPEO.TIME_ENTRY_TM_REC_VERSION = AncTimeRecordGroupUsagePEO.TM_REC_VERSION

AND AncTimeRecordGroupUsagePEO.TM_REC_GRP_ID = AncHeaderTimeRecordGroupPEO.TM_REC_GRP_ID

AND AncTimeRecordGroupUsagePEO.TM_REC_GRP_VERSION = AncHeaderTimeRecordGroupPEO.TM_REC_GRP_VERSION

AND AncHeaderTimeRecordGroupPEO.GRP_TYPE_ID = 105