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_LOAD_TAG_READINGS_PKG dependencies on MTH_TAG_READINGS_ERR

Line 417: MTH_TAG_READINGS_ERR TRE, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_CONTEXTUALIZATION_REQ MCR

413: TRE.QUALITY_FLAG,
414: TRE.RECIPE_NUM,
415: TRE.RECIPE_VERSION
416: FROM
417: MTH_TAG_READINGS_ERR TRE, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_CONTEXTUALIZATION_REQ MCR
418: WHERE
419: TRE.RE_PROCESS_FLAG = 'Y' And
420: TRE.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+) And
421: TRE.EQUIPMENT_FK_KEY = MCR.EQUIPMENT_FK_KEY (+)

Line 486: MTH_TAG_READINGS_ERR TRE, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_CONTEXTUALIZATION_REQ MCR

482: TRE.QUALITY_FLAG,
483: TRE.PROCESSED_FLAG,
484: SYSDATE - 0.0001
485: FROM
486: MTH_TAG_READINGS_ERR TRE, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_CONTEXTUALIZATION_REQ MCR
487: WHERE
488: TRE.RE_PROCESS_FLAG = 'Y'
489: AND TRE.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
490: AND TRE.EQUIPMENT_FK_KEY = MCR.EQUIPMENT_FK_KEY (+)

Line 500: MTH_TAG_READINGS_ERR

496:
497: -- Inserting Remaining records in tag readings error table
498: INSERT
499: INTO
500: MTH_TAG_READINGS_ERR
501: (GROUP_ID,
502: READING_TIME,
503: TAG_CODE,
504: TAG_DATA,

Line 579: MTH_TAG_READINGS_ERR TRE, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_CONTEXTUALIZATION_REQ MCR

575: TRE.RECIPE_VERSION,
576: TRE.RECIPE_NUM,
577: TRE.EQUIPMENT_STATUS
578: FROM
579: MTH_TAG_READINGS_ERR TRE, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_CONTEXTUALIZATION_REQ MCR
580: WHERE
581: TRE.RE_PROCESS_FLAG = 'Y' And
582: TRE.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+) And
583: TRE.EQUIPMENT_FK_KEY = MCR.EQUIPMENT_FK_KEY (+) AND

Line 597: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_ERR from tag readings error table which have re_process_flag as Y- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

593: (MCR.ITEM_REQUIRED <> 'Y' Or
594: TRE.ITEM_FK_KEY IS NOT NULL And TRE.ITEM_FK_KEY <> MTH_UTIL_PKG.MTH_UA_GET_VAL())))
595: )
596: ;
597: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_ERR from tag readings error table which have re_process_flag as Y- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
598:
599: -- Deleting from tag readings error table all the records where re_process_flag is Y
600: DELETE
601: FROM

Line 602: MTH_TAG_READINGS_ERR

598:
599: -- Deleting from tag readings error table all the records where re_process_flag is Y
600: DELETE
601: FROM
602: MTH_TAG_READINGS_ERR
603: WHERE RE_PROCESS_FLAG = 'Y' ;
604:
605: mth_util_pkg.log_msg('Number of rows deleted from MTH_TAG_READINGS_ERR which have re_process_flag as Y- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
606: v_ret_code:=0;

Line 605: mth_util_pkg.log_msg('Number of rows deleted from MTH_TAG_READINGS_ERR which have re_process_flag as Y- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

601: FROM
602: MTH_TAG_READINGS_ERR
603: WHERE RE_PROCESS_FLAG = 'Y' ;
604:
605: mth_util_pkg.log_msg('Number of rows deleted from MTH_TAG_READINGS_ERR which have re_process_flag as Y- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
606: v_ret_code:=0;
607: RETURN v_ret_code;
608: EXCEPTION
609: WHEN OTHERS THEN

Line 631: MTH_TAG_READINGS_ERR

627: v_ret_code NUMBER;
628: BEGIN
629: INSERT
630: INTO
631: MTH_TAG_READINGS_ERR
632: (GROUP_ID,
633: READING_TIME,
634: TAG_CODE,
635: TAG_DATA,

Line 684: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_ERR which has contextualization method other than 1,2 or 3 - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

680: STG.EQUIPMENT_FK_KEY = CM.EQUIPMENT_FK_KEY (+)
681: AND CM.CONTEXTUALIZE_METHOD NOT IN ( 1 , 2 , 3 )
682: )
683: ;
684: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_ERR which has contextualization method other than 1,2 or 3 - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
685:
686: -- Inserting records in tag readings error table for tag based contextualization missing/incorrect required context information
687: INSERT
688: INTO

Line 689: MTH_TAG_READINGS_ERR

685:
686: -- Inserting records in tag readings error table for tag based contextualization missing/incorrect required context information
687: INSERT
688: INTO
689: MTH_TAG_READINGS_ERR
690: (GROUP_ID,
691: READING_TIME,
692: TAG_CODE,
693: TAG_DATA,

Line 925: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_ERR for tag based contextualziation- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

921: TO_CHAR(ITEMS.ITEM_PK_KEY) = TO_CHAR(MTH_UTIL_PKG.MTH_UA_GET_VAL()))
922: )
923:
924: );
925: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_ERR for tag based contextualziation- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
926:
927: ---
928:
929: INSERT

Line 1175: MTH_TAG_READINGS_ERR (GROUP_ID,

1171: IS
1172: v_ret_code NUMBER;
1173: BEGIN
1174: INSERT INTO
1175: MTH_TAG_READINGS_ERR (GROUP_ID,
1176: READING_TIME,
1177: TAG_CODE,
1178: TAG_DATA,
1179: MTH_ENTITY,

Line 1271: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_ERR for schedule based contextualziation-- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

1267: AND EQUIPMENTS.STATUS IS NOT NULL
1268: AND EQUIPMENTS.STATUS = 'ACTIVE')))
1269: )
1270: ;
1271: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_ERR for schedule based contextualziation-- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1272:
1273:
1274: ---
1275: INSERT

