[Home] [Help]
714: sts_all.To_Date STATUS_TO_DATE,
715: sts_all.STATUS,
716: sts_all.SYSTEM_FK_KEY,
717: sts_all.HOUR_FK_KEY
718: FROM MTH_EQUIP_STATUSES sts_all,
719: (SELECT sts.EQUIPMENT_FK_KEY,
720: sts.SHIFT_WORKDAY_FK_KEY,
721: sts.FROM_DATE STATUS_FROM_DATE,
722: sts.To_Date STATUS_TO_DATE,
722: sts.To_Date STATUS_TO_DATE,
723: sts.STATUS,
724: sts.SYSTEM_FK_KEY,
725: sts.HOUR_FK_KEY
726: FROM MTH_EQUIP_STATUSES sts,
727: (SELECT FACT_TABLE, FROM_DATE RUN_LOG_FROM_DATE,
728: TO_DATE RUN_LOG_TO_DATE
729: FROM MTH_RUN_LOG
730: WHERE FACT_TABLE = 'MTH_EQUIP_NON_PROD_EPP'
915: epp.hour_fk_key,
916: Nvl(epp.actual_to_date,SYSDATE) prod_perf_actual_to_date,
917: epp.last_update_date
918: FROM mth_equip_prod_performance_f epp,
919: mth_equip_statuses sts
920: WHERE epp.equipment_fk_key = sts.equipment_fk_key
921: AND epp.shift_workday_fk_key = sts.shift_workday_fk_key
922: AND epp.hour_fk_key = sts.hour_fk_key)epp,
923: (SELECT sts.equipment_fk_key,
926: sts.from_date,
927: sts.status,
928: Min(sts.To_Date) to_date,
929: Least(Nvl(Min(Decode(sts.To_Date,NULL,mhd.to_time,sts.To_Date)),SYSDATE),Max(shift.To_Date)) status_to_date
930: FROM mth_equip_statuses sts,
931: mth_equipment_shifts_d shift,
932: mth_hour_d mhd
933: WHERE sts.equipment_fk_key = shift.equipment_fk_key
934: AND sts.shift_workday_fk_key = shift.shift_workday_fk_key
1086: epp.workorder_fk_key,
1087: epp.segment_fk_key,
1088: epp.shift_workday_fk_key,
1089: epp.hour_fk_key) epp,
1090: mth_equip_statuses sts
1091: WHERE epp.equipment_fk_key = sts.equipment_fk_key
1092: AND ((epp.actual_from_date >= sts.from_date AND epp.actual_from_date <= sts.to_date)
1093: OR (epp.actual_to_date >= sts.from_date AND epp.actual_to_date <= sts.to_date )
1094: OR (sts.from_date >= epp.actual_from_date AND sts.from_date <= epp.actual_to_date ))