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_RAW_PROCESSED

Line 137: FROM MTH_TAG_READINGS_RAW_PROCESSED RP

133: MAX(RP.QUALITY_FLAG) QUALITY_FLAG,
134: MAX(RP.CREATION_DATE) CREATION_DATE ,
135: -- COUNT(RP.TAG_CODE) DUP_COUNT,
136: 'DUP' ERROR_CODE
137: FROM MTH_TAG_READINGS_RAW_PROCESSED RP
138: GROUP BY RP.READING_TIME , RP.TAG_CODE
139: HAVING COUNT(RP.TAG_CODE) > 1
140: ) ;
141: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_RAW_ERR while proceesing the data from tag readings raw processed table - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line 204: MTH_TAG_READINGS_RAW_PROCESSED RP

200: MAX(RP.CREATION_DATE) CREATION_DATE,
201: COUNT(RP.TAG_CODE) DUP_COUNT
202: FROM
203:
204: MTH_TAG_READINGS_RAW_PROCESSED RP
205: GROUP BY
206: RP.READING_TIME , RP.TAG_CODE ) RAW_DATA ,MTH_TAG_MASTER TM ,MTH_TAG_DESTINATION_MAP TDM ,MTH_EQUIPMENTS_D EQP
207: WHERE
208: RAW_DATA.TAG_CODE = TM.TAG_CODE

Line 298: MTH_TAG_READINGS_RAW_PROCESSED RP

294: MAX(RP.QUALITY_FLAG) QUALITY_FLAG,
295: MAX(RP.CREATION_DATE) CREATION_DATE,
296: COUNT(RP.TAG_CODE) DUP_COUNT
297: FROM
298: MTH_TAG_READINGS_RAW_PROCESSED RP
299: --WHERE (r.CREATION_DATE >= v_log_from_date and r.CREATION_DATE < v_log_to_date )
300: GROUP BY
301: RP.READING_TIME , RP.TAG_CODE ) RAW_DATA ,MTH_TAG_MASTER TM ,MTH_TAG_DESTINATION_MAP TDM ,MTH_EQUIPMENTS_D EQP
302: WHERE

Line 1583: * into meter readings table MTH_TAG_READINGS_RAW_PROCESSED *

1579:
1580: /* ****************************************************************************
1581: * Procedure : mth_recal_tag_raw_to_processed *
1582: * Description :Load data from the table MTH_TAG_READINGS_RAW *
1583: * into meter readings table MTH_TAG_READINGS_RAW_PROCESSED *
1584: * File Name :MTHTAGB.PLS *
1585: * Visibility :Private *
1586: * Parameters :p_curr_partition (value of the partition column *
1587: * :p_from_tz (value for from time zone ) *

Line 1596: INSERT INTO MTH_TAG_READINGS_RAW_PROCESSED

1592: VARCHAR2, p_to_tz IN VARCHAR2,p_ret_code OUT NOCOPY NUMBER)
1593: IS
1594: BEGIN
1595: -- Insert the data into the mth_tag_readings_processed table
1596: INSERT INTO MTH_TAG_READINGS_RAW_PROCESSED
1597: ( GROUP_ID,
1598: READING_TIME ,
1599: TAG_CODE,
1600: TAG_DATA,

Line 2198: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED;

2194:
2195: DELETE FROM MTH_TAG_READINGS_RAW_ERR;
2196: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_RAW_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2197:
2198: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED;
2199: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_RAW_PROCESSED - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
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);

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

2195: DELETE FROM MTH_TAG_READINGS_RAW_ERR;
2196: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_RAW_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2197:
2198: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED;
2199: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_RAW_PROCESSED - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
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:

Line 2261: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED;

2257: END IF;
2258:
2259: IF(p_ret_code <> 2) THEN
2260:
2261: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED;
2262: MTH_GEN_HDL_EVENTS_READINGS();
2263: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_READINGS_ERRORS_TO_STG();
2264: IF(p_ret_code <> 2) THEN
2265: mth_util_pkg.log_msg('MTH_READINGS_ERRORS_TO_STG completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);

Line 2396: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED;

2392: --Dbms_Output.put_line('p_ret_code3' || p_ret_code);
2393:
2394: IF(p_ret_code <> 2) THEN
2395:
2396: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED;
2397: MTH_GEN_HDL_EVENTS_READINGS();
2398: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_READINGS_ERRORS_TO_STG();
2399: IF(p_ret_code <> 2) THEN
2400: mth_util_pkg.log_msg('MTH_READINGS_ERRORS_TO_STG completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);

Line 2501: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED ;

2497: l_sql_stmt:= 'BEGIN ' || ' v_desc' || ' :1; ' || 'END;';
2498: EXECUTE IMMEDIATE l_sql_stmt USING OUT v_ret_code;
2499: IF(v_ret_code <> 2)
2500: THEN
2501: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED ;
2502: /* p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_READINGS_ERRORS_TO_STG();
2503: IF(p_ret_code <> 2)
2504: THEN */
2505: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_TAG_BASED_CONTEXTUALIZE();