Index: OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml
===================================================================
diff -u -r67725 -r67741
--- OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml	(.../OphalenPickLijnenConsolidatie.cls.xml)	(revision 67725)
+++ OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml	(.../OphalenPickLijnenConsolidatie.cls.xml)	(revision 67741)
@@ -124,8 +124,8 @@
 	_" 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 "
-	_" left join DCEREPORT_outbound_actuals oa on oa.CONTAINER_OID = pa.TO_CONTAINER_OID "
- 	_" left join DCEREPORT_LOCATIONS ml on ml.OID = oa.TO_LOCATION_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 "