APPS.MTH_UTIL_PKG dependencies on MTH_TAG_READINGS_ERR

Line 2129: and mth_tag_readings_err *

2125: /* ****************************************************************************
2126: * Function :GET_PREV_TAG_READING *
2127: * Description :This function is used to retrive the previous reading *
2128: * from mth_tag_readings_stg, mth_tag_readings, *
2129: and mth_tag_readings_err *
2130: * for the given tag_code and reading time is earlier than *
2131: * the reading time specified and within the range specified *
2132: * by the range_in_hour *
2133: * File Name :MTHUTILB.PLS *

Line 2191: FROM mth_tag_readings_err

2187: CURSOR c_readings_err (p_tag_code IN VARCHAR2,
2188: p_start_reading_time IN DATE,
2189: p_end_reading_time IN DATE) IS
2190: SELECT tag_data, reading_time
2191: FROM mth_tag_readings_err
2192: WHERE tag_code = p_tag_code AND
2193: reading_time < p_start_reading_time AND
2194: reading_time >= p_end_reading_time
2195: ORDER BY reading_time desc;

Line 2241: and mth_tag_readings_err *

2237: /* ****************************************************************************
2238: * Procedure :GET_PREV_TAG_READING_INFO *
2239: * Description :This function is used to retrive the previous reading *
2240: * from mth_tag_readings_stg, mth_tag_readings, *
2241: and mth_tag_readings_err *
2242: * for the given tag_code and reading time is earlier than *
2243: * the reading time specified and within the range specified *
2244: * by the range_in_hour *
2245: * File Name :MTHUTILB.PLS *

Line 2314: FROM mth_tag_readings_err

2310: CURSOR c_readings_err (p_tag_code IN VARCHAR2,
2311: p_start_reading_time IN DATE,
2312: p_end_reading_time IN DATE) IS
2313: SELECT tag_data, reading_time, equipment_fk_key
2314: FROM mth_tag_readings_err
2315: WHERE tag_code = p_tag_code AND
2316: reading_time < p_start_reading_time AND
2317: reading_time >= p_end_reading_time
2318: ORDER BY reading_time desc;

Line 2382: and mth_tag_readings_err *

2378: /* ****************************************************************************
2379: * Procedure :GET_PREV_TAG_READING_SET *
2380: * Description :This function is used to retrive the previous reading set *
2381: * from mth_tag_readings_stg, mth_tag_readings, *
2382: and mth_tag_readings_err *
2383: * for the given tag_codes and reading time is earlier than *
2384: * the reading time specified and within the range specified *
2385: * by the range_in_hour. The reading set bounded by the same *
2386: * group id contains both tags *

Line 2439: FROM mth_tag_readings_err r1, mth_tag_readings_err r2

2435: r2.tag_code = p_tag_code2
2436: UNION ALL
2437: SELECT r1.tag_data tag_data1, r1.reading_time reading_time1,
2438: r2.tag_data tag_data2, r2.reading_time reading_time2
2439: FROM mth_tag_readings_err r1, mth_tag_readings_err r2
2440: WHERE r1.group_id = r2.GROUP_id AND
2441: r1.reading_time < p_reading_time1 AND
2442: r2.reading_time < p_reading_time2 AND
2443: r1.reading_time >= p_end_time AND

Line 2533: FROM mth_tag_readings_err

2529: reading_time >= p_end_time AND
2530: tag_code = p_tag_code
2531: UNION ALL
2532: SELECT tag_data, reading_time
2533: FROM mth_tag_readings_err
2534: WHERE reading_time < p_reading_time AND
2535: reading_time >= p_end_time AND
2536: tag_code = p_tag_code
2537: )