Index: APPS/Halux/PPS/TBXZaag/impl/LijstHelperVoorTBX.cls.xml
===================================================================
diff -u -r33339 -r63208
--- APPS/Halux/PPS/TBXZaag/impl/LijstHelperVoorTBX.cls.xml	(.../LijstHelperVoorTBX.cls.xml)	(revision 33339)
+++ APPS/Halux/PPS/TBXZaag/impl/LijstHelperVoorTBX.cls.xml	(.../LijstHelperVoorTBX.cls.xml)	(revision 63208)
@@ -25,9 +25,24 @@
 					SELECT  B.ID  FROM APPS_Halux_common_impl.BatchImpl As B 
 					  JOIN APPS_Halux_common_impl.BatchImpl_ToeleveringenIndex As BTI  on BTI.BatchImpl = B.ID
 					  JOIN Flow_Toelev.Hoofding As Toelev  on Toelev.ToeleveringsNr = BTI.element_key
-					  WHERE B.Status = 'Gestart'
+					  WHERE B.Status = 'Gestart' AND B.Categorie = 'Legrabox'
 					  GROUP BY B.ID
 					)
+	GROUP BY BatchID,SubBatch
+	
+	union
+	
+	SELECT BatchID || '||' || isnull(SubBatch,'') as BatchKey, 'M ' || BatchID || ' ' || isnull(SubBatch,'') as BatchOms,'MVX ' || BatchID || ' ' || isnull(SubBatch,'') || ' - nog ' || sum(case Zaagstatus when 'W' then 1 else 0 end) || ' van ' || count(HZUI.ID) as BatchLangeOms 
+	FROM APPS_Halux_PPS_Activiteit_impl_common_dto.HoffmannZaagUitvoeringInfo As HZUI 
+	WHERE (isnull(SubBatch,'')='' or SubBatch='Herwerk' or :All=1)
+	      AND HZUI.BatchID IN 
+					(
+					SELECT  B.ID  FROM APPS_Halux_common_impl.BatchImpl As B 
+					  JOIN APPS_Halux_common_impl.BatchImpl_ToeleveringenIndex As BTI  on BTI.BatchImpl = B.ID
+					  JOIN Flow_Toelev.Hoofding As Toelev  on Toelev.ToeleveringsNr = BTI.element_key
+					  WHERE B.Status = 'Gestart' AND B.Categorie = 'Merivobox'
+					  GROUP BY B.ID
+					)
 	GROUP BY BatchID,SubBatch]]></SqlQuery>
 <Parameter name="CONTAINID" value="0"/>
 </Query>