Index: OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml
===================================================================
diff -u -r70781 -r70791
--- OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml	(.../OphalenPickLijnenConsolidatie.cls.xml)	(revision 70781)
+++ OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml	(.../OphalenPickLijnenConsolidatie.cls.xml)	(revision 70791)
@@ -97,36 +97,44 @@
 	#dim Status as %String = ""
 	#Dim SqlStatement as %String = ""
    	
-	Set SqlStatement = "select distinct orders.ID CONSNR,olines.name LIJNNR,olines.QTYTARGET,pa.QTY AANTAL,item.id IDENTNR "
-	_" ,isnull((select top 1 fl.FULLNAME from DCEREPORT_PICK_ACTUALS p1 "
-	_"         left join DCEREPORT_LOCATIONS         fl on fl.OID= p1.FROM_LOCATION_OID "
-	_"         where p1.PICKORDER_OID = pa.PICKORDER_OID and p1.PICKLINE_OID = pa.PICKLINE_OID and p1.FROM_LOCATION_OID = pa.FROM_LOCATION_OID order by p1.DTSSTART asc),'KardexOPSLAG') FROMLOC "
-	_" ,isnull(fromcont.LPN,fromloc.FULLNAME) BRONPALLET "
-	_" ,isnull((select top 1 toloc.FULLNAME from DCEREPORT_PICK_ACTUALS p2 "
-	_"         left join DCEREPORT_LOCATIONS         toloc on toloc.OID= p2.to_LOCATION_OID "
-	_"         where p2.PICKORDER_OID = pa.PICKORDER_OID and p2.PICKLINE_OID = pa.PICKLINE_OID and p2.FROM_LOCATION_OID = pa.FROM_LOCATION_OID order by p2.DTSSTART desc),'KardexOUT') AFZETLOC "
-	_" ,tocont.LPN DOELPALLET "
-	_" ,isnull((select top 1 emp.ID from DCEREPORT_PICK_ACTUALS p3 "
-	_"         left join DCEREPORT_EMPLOYEES         emp on emp.OID= p3.EMPLOYEE_OID "
-	_"         where p3.PICKORDER_OID = pa.PICKORDER_OID and p3.PICKLINE_OID = pa.PICKLINE_OID and p3.FROM_LOCATION_OID = pa.FROM_LOCATION_OID order by p3.DTSSTART asc),'KardexOperator') USERID "
-	_" ,isnull((select top 1 p4.DTSSTART from DCEREPORT_PICK_ACTUALS p4 "
-	_"         where p4.PICKORDER_OID = pa.PICKORDER_OID and p4.PICKLINE_OID = pa.PICKLINE_OID and p4.FROM_LOCATION_OID = pa.FROM_LOCATION_OID order by p4.DTSSTART asc) ,pa.DTSSTART) PICKINGTIJDSTIP "
-	_" ,ml.fullname TOLOC"
-	_" from DCEREPORT_OUTBOUNDORDERS orders "
-	_" inner join DCEREPORT_OUTBOUNDLINES    olines on olines.OUTBOUNDORDER_OID = orders.oid "
-	_" inner join DCEREPORT_PICKORDERS       po on po.ORDER_OID = orders.OID "
-	_" inner join DCEREPORT_PICKLINES        pl on pl.ORDER_OID = olines.OUTBOUNDORDER_OID and pl.ORDERLINE_OID = olines.oid and pl.PICKORDER_OID = po.oid "
-	_" inner join DCEREPORT_PICK_ACTUALS      pa on pa.PICKORDER_OID = pl.PICKORDER_OID and pa.PICKLINE_OID = pl.OID "
-	_" left join DCEREPORT_CONTAINERS        fromcont on fromcont.OID = pa.FROM_CONTAINER_OID "
-	_" left join DCEREPORT_CONTAINERS        tocont on tocont.OID = pa.TO_CONTAINER_OID "
-	_" left join DCEREPORT_LOCATIONS         fromloc on fromloc.OID= pa.FROM_LOCATION_OID "
-	_" left join DCEREPORT_LOCATIONS         toloc on toloc.OID= pa.TO_LOCATION_OID "
-	_" left join DCEREPORT_ITEMS             item on item.OID = pa.ITEM_OID "
-	_" inner join DCEREPORT_outbound_actuals oa on oa.CONTAINER_OID = pa.TO_CONTAINER_OID "
- 	_" inner join DCEREPORT_LOCATIONS ml on ml.OID = oa.TO_LOCATION_OID "
-	_" where orders.ID = '"_ ConsolidatieNr _"' " ; we vullen zelf de parameter in omdat er iets fout loopt in de prepare van de SQL :-((
-	_" and orders.STATUS = 14 "	
-	_" order by olines.name "
+	 Set SqlStatement = "select distinct orders.ID CONSNR,olines.name LIJNNR,olines.QTYTARGET,pa.QTY AANTAL,item.id IDENTNR   "
+	 _" ,isnull((select top 1 fl.FULLNAME from DCEREPORT_PICK_ACTUALS p1 "
+	 _"          left join DCEREPORT_LOCATIONS         fl on fl.OID= p1.FROM_LOCATION_OID "
+	 _"          where p1.PICKORDER_OID = pa.PICKORDER_OID and p1.PICKLINE_OID = pa.PICKLINE_OID "
+	 _" 		 and p1.FROM_LOCATION_OID = pa.FROM_LOCATION_OID "
+	 _" 		 order by p1.DTSSTART asc) "
+	 _" 		 ,'KardexOPSLAG') FROMLOC "
+	 _" ,isnull(fromcont.LPN,fromloc.FULLNAME) BRONPALLET "
+	 _" ,isnull((select top 1 toloc.FULLNAME from DCEREPORT_PICK_ACTUALS p2 "
+	 _"          left join DCEREPORT_LOCATIONS         toloc on toloc.OID= p2.to_LOCATION_OID "
+	 _"          where p2.PICKORDER_OID = pa.PICKORDER_OID and p2.PICKLINE_OID = pa.PICKLINE_OID "
+	 _" 		 and p2.FROM_LOCATION_OID = pa.FROM_LOCATION_OID "
+	 _" 		 order by p2.DTSSTART desc)"
+	 _" 		 ,'KardexOUT') AFZETLOC "
+	 _" ,tocont.LPN DOELPALLET "
+	 _" ,isnull((select top 1 emp.ID from DCEREPORT_PICK_ACTUALS p3 "
+	 _"          left join DCEREPORT_EMPLOYEES         emp on emp.OID= p3.EMPLOYEE_OID "
+	 _" 	     where p3.PICKORDER_OID = pa.PICKORDER_OID and p3.PICKLINE_OID = pa.PICKLINE_OID "
+	 _" 		 and p3.FROM_LOCATION_OID = pa.FROM_LOCATION_OID "
+	 _" 		 order by p3.DTSSTART asc)"
+	 _" 	   ,'KardexOperator') USERID "
+	 _" ,pa.dtsstart PICKINGTIJDSTIP 		"
+	 _" ,ml.fullname TOLOC "
+	 _" from DCEREPORT_OUTBOUNDORDERS orders "
+	 _" inner join DCEREPORT_OUTBOUNDLINES    olines on olines.OUTBOUNDORDER_OID = orders.oid "
+	 _" inner join DCEREPORT_PICKORDERS       po on po.ORDER_OID = orders.OID "
+	 _" inner join DCEREPORT_PICKLINES        pl on pl.ORDER_OID = olines.OUTBOUNDORDER_OID and pl.ORDERLINE_OID = olines.oid and pl.PICKORDER_OID = po.oid "
+	 _" inner join DCEREPORT_PICK_ACTUALS      pa on pa.PICKORDER_OID = pl.PICKORDER_OID and pa.PICKLINE_OID = pl.OID "
+	 _" left join DCEREPORT_CONTAINERS        fromcont on fromcont.OID = pa.FROM_CONTAINER_OID "
+	 _" left join DCEREPORT_CONTAINERS        tocont on tocont.OID = pa.TO_CONTAINER_OID "
+	 _" inner join DCEREPORT_LOCATIONS         fromloc on fromloc.OID= pa.FROM_LOCATION_OID and fromloc.FULLNAME not like 'ST.%' "
+	 _" left join DCEREPORT_LOCATIONS         toloc on toloc.OID= pa.TO_LOCATION_OID "
+	 _" left join DCEREPORT_ITEMS             item on item.OID = pa.ITEM_OID "
+	 _" inner join DCEREPORT_outbound_actuals oa on oa.CONTAINER_OID = pa.TO_CONTAINER_OID "
+	 _"  inner join DCEREPORT_LOCATIONS ml on ml.OID = oa.TO_LOCATION_OID "
+	 _" where orders.ID ='" _ ConsolidatieNr _ "' " 
+	 _"  and orders.STATUS = 14 "
+	 _"  order by olines.name "
 		
     try
     {