APPS.MTH_PROD_DATA_PROCESS_PKG dependencies on MTH_EQUIPMENTS_D

Line 391: MTH_EQUIPMENTS_D e,

387: Max(s.To_Date) shift_to_date,
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

Line 732: MTH_EQUIPMENTS_D equip

728: TO_DATE RUN_LOG_TO_DATE
729: FROM MTH_RUN_LOG
730: WHERE FACT_TABLE = 'MTH_EQUIP_NON_PROD_EPP'
731: AND ROWNUM =1) run_log,
732: MTH_EQUIPMENTS_D equip
733: WHERE sts.LAST_UPDATE_DATE > run_log.RUN_LOG_FROM_DATE
734: AND sts.LAST_UPDATE_DATE <= run_log.RUN_LOG_TO_DATE
735: AND equip.EQUIPMENT_PK_KEY = sts.EQUIPMENT_FK_KEY
736: AND Upper(Nvl(equip.PRODUCTION_EQUIPMENT, 'N')) = 'N')sts_new_rows