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_LOAD_TAG_READINGS_PKG dependencies on MTH_TAG_READINGS_LATEST

Line 1631: -- Update/Create entry in MTH_TAG_READINGS_LATEST

1627: r.USER_MEASURE5,
1628: r.QUALITY_FLAG
1629: FROM MTH_TAG_READINGS_RAW r);
1630:
1631: -- Update/Create entry in MTH_TAG_READINGS_LATEST
1632:
1633: UPDATE MTH_TAG_READINGS_LATEST latest
1634: SET (latest.reading_time,latest.tag_value)= ( SELECT a.reading_time,rraw.tag_data FROM mth_tag_readings_raw rraw ,
1635: ( SELECT r.tag_code,Max(r.reading_time) reading_time FROM mth_tag_readings_raw r

Line 1633: UPDATE MTH_TAG_READINGS_LATEST latest

1629: FROM MTH_TAG_READINGS_RAW r);
1630:
1631: -- Update/Create entry in MTH_TAG_READINGS_LATEST
1632:
1633: UPDATE MTH_TAG_READINGS_LATEST latest
1634: SET (latest.reading_time,latest.tag_value)= ( SELECT a.reading_time,rraw.tag_data FROM mth_tag_readings_raw rraw ,
1635: ( SELECT r.tag_code,Max(r.reading_time) reading_time FROM mth_tag_readings_raw r
1636: GROUP BY r.tag_code)a ,mth_tag_readings_latest l
1637: WHERE rraw.reading_time=a.reading_time

Line 1636: GROUP BY r.tag_code)a ,mth_tag_readings_latest l

1632:
1633: UPDATE MTH_TAG_READINGS_LATEST latest
1634: SET (latest.reading_time,latest.tag_value)= ( SELECT a.reading_time,rraw.tag_data FROM mth_tag_readings_raw rraw ,
1635: ( SELECT r.tag_code,Max(r.reading_time) reading_time FROM mth_tag_readings_raw r
1636: GROUP BY r.tag_code)a ,mth_tag_readings_latest l
1637: WHERE rraw.reading_time=a.reading_time
1638: AND rraw.tag_code=a.tag_code
1639: AND a.tag_code IN l.tag_code
1640: AND l.reading_time

Line 1647: INSERT INTO MTH_TAG_READINGS_LATEST

1643:
1644:
1645:
1646:
1647: INSERT INTO MTH_TAG_READINGS_LATEST
1648: ( TAG_CODE,
1649: READING_TIME,
1650: TAG_VALUE)
1651: ( SELECT a.tag_code,a.reading_time,rraw.tag_data FROM mth_tag_readings_raw rraw ,

Line 1657: FROM mth_tag_readings_latest l

1653: GROUP BY r.tag_code)a
1654: WHERE rraw.reading_time=a.reading_time
1655: AND rraw.tag_code=a.tag_code
1656: AND NOT EXISTS (SELECT tag_code
1657: FROM mth_tag_readings_latest l
1658: WHERE rraw.tag_code = l.tag_code)
1659:
1660: ) ;
1661: p_ret_code := 0;

Line 2189: DELETE FROM MTH_TAG_READINGS_LATEST;

2185: mth_util_pkg.switch_column_default_value ( 'MTH_TAG_READINGS_RAW', v_current_processing_flag);
2186: SELECT Count(*) INTO v_reprocess_flag FROM MTH_TAG_READINGS_ERR WHERE RE_PROCESS_FLAG='Y';
2187:
2188: --delete all the tables
2189: DELETE FROM MTH_TAG_READINGS_LATEST;
2190: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINSG_LATEST - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2191:
2192: DELETE FROM MTH_TAG_READINGS_UNPROCESS_ERR;
2193: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_UNPROCESS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);