[Home] [Help]
50:
51: IF( (p_mode = 'RECAL') AND (p_source = 'TAG') ) THEN
52: SELECT Count(1)
53: INTO v_tag_reading_count
54: FROM mth_tag_readings mtr,
55: mth_entities mte,
56: mth_run_log mrl
57: WHERE mtr.mth_entity = mte.id
58: AND mte.mth_alias IN ('Scrap Quantity',
265: v_unassigned_val,
266: a.RECIPE_NUM,
267: a.RECIPE_VERSION,
268: a.SEGMENT_FK_KEY
269: FROM MTH_TAG_READINGS a,
270: MTH_ENTITIES b
271: WHERE a.MTH_ENTITY = b.ID
272: AND a.EQUIPMENT_FK_KEY IS NOT NULL
273: AND a.WORKORDER_FK_KEY IS NOT NULL
288: a.HOUR_FK_KEY;
289: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_OUTPUT - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
290:
291: --update processed flag in readings table
292: update MTH_TAG_READINGS t
293: set PROCESSED_FLAG = 1,
294: last_update_date=sysdate
295: where exists (
296: select 1
304: AND t.ITEM_FK_KEY IS NOT NULL
305: AND t.HOUR_FK_KEY IS NOT NULL
306: AND m.MTH_ALIAS IN ('Completed Quantity', 'Output Quantity', 'Rejected Quantity', 'Scrap Quantity', 'Rework Quantity')
307: AND t.LAST_UPDATE_DATE <= v_log_date);
308: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
309:
310: ----Call mth_run_log_post_load
311: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_OUTPUT',v_unassigned_val);
312:
366: v_unassigned_val SYSTEM_FK_KEY,
367: a.RECIPE_NUM,
368: a.RECIPE_VERSION,
369: a.SEGMENT_FK_KEY
370: FROM MTH_TAG_READINGS a,
371: MTH_ENTITIES b
372: WHERE a.MTH_ENTITY = b.ID
373: AND a.EQUIPMENT_FK_KEY IS NOT NULL
374: AND a.WORKORDER_FK_KEY IS NOT NULL
456: );
457: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_OUTPUT - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
458:
459: --update processed flag in readings table
460: update MTH_TAG_READINGS t
461: set PROCESSED_FLAG = 1,
462: last_update_date=sysdate
463: where exists (
464: select 1
472: AND t.ITEM_FK_KEY IS NOT NULL
473: AND t.HOUR_FK_KEY IS NOT NULL
474: AND m.MTH_ALIAS IN ('Completed Quantity', 'Output Quantity', 'Rejected Quantity', 'Scrap Quantity', 'Rework Quantity')
475: AND t.LAST_UPDATE_DATE BETWEEN v_log_from_date and v_log_to_date);
476: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
477:
478: ----Call mth_run_log_post_load
479: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_OUTPUT',v_unassigned_val);
480:
563: v_unassigned_val,
564: a.RECIPE_NUM,
565: a.RECIPE_VERSION,
566: a.SEGMENT_FK_KEY
567: FROM MTH_TAG_READINGS a,
568: MTH_ENTITIES b
569: WHERE a.MTH_ENTITY = b.ID
570: AND a.EQUIPMENT_FK_KEY IS NOT NULL
571: AND a.WORKORDER_FK_KEY IS NOT NULL
587: a.HOUR_FK_KEY;
588: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_OUTPUT - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
589:
590: --update processed flag in readings table
591: update MTH_TAG_READINGS t
592: set PROCESSED_FLAG = 1,
593: last_update_date=sysdate
594: where exists (
595: select 1
603: AND t.ITEM_FK_KEY IS NOT NULL
604: AND t.HOUR_FK_KEY IS NOT NULL
605: AND m.MTH_ALIAS IN ('Completed Quantity', 'Output Quantity', 'Rejected Quantity', 'Scrap Quantity', 'Rework Quantity')
606: AND t.READING_TIME BETWEEN p_recal_from_date AND nvl(p_recal_to_date,t.READING_TIME));
607: mth_util_pkg.log_msg('Number of rows updated in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
608:
609:
610: mth_util_pkg.log_msg('RECAL_OUTPUT_FROM_READING end', mth_util_pkg.G_DBG_PROC_FUN_END);
611: EXCEPTION