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_STATUS_PKG dependencies on MTH_TAG_READINGS

Line 53: FROM mth_tag_readings mtr,

49:
50: IF( (p_mode = 'RECAL') AND (p_source = 'TAG') ) THEN
51: SELECT Count(1)
52: INTO v_tag_reading_count
53: FROM mth_tag_readings mtr,
54: mth_entities mte,
55: mth_run_log mrl
56: WHERE mtr.mth_entity = mte.id
57: AND mte.mth_alias = 'Status'

Line 297: FROM mth_tag_readings readings

293: readings.USER_MEASURE3,
294: readings.USER_MEASURE4,
295: readings.USER_MEASURE5 ,
296: readings.mth_entity
297: FROM mth_tag_readings readings
298: WHERE readings.EQUIPMENT_FK_KEY IS NOT NULL AND
299: readings.HOUR_FK_KEY IS NOT NULL AND
300: -- readings.PROCESSED_FLAG = 0 AND
301: readings.LAST_UPDATE_DATE <= v_log_date AND

Line 319: FROM mth_tag_readings_err err

315: err.USER_MEASURE3,
316: err.USER_MEASURE4,
317: err.USER_MEASURE5 ,
318: err.mth_entity
319: FROM mth_tag_readings_err err
320: WHERE err.EQUIPMENT_FK_KEY IS NOT NULL AND
321: err.HOUR_FK_KEY IS NOT NULL AND
322: --err.PROCESSED_FLAG = 0 AND
323: err.EQUIPMENT_STATUS = 'ACTIVE' AND

Line 337: update MTH_TAG_READINGS t

333: AND r.EQUIPMENT_FK_KEY = s.EQUIPMENT_FK_KEY;
334: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_STATUSES - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
335:
336: --update processed flag in readings table
337: update MTH_TAG_READINGS t
338: set PROCESSED_FLAG = 1,
339: last_update_date=sysdate
340: where exists (
341: select 1

Line 351: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

347: AND m.MTH_ALIAS = 'Status'
348: AND t.LAST_UPDATE_DATE <= v_log_date
349: AND t.TAG_DATA IS NOT NULL
350: );
351: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
352: --update processed flag in readings error table
353: update MTH_TAG_READINGS_ERR t
354: set PROCESSED_FLAG = 1
355: where exists (

Line 353: update MTH_TAG_READINGS_ERR t

349: AND t.TAG_DATA IS NOT NULL
350: );
351: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
352: --update processed flag in readings error table
353: update MTH_TAG_READINGS_ERR t
354: set PROCESSED_FLAG = 1
355: where exists (
356: select 1
357: from mth_entities m

Line 366: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

362: AND m.MTH_ALIAS = 'Status'
363: AND t.EQUIPMENT_STATUS = 'ACTIVE'
364: AND t.TAG_DATA IS NOT NULL
365: );
366: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
367:
368: ----Call mth_run_log_post_load
369: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STATUSES',v_unassigned_val);
370:

Line 458: FROM mth_tag_readings readings

