как то так
X++:
if (localsalestable.salesid == (select salesid from salestable
where salestable.SalesStatus == salesstatus::completeleft
join wmspickingroute
where wmspickingroute.transrefid == salestable.salesid &&
(wmspickingroute.expeditionstatus == wmsexpeditionstatus::started ||
wmspickingroute.expeditionstatus == wmsexpeditionstatus::activated)).SalesId)