DBA Data[Home] [Help]

APPS.MTH_EVENT_GEN_PKG dependencies on MTH_TAG_REASON_READINGS

Line 7: generates and handles Equipment down with reason code events from MTH_TAG_REASON_READINGS table.*

3:
4: /* ****************************************************************************
5: * Procedure : MTH_GEN_EQP_DOWN_W_RZ_EVENT *
6: * Description :The new procedure MTH_GEN_EQP_DOWN_W_RZ_EVENT *
7: generates and handles Equipment down with reason code events from MTH_TAG_REASON_READINGS table.*
8: * File Name :MTHEVGB.PLS *
9: * Visibility :Private *
10: * Parameters : *
11: **************************************************************************** */

Line 21: FROM MTH_TAG_REASON_READINGS TRR ,FND_LOOKUPS FL

17: TRR.FROM_DATE FROM_DATE,
18: TRR.TO_DATE TO_DATE,
19: TRR.REASON_CODE REASON_CODE,
20: TRR.LAST_UPDATE_DATE LAST_UPDATE_DATE
21: FROM MTH_TAG_REASON_READINGS TRR ,FND_LOOKUPS FL
22: WHERE TRR.LAST_UPDATE_DATE >= v_log_from_date AND
23: TRR.REASON_TYPE = 1 AND
24: TRR.REASON_CODE = FL.LOOKUP_CODE And
25: FL.LOOKUP_TYPE = 'MTH_EQUIP_DOWNTIME_REASON' ;

Line 368: generates and handles events from MTH_EQUIP_STATUSES, MTH_TAG_REASON_READINGS, and MTH_EQUIP_OUTPUT_SUMMARY*

364:
365: /* ****************************************************************************
366: * Procedure : MTH_GEN_HDL_EVTS_FROM_STS_OUT *
367: * Description :The new procedure MTH_GEN_HDL_EVTS_FROM_STS_OUT *
368: generates and handles events from MTH_EQUIP_STATUSES, MTH_TAG_REASON_READINGS, and MTH_EQUIP_OUTPUT_SUMMARY*
369: * File Name :MTHEVGB.PLS *
370: * Visibility :Private *
371: * Parameters : *
372: **************************************************************************** */