APPS.MTH_UTIL_PKG dependencies on MTH_ALL_ENTITIES_V

Line 3993: from workday shifts and mth_all_entities_v table *

3989:
3990: /* ****************************************************************************
3991: * Procedure :INCR_EQUIP_SHIFTS*
3992: * Description :The procedure will insert records in equipment shifts table by taking the data*
3993: from workday shifts and mth_all_entities_v table *
3994: * File Name :MTHUTILB.PLS *
3995: * Visibility :Public
3996: * Modification log : *
3997: * Author Date Change: Amrit Kaur 27-Mar-2012 Initial Creation *

Line 4023: FROM MTH_WORKDAY_SHIFTS_D WSD,MTH_ALL_ENTITIES_V MAV

4019:
4020: DELETE
4021: FROM MTH_EQUIPMENT_SHIFTS_D ESD
4022: WHERE EXISTS (SELECT 1
4023: FROM MTH_WORKDAY_SHIFTS_D WSD,MTH_ALL_ENTITIES_V MAV
4024: WHERE WSD.LAST_UPDATE_DATE > v_log_from_date
4025: AND (MAV.PRODUCTION_ENTITY ='Y'or MAV.PRODUCTION_ENTITY ='N')
4026: AND WSD.PLANT_FK_KEY = MAV.SITE_ID
4027: AND

Line 4068: FROM MTH_ALL_ENTITIES_V MAV,

4064: WSD.SHIFT_DATE,
4065: WSD.FROM_DATE,
4066: WSD.TO_DATE,
4067: MAV.ENTITY_TYPE
4068: FROM MTH_ALL_ENTITIES_V MAV,
4069: MTH_WORKDAY_SHIFTS_D WSD
4070: WHERE (WSD.LAST_UPDATE_DATE > v_log_from_date OR
4071: ( MAV.CREATION_DATE > v_log_from_date AND
4072: TRUNC( MAV.CREATION_DATE ) <= WSD.SHIFT_DATE))