Index: OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml =================================================================== diff -u -r71858 -r71903 --- OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml (.../OphalenPickLijnenConsolidatie.cls.xml) (revision 71858) +++ OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml (.../OphalenPickLijnenConsolidatie.cls.xml) (revision 71903) @@ -124,7 +124,7 @@ _" 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 " + _" inner join DCEREPORT_PICK_ACTUALS pa on pa.PICKORDER_OID = pl.PICKORDER_OID and pa.PICKLINE_OID = pl.OID and pa.status = '4' " _" 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.%' "