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_PROCESS_REASON_PKG dependencies on MTH_TAG_REASON_READINGS

Line 81: mth_util_pkg.mth_run_log_pre_load('MTH_TAG_REASON_READINGS',v_unassigned_val,'INITIAL',NULL,0,v_log_date);

77: v_log_date := sysdate;
78: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
79:
80: -- Call mth_run_log_pre_load
81: mth_util_pkg.mth_run_log_pre_load('MTH_TAG_REASON_READINGS',v_unassigned_val,'INITIAL',NULL,0,v_log_date);
82:
83: --delete status table
84: DELETE FROM MTH_TAG_REASON_READINGS;
85: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_REASON_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line 84: DELETE FROM MTH_TAG_REASON_READINGS;

80: -- Call mth_run_log_pre_load
81: mth_util_pkg.mth_run_log_pre_load('MTH_TAG_REASON_READINGS',v_unassigned_val,'INITIAL',NULL,0,v_log_date);
82:
83: --delete status table
84: DELETE FROM MTH_TAG_REASON_READINGS;
85: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_REASON_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
86:
87: INSERT INTO mth_tag_reason_readings(reason_type,
88: equipment_fk_key,

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

81: mth_util_pkg.mth_run_log_pre_load('MTH_TAG_REASON_READINGS',v_unassigned_val,'INITIAL',NULL,0,v_log_date);
82:
83: --delete status table
84: DELETE FROM MTH_TAG_REASON_READINGS;
85: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_REASON_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
86:
87: INSERT INTO mth_tag_reason_readings(reason_type,
88: equipment_fk_key,
89: from_date,

Line 87: INSERT INTO mth_tag_reason_readings(reason_type,

83: --delete status table
84: DELETE FROM MTH_TAG_REASON_READINGS;
85: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_REASON_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
86:
87: INSERT INTO mth_tag_reason_readings(reason_type,
88: equipment_fk_key,
89: from_date,
90: To_Date,
91: reason_code,

Line 151: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_REASON_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

147: WHERE mtr.reading_time = meo.reading_time
148: AND mtr.equipment_fk_key = meo.equipment_fk_key
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

Line 158: FROM mth_tag_reason_readings mtrr

154: SET mtr.last_update_date = SYSDATE,
155: mtr.processed_flag = 1
156: WHERE EXISTS
157: ( SELECT 1
158: FROM mth_tag_reason_readings mtrr
159: WHERE mtrr.reading_time = mtr.reading_time
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 ) ;

Line 168: FROM mth_tag_reason_readings mtrr

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
169: WHERE mtrr.reading_time = mtr.reading_time
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 ) ;

Line 177: mth_util_pkg.mth_run_log_post_load('MTH_TAG_REASON_READINGS',v_unassigned_val);

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:
179:
180: mth_util_pkg.log_msg('INIT_REASONS_FROM_READING end', mth_util_pkg.G_DBG_PROC_FUN_END);
181: EXCEPTION

Line 210: mth_util_pkg.mth_run_log_pre_load('MTH_TAG_REASON_READINGS',v_unassigned_val,'INCR',NULL,0,v_log_date);

206: v_log_date := sysdate;
207: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
208:
209: -- Call mth_run_log_pre_load
210: mth_util_pkg.mth_run_log_pre_load('MTH_TAG_REASON_READINGS',v_unassigned_val,'INCR',NULL,0,v_log_date);
211:
212: -- Get to and from date from run log
213: mth_util_pkg.GET_RUN_LOG_DATES('MTH_TAG_REASON_READINGS',NULL,NULL,NULL,v_run_log_from_date,v_run_log_to_date);
214:

Line 213: mth_util_pkg.GET_RUN_LOG_DATES('MTH_TAG_REASON_READINGS',NULL,NULL,NULL,v_run_log_from_date,v_run_log_to_date);

209: -- Call mth_run_log_pre_load
210: mth_util_pkg.mth_run_log_pre_load('MTH_TAG_REASON_READINGS',v_unassigned_val,'INCR',NULL,0,v_log_date);
211:
212: -- Get to and from date from run log
213: mth_util_pkg.GET_RUN_LOG_DATES('MTH_TAG_REASON_READINGS',NULL,NULL,NULL,v_run_log_from_date,v_run_log_to_date);
214:
215: MERGE INTO MTH_TAG_REASON_READINGS mtrr USING
216: (
217: SELECT Decode(mtr.mth_entity,8,1,17,3) reason_type,

Line 215: MERGE INTO MTH_TAG_REASON_READINGS mtrr USING

211:
212: -- Get to and from date from run log
213: mth_util_pkg.GET_RUN_LOG_DATES('MTH_TAG_REASON_READINGS',NULL,NULL,NULL,v_run_log_from_date,v_run_log_to_date);
214:
215: MERGE INTO MTH_TAG_REASON_READINGS mtrr USING
216: (
217: SELECT Decode(mtr.mth_entity,8,1,17,3) reason_type,
218: mtr.equipment_fk_key,
219: mes.from_date,

Line 238: FROM mth_tag_reason_readings

234: SELECT Decode(reason_type,1,8),
235: equipment_fk_key,
236: reason_code,
237: reading_time
238: FROM mth_tag_reason_readings
239: WHERE To_Date IS NULL
240: UNION
241: SELECT mth_entity,
242: equipment_fk_key,

Line 313: mth_util_pkg.log_msg('No. of rows merged in mth_tag_reason_readings : '||SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

309: mtr.reading_time,
310: mtr.hour_fk_key
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

Line 320: FROM mth_tag_reason_readings mtrr

316: SET mtr.last_update_date = SYSDATE,
317: mtr.processed_flag = 1
318: WHERE EXISTS
319: ( SELECT 1
320: FROM mth_tag_reason_readings mtrr
321: WHERE mtrr.reading_time = mtr.reading_time
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 ) ;

Line 330: FROM mth_tag_reason_readings mtrr

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
331: WHERE mtrr.reading_time = mtr.reading_time
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 ) ;

Line 339: mth_util_pkg.mth_run_log_post_load('MTH_TAG_REASON_READINGS',v_unassigned_val);

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:
341: mth_util_pkg.log_msg('INCR_REASONS_FROM_READING end', mth_util_pkg.G_DBG_PROC_FUN_END);
342:
343: EXCEPTION