APPS.MTH_PROCESS_STATUS_PKG dependencies on MTH_ENTITIES

Line 54: mth_entities mte,

50: IF( (p_mode = 'RECAL') AND (p_source = 'TAG') ) THEN
51: SELECT Count(1)
52: INTO v_tag_reading_count
53: FROM mth_tag_readings mtr,
54: mth_entities mte,
55: mth_run_log mrl
56: WHERE mtr.mth_entity = mte.id
57: AND mte.mth_alias = 'Status'
58: AND mrl.fact_table = 'MTH_EQUIP_STATUSES'

Line 325: MTH_ENTITIES e

321: err.HOUR_FK_KEY IS NOT NULL AND
322: --err.PROCESSED_FLAG = 0 AND
323: err.EQUIPMENT_STATUS = 'ACTIVE' AND
324: err.TAG_DATA IS NOT NULL )r,
325: MTH_ENTITIES e
326: WHERE e.mth_alias = 'Status'
327: AND e.id = r.mth_entity
328: AND r.TAG_DATA IS NOT NULL
329: ) r,

Line 342: from mth_entities m

338: set PROCESSED_FLAG = 1,
339: last_update_date=sysdate
340: where exists (
341: select 1
342: from mth_entities m
343: where t.MTH_ENTITY = m.ID
344: --AND t.PROCESSED_FLAG = 0
345: AND t.EQUIPMENT_FK_KEY IS NOT NULL
346: AND t.HOUR_FK_KEY IS NOT NULL

Line 357: from mth_entities m

353: update MTH_TAG_READINGS_ERR t
354: set PROCESSED_FLAG = 1
355: where exists (
356: select 1
357: from mth_entities m
358: where t.MTH_ENTITY = m.ID
359: -- AND t.PROCESSED_FLAG = 0
360: AND t.EQUIPMENT_FK_KEY IS NOT NULL
361: AND t.HOUR_FK_KEY IS NOT NULL

Line 495: MTH_ENTITIES e

491: AND i.equipment_fk_key =err.equipment_fk_key
492: )) AND
493: err.EQUIPMENT_STATUS = 'ACTIVE' AND
494: err.TAG_DATA IS NOT NULL )r,
495: MTH_ENTITIES e
496: WHERE e.mth_alias = 'Status'
497: AND e.id = r.mth_entity
498: AND r.TAG_DATA IS NOT NULL
499: ORDER BY r.equipment_fk_key, r.reading_time

Line 591: from mth_entities m

587: set PROCESSED_FLAG = 1,
588: last_update_date=sysdate
589: where exists (
590: select 1
591: from mth_entities m
592: where t.MTH_ENTITY = m.ID
593: AND t.PROCESSED_FLAG = 0
594: AND t.EQUIPMENT_FK_KEY IS NOT NULL
595: AND t.HOUR_FK_KEY IS NOT NULL

Line 608: from mth_entities m

604: update MTH_TAG_READINGS_ERR t
605: set PROCESSED_FLAG = 1
606: where exists (
607: select 1
608: from mth_entities m
609: where t.MTH_ENTITY = m.ID
610: AND t.PROCESSED_FLAG = 0
611: AND t.EQUIPMENT_FK_KEY IS NOT NULL
612: AND t.HOUR_FK_KEY IS NOT NULL

Line 701: MTH_ENTITIES e

697: r.USER_MEASURE3,
698: r.USER_MEASURE4,
699: r.USER_MEASURE5
700: FROM mth_tag_readings r,
701: MTH_ENTITIES e
702: WHERE e.mth_alias = 'Status'
703: AND e.id = r.mth_entity
704: AND r.EQUIPMENT_FK_KEY IS NOT NULL
705: AND r.HOUR_FK_KEY IS NOT NULL

Line 711: FROM mth_tag_readings i , MTH_ENTITIES e

707: AND r.EQUIPMENT_FK_KEY = nvl(p_equipment_pk_key, r.EQUIPMENT_FK_KEY)
708: AND ( ( r.READING_TIME BETWEEN p_recal_from_date AND p_recal_to_date
709:
710: OR r.READING_TIME IN ((SELECT Max(i.READING_TIME)
711: FROM mth_tag_readings i , MTH_ENTITIES e
712: WHERE e.mth_alias = 'Status'
713: AND e.id = i.mth_entity
714: AND i.READING_TIME < p_recal_from_date
715: AND i.equipment_fk_key = r.equipment_fk_key)

Line 717: FROM mth_tag_readings i, MTH_ENTITIES e

713: AND e.id = i.mth_entity
714: AND i.READING_TIME < p_recal_from_date
715: AND i.equipment_fk_key = r.equipment_fk_key)
716: , (SELECT Min(i.READING_TIME)
717: FROM mth_tag_readings i, MTH_ENTITIES e
718: WHERE e.mth_alias = 'Status'
719: AND e.id = i.mth_entity
720: AND i.READING_TIME > p_recal_to_date
721: AND i.equipment_fk_key = r.equipment_fk_key ) ) )

Line 799: from mth_entities m

795: set PROCESSED_FLAG = 1,
796: last_update_date=sysdate
797: where exists (
798: select 1
799: from mth_entities m
800: where t.MTH_ENTITY = m.ID
801: AND t.PROCESSED_FLAG = 0
802: AND t.EQUIPMENT_FK_KEY IS NOT NULL
803: AND t.HOUR_FK_KEY IS NOT NULL