APPS.MTH_EVENT_GEN_PKG dependencies on MTH_EVENTS

Line 55: FROM MTH_EVENTS EVENTS1,

51: EQP_IDLE_PER.STATUS STATUS,
52: EQP_IDLE_PER.DURATION_IN_MINUTES DURATION_IN_MINUTES,
53: EQP_IDLE_PER.LAG_STATUS LAG_STATUS,
54: EQP_IDLE_PER.LEAD_STATUS LEAD_STATUS
55: FROM MTH_EVENTS EVENTS1,
56: (SELECT IDLE_PER.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
57: IDLE_PER.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
58: IDLE_PER.FROM_DATE FROM_DATE,
59: CASE WHEN (Lead( IDLE_PER.STATUS, 1) OVER(PARTITION BY IDLE_PER.EQUIPMENT_FK_KEY , IDLE_PER.SHIFT_WORKDAY_FK_KEY ORDER BY IDLE_PER.FROM_DATE )) IS NULL

Line 155: FROM MTH_EVENTS EVENTS1, (SELECT RNA.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,

151: equip_down_pd.STATUS STATUS,
152: equip_down_pd.LAG_STATUS LAG_STATUS,
153: equip_down_pd.LEAD_STATUS LEAD_STATUS,
154: equip_down_pd.DURATION_IN_MINUTES DURATION_IN_MINUTES
155: FROM MTH_EVENTS EVENTS1, (SELECT RNA.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
156: RNA.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
157: RNA.FROM_DATE FROM_DATE,
158: CASE WHEN (Lead( RNA.STATUS, 1) OVER(PARTITION BY RNA.EQUIPMENT_FK_KEY,RNA.SHIFT_WORKDAY_FK_KEY ORDER BY RNA.FROM_DATE )) IS NULL
159: THEN RNA.TO_DATE

Line 266: FROM MTH_EVENTS EVENTS1, (SELECT EOS.EQUIPMENT_FK_KEY ,

262: OS.WORKORDER_FK_KEY WORKORDER_FK_KEY,
263: OS.TOTAL_SCRAP QTY_SCRAP,
264: OS.TOTAL_REWORK QTY_REWORK,
265: OS.TOTAL_OUTPUT QTY_OUTPUT
266: FROM MTH_EVENTS EVENTS1, (SELECT EOS.EQUIPMENT_FK_KEY ,
267: EOS.SHIFT_WORKDAY_FK_KEY,
268: EOS.WORKORDER_FK_KEY,
269: SUM(EOS.QTY_SCRAP) TOTAL_SCRAP,
270: SUM(EOS.QTY_REWORK) TOTAL_REWORK,

Line 323: FROM MTH_EVENTS EVENTS1, (SELECT EOS.EQUIPMENT_FK_KEY ,

319: OS.WORKORDER_FK_KEY WORKORDER_FK_KEY,
320: OS.TOTAL_SCRAP QTY_SCRAP,
321: OS.TOTAL_REWORK QTY_REWORK,
322: OS.TOTAL_OUTPUT QTY_OUTPUT
323: FROM MTH_EVENTS EVENTS1, (SELECT EOS.EQUIPMENT_FK_KEY ,
324: EOS.SHIFT_WORKDAY_FK_KEY,
325: EOS.WORKORDER_FK_KEY,
326: SUM(EOS.QTY_SCRAP) TOTAL_SCRAP,
327: SUM(EOS.QTY_REWORK) TOTAL_REWORK,