1. Tables and Views for HCM
  2. HTS_SCHEDULES_SHIFT_TYPES_VL

HTS_SCHEDULES_SHIFT_TYPES_VL

Details

  • Schema: FUSION

  • Object owner: HTS

  • Object type: VIEW

Columns

Name

SHIFT_ID

SHIFT_NAME

SHIFT_DESC

START_TIME_MS_NUM

END_TIME_MS_NUM

DURATION_MS_NUM

DURATION_UOM_CODE

SHIFT_TYPE_CODE

SHORT_TXT

CATEGORY_CODE

GLOBAL_FLAG

AVAILABILITY_CODE

SHIFT_DTL_TYPE_CODE

DELETED_FLAG

ATTRIBUTE_CATEGORY

OBJECT_VERSION_NUMBER

SHIFT_COLOUR

SHIFT_SHORT_NAME

START_EARLY_GRACE

START_LATE_GRACE

END_EARLY_GRACE

END_LATE_GRACE

START_EARLY_VIOLATION

START_LATE_VIOLATION

END_LATE_VIOLATION

END_EARLY_VIOLATION

TOLERANCE

SHIFT_TYPE_ID

CUSTOM_SHIFT

TIME_NOT_WORKED

DAY_INDICATOR

SHIFT_CODE

MODULE_ID

LAST_UPDATE_DATE

Query

SQL_Statement

SELECT SchedulesShiftTypesEO.SHIFT_ID,

SchedulesShiftTypesEO.SHIFT_NAME,

SchedulesShiftTypesEO.SHIFT_DESC,

SchedulesShiftTypesEO.START_TIME_MS_NUM,

SchedulesShiftTypesEO.END_TIME_MS_NUM,

SchedulesShiftTypesEO.DURATION_MS_NUM,

SchedulesShiftTypesEO.DURATION_UOM_CODE,

SchedulesShiftTypesEO.SHIFT_TYPE_CODE,

SchedulesShiftTypesEO.SHORT_TXT,

SchedulesShiftTypesEO.CATEGORY_CODE,

SchedulesShiftTypesEO.GLOBAL_FLAG,

SchedulesShiftTypesEO.AVAILABILITY_CODE,

SchedulesShiftTypesEO.SHIFT_DTL_TYPE_CODE,

SchedulesShiftTypesEO.DELETED_FLAG,

SchedulesShiftTypesEO.ATTRIBUTE_CATEGORY,

SchedulesShiftTypesEO.OBJECT_VERSION_NUMBER,

SchedulesShiftTypesDetailsEO.SHIFT_COLOUR,

SchedulesShiftTypesDetailsEO.SHIFT_SHORT_NAME,

SchedulesShiftTypesDetailsEO.START_EARLY_GRACE,

SchedulesShiftTypesDetailsEO.START_LATE_GRACE,

SchedulesShiftTypesDetailsEO.END_EARLY_GRACE,

SchedulesShiftTypesDetailsEO.END_LATE_GRACE,

SchedulesShiftTypesDetailsEO.START_EARLY_VIOLATION,

SchedulesShiftTypesDetailsEO.START_LATE_VIOLATION,

SchedulesShiftTypesDetailsEO.END_LATE_VIOLATION,

SchedulesShiftTypesDetailsEO.END_EARLY_VIOLATION,

SchedulesShiftTypesDetailsEO.TOLERANCE,

SchedulesShiftTypesDetailsEO.SHIFT_TYPE_ID,

'N' CUSTOM_SHIFT,

SchedulesShiftTypesDetailsEO.TIME_NOT_WORKED,

null DAY_INDICATOR,

SchedulesShiftTypesDetailsEO.SHIFT_CODE,

null MODULE_ID,

SchedulesShiftTypesDetailsEO.LAST_UPDATE_DATE

FROM ZMM_SR_SHIFTS_VL SchedulesShiftTypesEO,

HTS_SHIFT_TYPES_DETAILS SchedulesShiftTypesDetailsEO

WHERE SchedulesShiftTypesEO.SHIFT_ID = SchedulesShiftTypesDetailsEO.SHIFT_TYPE_ID(+)

AND SchedulesShiftTypesEO.SHIFT_TYPE_CODE != 'DURATION'

UNION

SELECT SchedulesCustomShiftTypesEO.SHIFT_TYPE_ID SHIFT_ID,

SchedulesCustomShiftTypesEO.SHIFT_NAME,

SchedulesCustomShiftTypesEO.SHIFT_DESC,

SchedulesCustomShiftTypesEO.START_TIME_MS_NUM,

SchedulesCustomShiftTypesEO.END_TIME_MS_NUM,

SchedulesCustomShiftTypesEO.DURATION_MS_NUM,

SchedulesCustomShiftTypesEO.DURATION_UOM_CODE,

SchedulesCustomShiftTypesEO.SHIFT_TYPE_CODE,

SchedulesCustomShiftTypesEO.SHORT_TXT,

SchedulesCustomShiftTypesEO.CATEGORY_CODE,

SchedulesCustomShiftTypesEO.GLOBAL_FLAG,

SchedulesCustomShiftTypesEO.AVAILABILITY_CODE,

SchedulesCustomShiftTypesEO.SHIFT_DTL_TYPE_CODE,

SchedulesCustomShiftTypesEO.DELETED_FLAG,

SchedulesCustomShiftTypesEO.ATTRIBUTE_CATEGORY,

SchedulesCustomShiftTypesEO.OBJECT_VERSION_NUMBER,

SchedulesCustomShiftTypesEO.SHIFT_COLOUR,

SchedulesCustomShiftTypesEO.SHIFT_SHORT_NAME,

SchedulesCustomShiftTypesEO.START_EARLY_GRACE,

SchedulesCustomShiftTypesEO.START_LATE_GRACE,

SchedulesCustomShiftTypesEO.END_EARLY_GRACE,

SchedulesCustomShiftTypesEO.END_LATE_GRACE,

SchedulesCustomShiftTypesEO.START_EARLY_VIOLATION,

SchedulesCustomShiftTypesEO.START_LATE_VIOLATION,

SchedulesCustomShiftTypesEO.END_LATE_VIOLATION,

SchedulesCustomShiftTypesEO.END_EARLY_VIOLATION,

SchedulesCustomShiftTypesEO.TOLERANCE,

SchedulesCustomShiftTypesEO.SHIFT_TYPE_ID,

'Y' CUSTOM_SHIFT,

SchedulesCustomShiftTypesEO.TIME_NOT_WORKED,

SchedulesCustomShiftTypesEO.DAY_INDICATOR,

SchedulesCustomShiftTypesEO.SHIFT_CODE,

SchedulesCustomShiftTypesEO.MODULE_ID,

SchedulesCustomShiftTypesEO.LAST_UPDATE_DATE

from HTS_CUSTOM_SHIFT_TYPES_VL SchedulesCustomShiftTypesEO

WHERE NVL(SchedulesCustomShiftTypesEO.DELETED_FLAG, 'N') <> 'Y'