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_UTIL_PKG dependencies on MTH_TAG_READINGS_RAW

Line 3449: * Description :Check if the raw from MTH_TAG_READINGS_RAW is valid *

3445:
3446:
3447: /* ****************************************************************************
3448: * Function :MTH_IS_TAG_RAW_DATA_ROW_VALID *
3449: * Description :Check if the raw from MTH_TAG_READINGS_RAW is valid *
3450: * or not. *
3451: * File Name :MTHUTILB.PLS *
3452: * Visibility :Private *
3453: * Parameters :p_tag_code - Tag code *

Line 3539: * Description :Load data from the table MTH_TAG_READINGS_RAW *

3535:
3536:
3537: /* ****************************************************************************
3538: * Procedure :MTH_LOAD_TAG_RAW_TO_PROCESSED *
3539: * Description :Load data from the table MTH_TAG_READINGS_RAW *
3540: * into meter readings table MTH_TAG_READINGS_RAW_PROCESSED *
3541: * File Name :MTHUTILB.PLS *
3542: * Visibility :Private *
3543: * Parameters :p_curr_partition (value of the partition column *

Line 3540: * into meter readings table MTH_TAG_READINGS_RAW_PROCESSED *

3536:
3537: /* ****************************************************************************
3538: * Procedure :MTH_LOAD_TAG_RAW_TO_PROCESSED *
3539: * Description :Load data from the table MTH_TAG_READINGS_RAW *
3540: * into meter readings table MTH_TAG_READINGS_RAW_PROCESSED *
3541: * File Name :MTHUTILB.PLS *
3542: * Visibility :Private *
3543: * Parameters :p_curr_partition (value of the partition column *
3544: * :p_from_tz (value for from time zone ) *

Line 3567: FROM MTH_TAG_READINGS_RAW R, MTH_TAG_MASTER T

3563: Decode(DATA_TYPE, 'NUM', 1, 0) IS_NUMBER,
3564: Decode(T.READING_TYPE, 'CHNG', 1, 0) AS IS_CUMULATIVE,
3565: Decode(T.ORDER_TYPE, 'ASC', 1, 0) IS_ASSENDING,
3566: T.INITIAL_VALUE, T.MAX_RESET_VALUE, R.GROUP_ID, R.CREATION_DATE, R.USER_ATTR1, R.USER_ATTR2, R.USER_ATTR3, R.USER_ATTR4, R.USER_ATTR5, R.USER_MEASURE1, R.USER_MEASURE2, R.USER_MEASURE3, R.USER_MEASURE4, R.USER_MEASURE5, R.QUALITY_FLAG
3567: FROM MTH_TAG_READINGS_RAW R, MTH_TAG_MASTER T
3568: WHERE R.PROCESSING_FLAG = p_processing_flag AND
3569: R.TAG_CODE = T.TAG_CODE (+)
3570: ORDER BY TAG_CODE, READING_TIME;
3571:

Line 3682: INSERT INTO MTH_TAG_READINGS_RAW_PROCESSED (GROUP_ID, READING_TIME , TAG_CODE, TAG_DATA, CREATION_DATE, USER_ATTR1, USER_ATTR2, USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_MEASURE1, USER_MEASURE2, USER_MEASURE3, USER_MEASURE4,

3678: r_raw_data.MAX_RESET_VALUE,
3679: v_prev_tag_value);
3680:
3681: -- 2.3.3 Insert the data into the mth_tag_readings_processed table
3682: INSERT INTO MTH_TAG_READINGS_RAW_PROCESSED (GROUP_ID, READING_TIME , TAG_CODE, TAG_DATA, CREATION_DATE, USER_ATTR1, USER_ATTR2, USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_MEASURE1, USER_MEASURE2, USER_MEASURE3, USER_MEASURE4,
3683: USER_MEASURE5, QUALITY_FLAG) VALUES ( r_raw_data.GROUP_ID, r_raw_data.READING_TIME, r_raw_data.TAG_CODE, v_incr_tag_value, r_raw_data.CREATION_DATE, r_raw_data.USER_ATTR1, r_raw_data.USER_ATTR2, r_raw_data.USER_ATTR3,
3684: r_raw_data.USER_ATTR4, r_raw_data.USER_ATTR5, r_raw_data.USER_MEASURE1, r_raw_data.USER_MEASURE2, r_raw_data.USER_MEASURE3, r_raw_data.USER_MEASURE4, r_raw_data.USER_MEASURE5, r_raw_data.QUALITY_FLAG);
3685:
3686: END IF;