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

Line 100: FROM MTH_EQUIP_STATUSES ES

96: ES.FROM_DATE FROM_DATE,
97: ES.TO_DATE TO_DATE,
98: ES.STATUS STATUS,
99: ES.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY
100: FROM MTH_EQUIP_STATUSES ES
101: WHERE ES.LAST_UPDATE_DATE >= v_log_from_date Or ES.TO_DATE IS NULL ) AGG_INPUT
102: GROUP BY AGG_INPUT.EQUIPMENT_FK_KEY , AGG_INPUT.SHIFT_WORKDAY_FK_KEY ) SHIFTS ,
103: MTH_EQUIP_STATUSES ES,
104: MTH_EQUIPMENT_SHIFTS_D ESD

Line 103: MTH_EQUIP_STATUSES ES,

99: ES.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY
100: FROM MTH_EQUIP_STATUSES ES
101: WHERE ES.LAST_UPDATE_DATE >= v_log_from_date Or ES.TO_DATE IS NULL ) AGG_INPUT
102: GROUP BY AGG_INPUT.EQUIPMENT_FK_KEY , AGG_INPUT.SHIFT_WORKDAY_FK_KEY ) SHIFTS ,
103: MTH_EQUIP_STATUSES ES,
104: MTH_EQUIPMENT_SHIFTS_D ESD
105: WHERE SHIFTS.SHIFT_WORKDAY_FK_KEY = ES.SHIFT_WORKDAY_FK_KEY AND
106: SHIFTS.EQUIPMENT_FK_KEY = ES.EQUIPMENT_FK_KEY AND
107: SHIFTS.SHIFT_WORKDAY_FK_KEY = ESD.SHIFT_WORKDAY_FK_KEY AND

Line 208: FROM MTH_EQUIP_STATUSES ES

204: ES.FROM_DATE FROM_DATE,
205: ES.TO_DATE TO_DATE,
206: ES.STATUS STATUS,
207: ES.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY
208: FROM MTH_EQUIP_STATUSES ES
209: WHERE ES.LAST_UPDATE_DATE >= v_log_from_date Or ES.TO_DATE IS NULL ) AGG_INPUT
210: GROUP BY AGG_INPUT.EQUIPMENT_FK_KEY ,
211: AGG_INPUT.SHIFT_WORKDAY_FK_KEY ) SHIFTS ,
212: MTH_EQUIP_STATUSES ES ,

Line 212: MTH_EQUIP_STATUSES ES ,

208: FROM MTH_EQUIP_STATUSES ES
209: WHERE ES.LAST_UPDATE_DATE >= v_log_from_date Or ES.TO_DATE IS NULL ) AGG_INPUT
210: GROUP BY AGG_INPUT.EQUIPMENT_FK_KEY ,
211: AGG_INPUT.SHIFT_WORKDAY_FK_KEY ) SHIFTS ,
212: MTH_EQUIP_STATUSES ES ,
213: MTH_EQUIPMENT_SHIFTS_D ESD
214: WHERE SHIFTS.SHIFT_WORKDAY_FK_KEY = ES.SHIFT_WORKDAY_FK_KEY AND
215: SHIFTS.EQUIPMENT_FK_KEY = ES.EQUIPMENT_FK_KEY AND
216: SHIFTS.SHIFT_WORKDAY_FK_KEY = ESD.SHIFT_WORKDAY_FK_KEY AND

Line 368: generates and handles events from MTH_EQUIP_STATUSES, MTH_TAG_REASON_READINGS, and MTH_EQUIP_OUTPUT_SUMMARY*

364:
365: /* ****************************************************************************
366: * Procedure : MTH_GEN_HDL_EVTS_FROM_STS_OUT *
367: * Description :The new procedure MTH_GEN_HDL_EVTS_FROM_STS_OUT *
368: generates and handles events from MTH_EQUIP_STATUSES, MTH_TAG_REASON_READINGS, and MTH_EQUIP_OUTPUT_SUMMARY*
369: * File Name :MTHEVGB.PLS *
370: * Visibility :Private *
371: * Parameters : *
372: **************************************************************************** */