WIE_OVERRIDE_CALENDAR_SHIFTS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: WIE
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ORGANIZATION_ID SCHEDULE_ID SHIFT_ID SCHEDULE_DETAIL_ID START_DATE_TIME END_DATE_TIME |
問合せ
| SQL_Statement |
|---|
|
SELECT wc.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, wis_wc_prod_calendars pd, wis_work_centers_b wc WHERE pd.mfg_calendar_id = sd.schedule_id AND wc.work_center_id = pd.work_center_id AND shift_id IS NOT NULL ORDER BY wc.organization_id, sd.schedule_id, sd.shift_id, sd.schedule_detail_id |