eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTH_PROD_DATA_PROCESS_PKG dependencies on MTH_EQUIPMENT_SHIFTS_D

Line 250: FROM MTH_EQUIPMENT_SHIFTS_D

246: shift_workday_fk_key,
247: from_date,
248: To_Date,
249: availability_flag
250: FROM MTH_EQUIPMENT_SHIFTS_D
251: WHERE equipment_fk_key = p_equipment_fk_key AND
252: from_date IS NOT NULL AND
253: to_date IS NOT NULL AND
254: from_date <> To_Date AND

Line 289: FROM MTH_EQUIPMENT_SHIFTS_D

285: lead ( from_date )
286: OVER ( PARTITION BY EQUIPMENT_FK_KEY
287: ORDER BY from_date ) - 1/86400 catch_all_to_date,
288: To_Date + 1/86400 catch_all_from_date
289: FROM MTH_EQUIPMENT_SHIFTS_D
290: WHERE equipment_fk_key = p_equipment_fk_key AND
291: from_date is not null and
292: to_date is not null and
293: from_date <> to_date and

Line 303: FROM MTH_EQUIPMENT_SHIFTS_D

299: mth_hour_d h ,
300: (SELECT equipment_fk_key,
301: shift_workday_fk_key,
302: availability_date
303: FROM MTH_EQUIPMENT_SHIFTS_D
304: WHERE (from_date = To_Date OR
305: from_date IS NULL AND To_Date IS NULL) AND
306: equipment_fk_key = p_equipment_fk_key) cs
307: WHERE s.equipment_fk_key = p_equipment_fk_key AND

Line 392: MTH_EQUIPMENT_SHIFTS_D s,

388: o.READING_TIME + 4000 actual_from_date, -- As a place holder
389: o.READING_TIME actual_to_date
390: FROM MTH_EQUIP_OUTPUT o,
391: MTH_EQUIPMENTS_D e,
392: MTH_EQUIPMENT_SHIFTS_D s,
393: (SELECT from_date, To_Date
394: FROM MTH_RUN_LOG
395: WHERE fact_table = 'MTH_EQUIP_PROD_PERFORMANCE_F' AND
396: ROWNUM = 1) rl

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 931: mth_equipment_shifts_d shift,

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
935: AND sts.hour_fk_key = mhd.hour_pk_key