Index: OBJTimpl/WMSOrder/OphalenGepicktePalletInhoud.cls.xml =================================================================== diff -u -r67765 -r67785 --- OBJTimpl/WMSOrder/OphalenGepicktePalletInhoud.cls.xml (.../OphalenGepicktePalletInhoud.cls.xml) (revision 67765) +++ OBJTimpl/WMSOrder/OphalenGepicktePalletInhoud.cls.xml (.../OphalenGepicktePalletInhoud.cls.xml) (revision 67785) @@ -131,11 +131,12 @@ #dim Status as %String = "" #Dim SqlStatement as %String = "" #dim ConsolidatieNummer as %String = "" - Set SqlStatement = "select distinct oo.id CONSNR, oo.Status STATUS" + Set SqlStatement = "select distinct oo.id CONSNR, oo.Status STATUS, loc.Fullname TOLOC " _ " from DCEREPORT_CONTAINERS c " _ " inner join DCEREPORT_OUTBOUND_ACTUALS oa on oa.CONTAINER_OID = c.oid " _ " inner join DCEREPORT_OUTBOUNDLINES ol on ol.OUTBOUNDORDER_OID = oa.OUTBOUNDORDER_OID and ol.OID = oa.OUTBOUNDLINE_OID " _ " inner join DCEREPORT_OUTBOUNDORDERS oo on oo.OID = ol.OUTBOUNDORDER_OID " + _ " inner join DCEREPORT_LOCATIONS loc on loc.OID = oa.TO_LOCATION_OID " _ " where c.LPN= '"_LPN_"' " try {