APPS.MTH_PROD_DATA_PROCESS_PKG dependencies on MTH_HOUR_D

Line 260: mth_hour_d h

256: p_actual_from_date BETWEEN from_date AND To_Date OR
257: from_date BETWEEN p_actual_from_date AND p_actual_to_date OR
258: To_Date BETWEEN p_actual_from_date AND p_actual_to_date )
259: ) s,
260: mth_hour_d h
261: WHERE equipment_fk_key = p_equipment_fk_key AND
262: s.from_date IS NOT NULL AND
263: s.to_date IS NOT NULL AND
264: s.from_date <> s.To_Date AND

Line 299: mth_hour_d h ,

295: v_b_time_4_cs BETWEEN from_date AND To_Date OR
296: from_date BETWEEN v_b_time_4_cs AND p_actual_to_date OR
297: To_Date BETWEEN v_b_time_4_cs AND p_actual_to_date )
298: )s,
299: mth_hour_d h ,
300: (SELECT equipment_fk_key,
301: shift_workday_fk_key,
302: availability_date
303: FROM MTH_EQUIPMENT_SHIFTS_D

Line 740: MTH_EQUIPMENT_SHIFTS_D es, MTH_HOUR_D h

736: AND Upper(Nvl(equip.PRODUCTION_EQUIPMENT, 'N')) = 'N')sts_new_rows
737: WHERE sts_all.EQUIPMENT_FK_KEY = sts_new_rows.EQUIPMENT_FK_KEY
738: AND sts_all.SHIFT_WORKDAY_FK_KEY = sts_new_rows.SHIFT_WORKDAY_FK_KEY
739: AND sts_all.HOUR_FK_KEY = sts_new_rows.HOUR_FK_KEY ) agg_sts,
740: MTH_EQUIPMENT_SHIFTS_D es, MTH_HOUR_D h
741: WHERE es.ENTITY_TYPE = 'EQUIPMENT'
742: AND es.SHIFT_WORKDAY_FK_KEY = agg_sts.SHIFT_WORKDAY_FK_KEY
743: AND es.EQUIPMENT_FK_KEY = agg_sts.EQUIPMENT_FK_KEY
744: AND h.HOUR_PK_KEY = agg_sts.HOUR_FK_KEY

Line 932: mth_hour_d mhd

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
935: AND sts.hour_fk_key = mhd.hour_pk_key
936: GROUP BY sts.equipment_fk_key,