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_PROCESS_REASON_PKG dependencies on MTH_EQUIP_STATUSES

Line 118: mth_equip_statuses mes

114: tag_data,
115: reading_time
116: FROM mth_tag_readings_err mte
117: WHERE mte.processed_flag = 0) mtr,
118: mth_equip_statuses mes
119: WHERE mtr.reading_time = mes.reading_time
120: AND mtr.equipment_fk_key = mes.equipment_fk_key
121: AND mes.last_update_date <= v_log_date
122: AND mtr.mth_entity IN (8,17)

Line 248: mth_equip_statuses mes

244: reading_time
245: FROM mth_tag_readings_err
246: WHERE processed_flag = 0
247: AND mth_entity IN (8,17)) mtr,
248: mth_equip_statuses mes
249: WHERE mtr.reading_time = mes.reading_time
250: AND mtr.equipment_fk_key = mes.equipment_fk_key
251: AND mes.last_update_date BETWEEN v_run_log_from_date AND v_run_log_to_date
252: AND mtr.mth_entity IN (8,17)