1. Tables and Views for SCM
  2. WIE_PLANT_CALENDAR_SHIFTS_V

WIE_PLANT_CALENDAR_SHIFTS_V

Details

  • Schema: FUSION

  • Object owner: WIE

  • Object type: VIEW

Columns

Name

ORGANIZATION_ID

SCHEDULE_ID

SHIFT_ID

SCHEDULE_DETAIL_ID

START_DATE_TIME

END_DATE_TIME

Query

SQL_Statement

SELECT mp.organization_id organization_id,

sd.schedule_id schedule_id,

sd.shift_id shift_id,

sd.schedule_detail_id schedule_detail_id,

sd.start_date_time start_date_time,

sd.end_date_time end_date_time

FROM zmm_sr_schedule_dtls sd,

rcs_mfg_parameters mp

WHERE mp.mfg_calendar = sd.schedule_id

and shift_id is not null

ORDER BY mp.organization_id, sd.schedule_id, sd.shift_id, sd.schedule_detail_id