Index: OBJTimpl/WMSOrder/OphalenGepicktePalletInhoud.cls.xml =================================================================== diff -u -r70198 -r72945 --- OBJTimpl/WMSOrder/OphalenGepicktePalletInhoud.cls.xml (.../OphalenGepicktePalletInhoud.cls.xml) (revision 70198) +++ OBJTimpl/WMSOrder/OphalenGepicktePalletInhoud.cls.xml (.../OphalenGepicktePalletInhoud.cls.xml) (revision 72945) @@ -73,7 +73,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.OID IN ( " + _ " inner join DCEREPORT_PICK_ACTUALS pa on pa.PICKLINE_OID = pl.OID and pa.OID IN ( " _ " (select paoid from " ; deze om actuals van een pallet over de rugzakken goed te krijgen, per tussenstap is er pickactual record, we willen het laatste _ " (select ROW_NUMBER() over (order by pa1.dtsstart desc) as rownum, pa1.oid paoid " _ " from DCEREPORT_PICK_ACTUALS pa1 " @@ -147,7 +147,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.OID IN ( " + _ " inner join DCEREPORT_PICK_ACTUALS pa on pa.PICKLINE_OID = pl.OID and pa.OID IN ( " _ " (select paoid from " ; deze om actuals van een pallet over de rugzakken goed te krijgen, per tussenstap is er pickactual record, we willen het laatste _ " (select ROW_NUMBER() over (order by pa1.dtsstart desc) as rownum, pa1.oid paoid " _ " from DCEREPORT_PICK_ACTUALS pa1 "