APPS.MTH_PROCESS_REASON_PKG dependencies on MTH_TAG_READINGS

Line 109: FROM mth_tag_readings mtr

105: FROM (SELECT mth_entity,
106: equipment_fk_key,
107: tag_data,
108: reading_time
109: FROM mth_tag_readings mtr
110: WHERE processed_flag = 0
111: UNION
112: SELECT mth_entity,
113: equipment_fk_key,

Line 116: FROM mth_tag_readings_err mte

112: SELECT mth_entity,
113: equipment_fk_key,
114: tag_data,
115: reading_time
116: FROM mth_tag_readings_err mte
117: WHERE mte.processed_flag = 0) mtr,
118: mth_equip_statuses mes
119: WHERE mtr.reading_time = mes.reading_time
120: AND mtr.equipment_fk_key = mes.equipment_fk_key

Line 137: FROM mth_tag_readings mtr

133: FROM (SELECT mth_entity,
134: equipment_fk_key,
135: tag_data,
136: reading_time
137: FROM mth_tag_readings mtr
138: WHERE processed_flag = 0
139: UNION
140: SELECT mth_entity,
141: equipment_fk_key,

Line 144: FROM mth_tag_readings_err mte

140: SELECT mth_entity,
141: equipment_fk_key,
142: tag_data,
143: reading_time
144: FROM mth_tag_readings_err mte
145: WHERE mte.processed_flag = 0) mtr,
146: mth_equip_output meo
147: WHERE mtr.reading_time = meo.reading_time
148: AND mtr.equipment_fk_key = meo.equipment_fk_key

Line 153: UPDATE mth_tag_readings mtr

149: AND meo.last_update_date <= v_log_date
150: AND mtr.mth_entity = 13);
151: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_REASON_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
152:
153: UPDATE mth_tag_readings mtr
154: SET mtr.last_update_date = SYSDATE,
155: mtr.processed_flag = 1
156: WHERE EXISTS
157: ( SELECT 1

Line 164: UPDATE mth_tag_readings_err mtr

160: AND Decode(mtrr.reason_type,1,8,2,13,3,17) = mtr.mth_entity
161: AND mtrr.equipment_fk_key = mtr.equipment_fk_key
162: AND mtr.processed_flag = 0 ) ;
163:
164: UPDATE mth_tag_readings_err mtr
165: SET mtr.processed_flag = 1
166: WHERE EXISTS
167: ( SELECT 1
168: FROM mth_tag_reason_readings mtrr

Line 174: mth_util_pkg.log_msg('No. of rows updated in MTH_TAG_READINGS : '||SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

170: AND Decode(mtrr.reason_type,1,8,2,13,3,17) = mtr.mth_entity
171: AND mtrr.equipment_fk_key = mtr.equipment_fk_key
172: AND mtr.processed_flag = 0 ) ;
173:
174: mth_util_pkg.log_msg('No. of rows updated in MTH_TAG_READINGS : '||SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
175:
176: ----Call mth_run_log_post_load
177: mth_util_pkg.mth_run_log_post_load('MTH_TAG_REASON_READINGS',v_unassigned_val);
178:

Line 230: FROM mth_tag_readings

226: FROM (SELECT mth_entity,
227: equipment_fk_key,
228: tag_data,
229: reading_time
230: FROM mth_tag_readings
231: WHERE PROCESSED_FLAG = 0
232: AND mth_entity IN (8,17)
233: UNION
234: SELECT Decode(reason_type,1,8),

Line 245: FROM mth_tag_readings_err

241: SELECT mth_entity,
242: equipment_fk_key,
243: tag_data,
244: reading_time
245: FROM mth_tag_readings_err
246: WHERE processed_flag = 0
247: AND mth_entity IN (8,17)) mtr,
248: mth_equip_statuses mes
249: WHERE mtr.reading_time = mes.reading_time

Line 267: FROM mth_tag_readings mtr

263: FROM (SELECT mth_entity,
264: equipment_fk_key,
265: tag_data,
266: reading_time
267: FROM mth_tag_readings mtr
268: WHERE PROCESSED_FLAG = 0
269: UNION
270: SELECT mth_entity,
271: equipment_fk_key,

Line 274: FROM mth_tag_readings_err mte

270: SELECT mth_entity,
271: equipment_fk_key,
272: tag_data,
273: reading_time
274: FROM mth_tag_readings_err mte
275: WHERE mte.processed_flag = 0
276: ) mtr,
277: mth_equip_output meo
278: WHERE mtr.reading_time = meo.reading_time

Line 315: UPDATE mth_tag_readings mtr

311: );
312:
313: mth_util_pkg.log_msg('No. of rows merged in mth_tag_reason_readings : '||SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
314:
315: UPDATE mth_tag_readings mtr
316: SET mtr.last_update_date = SYSDATE,
317: mtr.processed_flag = 1
318: WHERE EXISTS
319: ( SELECT 1

Line 326: UPDATE mth_tag_readings_err mtr

322: AND Decode(mtrr.reason_type,1,8,2,13,3,17) = mtr.mth_entity
323: AND mtrr.equipment_fk_key = mtr.equipment_fk_key
324: AND mtr.processed_flag = 0 ) ;
325:
326: UPDATE mth_tag_readings_err mtr
327: SET mtr.processed_flag = 1
328: WHERE EXISTS
329: ( SELECT 1
330: FROM mth_tag_reason_readings mtrr

Line 336: mth_util_pkg.log_msg('No. of rows updated in mth_tag_readings : '||SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

332: AND Decode(mtrr.reason_type,1,8,2,13,3,17) = mtr.mth_entity
333: AND mtrr.equipment_fk_key = mtr.equipment_fk_key
334: AND mtr.processed_flag = 0 ) ;
335:
336: mth_util_pkg.log_msg('No. of rows updated in mth_tag_readings : '||SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
337:
338: -- Call mth_run_log_post_load
339: mth_util_pkg.mth_run_log_post_load('MTH_TAG_REASON_READINGS',v_unassigned_val);
340: