APPS.MTH_EVENT_GEN_PKG dependencies on MTH_EQUIPMENT_SHIFTS_D

Line 104: MTH_EQUIPMENT_SHIFTS_D ESD

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
108: SHIFTS.EQUIPMENT_FK_KEY =ESD.EQUIPMENT_FK_KEY AND

Line 213: MTH_EQUIPMENT_SHIFTS_D ESD

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
217: SHIFTS.EQUIPMENT_FK_KEY =ESD.EQUIPMENT_FK_KEY AND