SELECT "A1"."PLANT_FK_KEY" "PLANT_FK_KEY",MAX("A1"."SHIFT_DATE") "SHIFT_DATE",GREATEST(MAX("A1"."SHIFT_DATE"),MAX("A1"."TO_DATE")) "TO_DATE" FROM ( (SELECT DISTINCT "A23"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_ENTITY_SUSTAIN_ASPECT" "A23" WHERE "A23"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A22"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_ENTITY_SUSTAIN_ASPECT_HOUR" "A22" WHERE "A22"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A21"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_EQUIPMENTS_EXT_B" "A21" WHERE "A21"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A20"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_EQUIP_OUTPUT" "A20" WHERE "A20"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A19"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_EQUIP_OUTPUT_SUMMARY" "A19" WHERE "A19"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A18"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_EQUIP_PROD_PERFORMANCE_F" "A18" WHERE "A18"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A17"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_EQUIP_PROD_PERF_DETAIL_F" "A17" WHERE "A17"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A16"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_EQUIP_PROD_SCHEDULE_F" "A16" WHERE "A16"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A15"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_EQUIP_STANDARD_RATES_F" "A15" WHERE "A15"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A14"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_EQUIP_STATUSES" "A14" WHERE "A14"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A13"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_EQUIP_STATUS_SUMMARY" "A13" WHERE "A13"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A12"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_EVENTS" "A12" WHERE "A12"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A11"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_PROD_MTL_CONSUMED_TXN_F" "A11" WHERE "A11"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A10"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_PROD_MTL_PRODUCED_TXN_F" "A10" WHERE "A10"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A9"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_PROD_SEGMENTS_TXN_F" "A9" WHERE "A9"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A8"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_RESOURCE_TXN_F" "A8" WHERE "A8"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A7"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_TAG_READINGS" "A7" WHERE "A7"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A6"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_TAG_READINGS_ERR" "A6" WHERE "A6"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A5"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_TAG_READINGS_T_STG" "A5" WHERE "A5"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL) UNION ALL (SELECT DISTINCT "A4"."SHIFT_WORKDAY_FK_KEY" "SHIFT_WORKDAY_FK_KEY" FROM "MTH"."MTH_USER_ENTITIES_EXT_B" "A4" WHERE "A4"."SHIFT_WORKDAY_FK_KEY" IS NOT NULL)) "A2","MTH"."MTH_WORKDAY_SHIFTS_D" "A1" WHERE "A2"."SHIFT_WORKDAY_FK_KEY"="A1"."SHIFT_WORKDAY_PK_KEY" GROUP BY "A1"."PLANT_FK_KEY"
[Home] [Help]