Line 1490: INTO MTH_TAG_READINGS_ERR

1486: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS for manual based contextualziation- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1487:
1488: -----
1489: INSERT
1490: INTO MTH_TAG_READINGS_ERR
1491: (GROUP_ID,
1492: READING_TIME,
1493: TAG_CODE,
1494: TAG_DATA,

Line 1566: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_ERR for manual based contextualziation- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

1562: OR EQUIPMENTS.STATUS IS NULL
1563: OR EQUIPMENTS.STATUS <> 'ACTIVE')
1564: )
1565: ;
1566: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_ERR for manual based contextualziation- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1567: v_ret_code:=0;
1568: RETURN v_ret_code;
1569: EXCEPTION
1570: WHEN OTHERS THEN

Line 2186: SELECT Count(*) INTO v_reprocess_flag FROM MTH_TAG_READINGS_ERR WHERE RE_PROCESS_FLAG='Y';

2182: v_log_date := sysdate;
2183: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
2184:
2185: mth_util_pkg.switch_column_default_value ( 'MTH_TAG_READINGS_RAW', v_current_processing_flag);
2186: SELECT Count(*) INTO v_reprocess_flag FROM MTH_TAG_READINGS_ERR WHERE RE_PROCESS_FLAG='Y';
2187:
2188: --delete all the tables
2189: DELETE FROM MTH_TAG_READINGS_LATEST;
2190: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINSG_LATEST - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line 2207: DELETE FROM MTH_TAG_READINGS_ERR;

2203:
2204: DELETE FROM MTH_TAG_READINGS_STG_ERR;
2205: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_STG_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2206:
2207: DELETE FROM MTH_TAG_READINGS_ERR;
2208: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2209:
2210: DELETE FROM MTH_EVENTS;
2211: mth_util_pkg.log_msg('Number of rows deleted in MTH_EVENTS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

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

2204: DELETE FROM MTH_TAG_READINGS_STG_ERR;
2205: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_STG_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2206:
2207: DELETE FROM MTH_TAG_READINGS_ERR;
2208: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2209:
2210: DELETE FROM MTH_EVENTS;
2211: mth_util_pkg.log_msg('Number of rows deleted in MTH_EVENTS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2212:

Line 2342: SELECT Count(*) INTO v_reprocess_flag FROM MTH_TAG_READINGS_ERR WHERE RE_PROCESS_FLAG='Y';

2338: v_log_date := sysdate;
2339: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
2340:
2341: mth_util_pkg.switch_column_default_value ( 'MTH_TAG_READINGS_RAW', v_current_processing_flag);
2342: SELECT Count(*) INTO v_reprocess_flag FROM MTH_TAG_READINGS_ERR WHERE RE_PROCESS_FLAG='Y';
2343:
2344: IF(v_current_processing_flag=1 OR v_current_processing_flag=2 OR v_reprocess_flag>0 ) THEN
2345: mth_util_pkg.mth_load_tag_raw_to_processed(v_current_processing_flag, p_from_tz , p_to_tz );
2346: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_TRANSFORM_TAG_DATA_TO_STG();