Index: APPS/Halux/PPS/TBXZaag/impl/LijstHelper.cls.xml
===================================================================
diff -u -r2883 -r2895
--- APPS/Halux/PPS/TBXZaag/impl/LijstHelper.cls.xml	(.../LijstHelper.cls.xml)	(revision 2883)
+++ APPS/Halux/PPS/TBXZaag/impl/LijstHelper.cls.xml	(.../LijstHelper.cls.xml)	(revision 2895)
@@ -26,8 +26,8 @@
 <Query name="qActieveBatchLijst">
 <Type>%SQLQuery</Type>
 <FormalSpec>LijnNr</FormalSpec>
-<SqlQuery><![CDATA[	Select DISTINCT Batch || '||' || isnull(SubBatch,"") as BatchKey, Batch || ' ' || isnull(SubBatch,'') as BatchOms from APPS_Halux_PPS_TBXZaag.Opdrachten --where isnull(Batch->NotActive,0)=0
-	order by Batch,SubBatch]]></SqlQuery>
+<SqlQuery><![CDATA[	Select   Batch || '||' || isnull(SubBatch,"") as BatchKey, Batch || ' ' || isnull(SubBatch,'') || ' - nog ' || sum(case status when 'W' then 1 else 0 end) || ' van ' || count(*) as BatchOms from APPS_Halux_PPS_TBXZaag.Opdrachten --where isnull(Batch->NotActive,0)=0
+	group by Batch,SubBatch]]></SqlQuery>
 <Parameter name="CONTAINID" value="0"/>
 </Query>