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_UDA_PKG dependencies on MTH_EQUIPMENTS_EXT_B

Line 174: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENTS_EXT_B',v_unassigned_val,'INCR',NULL,0,v_log_to_date);

170: v_log_to_date := sysdate;
171: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
172:
173: -- Call mth_run_log_pre_load
174: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENTS_EXT_B',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
175:
176: -- Call GET_RUN_LOG_DATES
177: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENTS_EXT_B',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
178: mth_util_pkg.log_msg('v_log_from_date : '||v_log_from_date, mth_util_pkg.G_DBG_PROC_FUN_START);

Line 177: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENTS_EXT_B',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

173: -- Call mth_run_log_pre_load
174: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENTS_EXT_B',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
175:
176: -- Call GET_RUN_LOG_DATES
177: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENTS_EXT_B',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
178: mth_util_pkg.log_msg('v_log_from_date : '||v_log_from_date, mth_util_pkg.G_DBG_PROC_FUN_START);
179: mth_util_pkg.log_msg('v_log_to_date : '||v_log_to_date, mth_util_pkg.G_DBG_PROC_FUN_START);
180:
181:

Line 211: WHERE RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENTS_EXT_B'

207: FROM MTH_TAG_READINGS TAG,
208: MTH_RUN_LOG RUN_LOG,
209: EGO_ATTRS_V EGO,
210: EGO_ATTR_GROUPS_V EGO_ATTR_GRP
211: WHERE RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENTS_EXT_B'
212: AND TAG.creation_date >= RUN_LOG.from_date
213: AND TAG.creation_date <= Nvl(RUN_LOG.To_Date,SYSDATE)
214: AND TAG.MTH_ENTITY IS NULL
215: AND EGO.ATTR_GROUP_TYPE = 'MTH_EQUIPMENTS_GROUP'

Line 238: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENTS_EXT_B',v_unassigned_val);

234: TB_UPLOAD_NO_COMMIT();
235: p_retcode := 0;
236:
237: ----Call mth_run_log_post_load
238: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENTS_EXT_B',v_unassigned_val);
239:
240: mth_util_pkg.log_msg('PROCESS_EQUIPUDA_IN_INCR_MODE end', mth_util_pkg.G_DBG_PROC_FUN_START);
241:
242: EXCEPTION

Line 306: WHERE RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENTS_EXT_B'

302: FROM MTH_TAG_READINGS TAG,
303: MTH_RUN_LOG RUN_LOG,
304: EGO_ATTRS_V EGO,
305: EGO_ATTR_GROUPS_V EGO_ATTR_GRP
306: WHERE RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENTS_EXT_B'
307: AND TAG.EQUIPMENT_FK_KEY = NVL(p_equipment_pk_key, TAG.EQUIPMENT_FK_KEY)
308: AND TAG.CREATION_DATE >= RUN_LOG.FROM_DATE
309: AND TAG.CREATION_DATE < RUN_LOG.TO_DATE
310: AND EGO.ATTR_GROUP_TYPE = 'MTH_EQUIPMENTS_GROUP'

Line 361: DELETE FROM MTH_EQUIPMENTS_EXT_B EQEXT

357: mth_util_pkg.log_msg('REPROCES_EQUIPMENTS_UDA start', mth_util_pkg.G_DBG_PROC_FUN_START);
358: mth_util_pkg.log_msg('p_equipment_pk_key = ' || p_equipment_pk_key, mth_util_pkg.G_DBG_PARAM_VAL);
359: mth_util_pkg.log_msg('p_plant = ' || p_plant, mth_util_pkg.G_DBG_PARAM_VAL);
360:
361: DELETE FROM MTH_EQUIPMENTS_EXT_B EQEXT
362: WHERE EQEXT.READ_TIME > p_recal_from_date
363: AND EQEXT.READ_TIME <= p_recal_to_date
364: AND NVL(p_equipment_pk_key,EQEXT.EQUIPMENT_PK_KEY) in
365: (SELECT distinct EQUIPMENT_PK_KEY from MTH_EQUIPMENTS_D

Line 441: v_stmt := 'MERGE INTO MTH_EQUIPMENTS_EXT_B ED

437: FOR DBCOL IN DISTINCT_COLUMN
438: LOOP
439: v_colname := DBCOL.DB_COL;
440: v_stmt_no := 10;
441: v_stmt := 'MERGE INTO MTH_EQUIPMENTS_EXT_B ED
442: USING (
443: SELECT TAG_DATA,
444: EQUIPMENT_FK_KEY,
445: WORKORDER_FK_KEY,