HTS_SCHEDULES_DAY_SHIFT_VIEW

Details

• Schema: FUSION

• Object owner: HTS

• Object type: VIEW

Columns

Name
SHIFT_TM_REC_GRP_ID SHIFT_TM_REC_GRP_VERSION PARENT_TM_REC_GRP_ID PARENT_TM_REC_GRP_VERSION SHIFT_DATE_FROM SHIFT_DATE_TO SHIFT_SEQUENCE SHIFT_START_TIME SHIFT_STOP_TIME SHIFT_ID SHIFT_NAME SHIFT_SHORT_NAME SHIFT_TYPE_CODE

Query

SQL_Statement

SELECT ScheduleShift.TM_REC_GRP_ID AS SHIFT_TM_REC_GRP_ID, ScheduleShift.TM_REC_GRP_VERSION AS SHIFT_TM_REC_GRP_VERSION, ScheduleShift.PARENT_TM_REC_GRP_ID AS PARENT_TM_REC_GRP_ID, ScheduleShift.PARENT_TM_REC_GRP_VERSION AS PARENT_TM_REC_GRP_VERSION, ScheduleShift.DATE_FROM AS SHIFT_DATE_FROM, ScheduleShift.DATE_TO AS SHIFT_DATE_TO, ROW_NUMBER() OVER (PARTITION BY PARENT_TM_REC_GRP_ID, PARENT_TM_REC_GRP_VERSION ORDER BY START_TIME) AS SHIFT_SEQUENCE, ScheduleShift.START_TIME AS SHIFT_START_TIME, ScheduleShift.STOP_TIME AS SHIFT_STOP_TIME, ShiftType.SHIFT_ID AS SHIFT_ID, ShiftType.SHIFT_NAME AS SHIFT_NAME, ShiftType.SHIFT_SHORT_NAME AS SHIFT_SHORT_NAME, ShiftType.SHIFT_TYPE_CODE AS SHIFT_TYPE_CODE FROM HWM_TM_REC_GRP ScheduleShift, HWM_TM_REP_ATRBS Atrbs, HWM_TM_REP_ATRB_USAGES AtrbUsg, HTS_SCHEDULES_SHIFT_TYPES_VL ShiftType WHERE ScheduleShift.GRP_TYPE_ID = 1002 AND ScheduleShift.LATEST_VERSION = 'Y' AND (ScheduleShift.DELETE_FLAG IS NULL OR ScheduleShift.DELETE_FLAG = 'N') AND ScheduleShift.TM_REC_GRP_ID = AtrbUsg.USAGES_SOURCE_ID AND ScheduleShift.TM_REC_GRP_VERSION = AtrbUsg.USAGES_SOURCE_VERSION AND AtrbUsg.LATEST_VERSION = 'Y' AND AtrbUsg.TM_REP_ATRB_ID = Atrbs.TM_REP_ATRB_ID AND Atrbs.ATTRIBUTE_CATEGORY = 'Schedules' AND Atrbs.ATTRIBUTE_NUMBER6 = ShiftType.SHIFT_ID (+) AND (ShiftType.DELETED_FLAG IS NULL OR ShiftType.DELETED_FLAG = 'N')