Index: OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml =================================================================== diff -u -r67712 -r67725 --- OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml (.../OphalenPickLijnenConsolidatie.cls.xml) (revision 67712) +++ OBJTimpl/WMSOrder/OphalenPickLijnenConsolidatie.cls.xml (.../OphalenPickLijnenConsolidatie.cls.xml) (revision 67725) @@ -106,13 +106,14 @@ _" ,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_CONTAINER_OID = pa.FROM_CONTAINER_OID order by p2.DTSSTART desc),'KardexOUT') TOLOC " + _" where p2.PICKORDER_OID = pa.PICKORDER_OID and p2.PICKLINE_OID = pa.PICKLINE_OID and p2.FROM_CONTAINER_OID = pa.FROM_CONTAINER_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_CONTAINER_OID = pa.FROM_CONTAINER_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_CONTAINER_OID = pa.FROM_CONTAINER_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 " @@ -123,6 +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 " _" 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 "