APPS.MTH_UTIL_PKG dependencies on MTH_EQUIPMENTS_D

Line 3050: FROM mth_equipment_shifts_d a,mth_equipments_d b WHERE b.equipment_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key

3046: DELETE FROM mth_workday_shifts_D WHERE plant_fk_key = l_plant_fk_key and Trunc(from_date)>=l_start_date AND Trunc(from_date)<=l_end_date;
3047: DELETE FROM mth_workday_shifts_D WHERE plant_fk_key = l_plant_fk_key and shift_date>=l_start_date AND shift_date<=l_end_date;
3048: DELETE FROM mth_equipment_shifts_d WHERE availability_date>=l_start_date AND availability_date<=l_end_date
3049: AND equipment_fk_key IN (SELECT DISTINCT(Nvl(a.equipment_fk_key,0))
3050: FROM mth_equipment_shifts_d a,mth_equipments_d b WHERE b.equipment_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key
3051: UNION ALL
3052: SELECT distinct(Nvl(a.equipment_fk_key,0) )
3053: FROM mth_equipment_shifts_d a,mth_resources_d b WHERE b.resource_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key
3054:

Line 3164: FROM mth_equipments_d

3160: SELECT plant_fk_key site_id, resource_pk_key entity_pk_key, resource_name entity_name, 'RESOURCE', production_resource production_entity
3161: FROM mth_resources_d
3162: UNION ALL
3163: SELECT plant_fk_key site_id, equipment_pk_key entity_pk_key, equipment_name entity_name, 'EQUIPMENT', production_equipment production_entity
3164: FROM mth_equipments_d
3165: )b
3166: WHERE b.site_id = a.plant_fk_key
3167: AND a.plant_fk_key=l_plant_fk_key
3168: AND shift_date>=l_start_date

Line 3199: FROM mth_equipments_d

3195: SELECT plant_fk_key site_id, resource_pk_key entity_pk_key, resource_name entity_name, 'RESOURCE', production_resource production_entity
3196: FROM mth_resources_d
3197: UNION ALL
3198: SELECT plant_fk_key site_id, equipment_pk_key entity_pk_key, equipment_name entity_name, 'EQUIPMENT', production_equipment production_entity
3199: FROM mth_equipments_d
3200: )b
3201: WHERE b.site_id = a.plant_fk_key
3202: AND a.plant_fk_key=l_plant_fk_key
3203: AND shift_date>=l_start_date

Line 3235: FROM mth_equipments_d

3231: SELECT plant_fk_key site_id, resource_pk_key entity_pk_key, resource_name entity_name, 'RESOURCE', production_resource production_entity
3232: FROM mth_resources_d
3233: UNION ALL
3234: SELECT plant_fk_key site_id, equipment_pk_key entity_pk_key, equipment_name entity_name, 'EQUIPMENT', production_equipment production_entity
3235: FROM mth_equipments_d
3236: )b
3237: WHERE b.site_id = a.plant_fk_key
3238: AND a.plant_fk_key=l_plant_fk_key
3239: AND shift_date>=l_start_date

Line 3309: FROM mth_equipments_d

3305: SELECT plant_fk_key site_id, resource_pk_key entity_pk_key, resource_name entity_name, 'RESOURCE', production_resource production_entity
3306: FROM mth_resources_d
3307: UNION ALL
3308: SELECT plant_fk_key site_id, equipment_pk_key entity_pk_key, equipment_name entity_name, 'EQUIPMENT', production_equipment production_entity
3309: FROM mth_equipments_d
3310: )b
3311: WHERE b.site_id = a.plant_fk_key
3312: AND a.plant_fk_key=l_plant_fk_key
3313: AND shift_date>=l_start_date