[Home] [Help]
2124:
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 *
2167: CURSOR c_readings_stg (p_tag_code IN VARCHAR2,
2168: p_start_reading_time IN DATE,
2169: p_end_reading_time IN DATE) IS
2170: SELECT tag_data, reading_time, processed_flag
2171: FROM mth_tag_readings_stg
2172: WHERE tag_code = p_tag_code AND
2173: reading_time < p_start_reading_time AND
2174: reading_time >= p_end_reading_time
2175: ORDER BY reading_time desc;
2236:
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 *
2290: CURSOR c_readings_stg (p_tag_code IN VARCHAR2,
2291: p_start_reading_time IN DATE,
2292: p_end_reading_time IN DATE) IS
2293: SELECT tag_data, reading_time, equipment_fk_key
2294: FROM mth_tag_readings_stg
2295: WHERE tag_code = p_tag_code AND
2296: reading_time < p_start_reading_time AND
2297: reading_time >= p_end_reading_time
2298: ORDER BY reading_time desc;
2377:
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 *
2413: SELECT tag_data1, reading_time1, tag_data2, reading_time2
2414: FROM (
2415: SELECT r1.tag_data tag_data1, r1.reading_time reading_time1,
2416: r2.tag_data tag_data2, r2.reading_time reading_time2
2417: FROM mth_tag_readings_stg r1, mth_tag_readings_stg r2
2418: WHERE r1.group_id = r2.GROUP_id AND
2419: r1.reading_time < p_reading_time1 AND
2420: r2.reading_time < p_reading_time2 AND
2421: r1.reading_time >= p_end_time AND
2517: p_end_time IN DATE) IS
2518: SELECT tag_data, reading_time
2519: FROM (
2520: SELECT tag_data, reading_time
2521: FROM mth_tag_readings_stg
2522: WHERE reading_time < p_reading_time AND
2523: reading_time >= p_end_time AND
2524: tag_code = p_tag_code
2525: UNION ALL