454: readings.USER_MEASURE3,
455: readings.USER_MEASURE4,
456: readings.USER_MEASURE5,
457: readings.mth_entity
458: FROM mth_tag_readings readings
459: WHERE readings.EQUIPMENT_FK_KEY IS NOT NULL AND
460: readings.HOUR_FK_KEY IS NOT NULL AND
461: ( ( readings.PROCESSED_FLAG = 0 AND readings.LAST_UPDATE_DATE > v_log_from_date and readings.LAST_UPDATE_DATE<=v_log_to_date )
462: OR readings.reading_time IN (SELECT i.FROM_DATE

Line 484: FROM mth_tag_readings_err err

480: err.USER_MEASURE3,
481: err.USER_MEASURE4,
482: err.USER_MEASURE5 ,
483: err.mth_entity
484: FROM mth_tag_readings_err err
485: WHERE err.EQUIPMENT_FK_KEY IS NOT NULL AND
486: err.HOUR_FK_KEY IS NOT NULL AND
487: ( err.PROCESSED_FLAG = 0
488: OR err.reading_time IN (SELECT i.FROM_DATE

Line 586: update MTH_TAG_READINGS t

582:
583: --update processed flag in readings table
584:
585:
586: update MTH_TAG_READINGS t
587: set PROCESSED_FLAG = 1,
588: last_update_date=sysdate
589: where exists (
590: select 1

Line 600: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

596: AND t.TAG_DATA IS NOT NULL
597: AND m.MTH_ALIAS = 'Status'
598: AND t.LAST_UPDATE_DATE BETWEEN v_log_from_date and v_log_to_date);
599:
600: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
601:
602:
603: --update processed flag in readings error table
604: update MTH_TAG_READINGS_ERR t

Line 604: update MTH_TAG_READINGS_ERR t

600: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
601:
602:
603: --update processed flag in readings error table
604: update MTH_TAG_READINGS_ERR t
605: set PROCESSED_FLAG = 1
606: where exists (
607: select 1
608: from mth_entities m

Line 617: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

613: AND m.MTH_ALIAS = 'Status'
614: AND t.EQUIPMENT_STATUS = 'ACTIVE'
615: AND t.TAG_DATA IS NOT NULL
616: );
617: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
618:
619: ----Call mth_run_log_post_load
620: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STATUSES',v_unassigned_val);
621:

Line 700: FROM mth_tag_readings r,

696: r.USER_MEASURE2,
697: r.USER_MEASURE3,
698: r.USER_MEASURE4,
699: r.USER_MEASURE5
700: FROM mth_tag_readings r,
701: MTH_ENTITIES e
702: WHERE e.mth_alias = 'Status'
703: AND e.id = r.mth_entity
704: AND r.EQUIPMENT_FK_KEY IS NOT NULL

Line 711: FROM mth_tag_readings i , MTH_ENTITIES e

707: AND r.EQUIPMENT_FK_KEY = nvl(p_equipment_pk_key, r.EQUIPMENT_FK_KEY)
708: AND ( ( r.READING_TIME BETWEEN p_recal_from_date AND p_recal_to_date
709:
710: OR r.READING_TIME IN ((SELECT Max(i.READING_TIME)
711: FROM mth_tag_readings i , MTH_ENTITIES e
712: WHERE e.mth_alias = 'Status'
713: AND e.id = i.mth_entity
714: AND i.READING_TIME < p_recal_from_date
715: AND i.equipment_fk_key = r.equipment_fk_key)

Line 717: FROM mth_tag_readings i, MTH_ENTITIES e

713: AND e.id = i.mth_entity
714: AND i.READING_TIME < p_recal_from_date
715: AND i.equipment_fk_key = r.equipment_fk_key)
716: , (SELECT Min(i.READING_TIME)
717: FROM mth_tag_readings i, MTH_ENTITIES e
718: WHERE e.mth_alias = 'Status'
719: AND e.id = i.mth_entity
720: AND i.READING_TIME > p_recal_to_date
721: AND i.equipment_fk_key = r.equipment_fk_key ) ) )

Line 794: update MTH_TAG_READINGS t

790:
791: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_STATUSES - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
792:
793: --update processed flag in readings table
794: update MTH_TAG_READINGS t
795: set PROCESSED_FLAG = 1,
796: last_update_date=sysdate
797: where exists (
798: select 1

Line 808: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

804: AND t.TAG_DATA IS NOT NULL
805: AND m.MTH_ALIAS = 'Status'
806: AND t.READING_TIME BETWEEN p_recal_from_date AND nvl(p_recal_to_date,t.READING_TIME));
807:
808: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
809:
810:
811: mth_util_pkg.log_msg('RECAL_STATUS_FROM_READING end', mth_util_pkg.G_DBG_PROC_FUN_END);
812: EXCEPTION

Line 3632: FROM mth_tag_readings

3628: IS
3629: SELECT Min(from_time)
3630: FROM mth_hour_d
3631: WHERE (SELECT Min(Max(reading_time))
3632: FROM mth_tag_readings
3633: WHERE reading_time < p_recalc_from_date
3634: GROUP BY equipment_fk_key) BETWEEN from_time AND to_time;*/
3635:
3636: CURSOR c_fetch_from_date

Line 3656: FROM mth_tag_readings

3652: IS
3653: SELECT Max(to_time)
3654: FROM mth_hour_d
3655: WHERE (SELECT Max(Min(reading_time))
3656: FROM mth_tag_readings
3657: WHERE reading_time > v_recalc_to_date
3658: GROUP BY equipment_fk_key) BETWEEN from_time AND to_time;*/
3659:
3660: CURSOR c_fetch_to_date