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_STG_ERR

Line 147: MTH_TAG_READINGS_STG_ERR

143: ---Inserting records missing equipment or plant or incorrect status information or missing mth entity,attribute group and attribute information in tag readings staging error table
144:
145: INSERT
146: INTO
147: MTH_TAG_READINGS_STG_ERR
148: (GROUP_ID,
149: READING_TIME,
150: TAG_CODE,
151: TAG_DATA,

Line 229: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_STG_ERR while proceesing the data from tag readings raw processed table- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

225: AND TDM.ATTRIBUTE IS NULL )
226: )
227: )
228: ;
229: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_STG_ERR while proceesing the data from tag readings raw processed table- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
230:
231: -- Inserting records in tag readings staging table
232: INSERT
233: INTO

Line 2204: DELETE FROM MTH_TAG_READINGS_STG_ERR;

2200:
2201: DELETE FROM MTH_TAG_READINGS;
2202: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2203:
2204: DELETE FROM MTH_TAG_READINGS_STG_ERR;
2205: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_STG_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2206:
2207: DELETE FROM MTH_TAG_READINGS_ERR;
2208: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line 2205: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_STG_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

2201: DELETE FROM MTH_TAG_READINGS;
2202: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2203:
2204: DELETE FROM MTH_TAG_READINGS_STG_ERR;
2205: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_STG_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2206:
2207: DELETE FROM MTH_TAG_READINGS_ERR;
2208: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2209: