出库单类型名称控件，当我设置为复选框后查询就显示sql命令未正确结束…设置的数据字典是自定义 SELECT O.ORDERKEY 出货单号, O.EXTERNORDERKEY 外部单号, os.description 状态名称， O.TYPE 出货单类型码, ot.description 出库单类型名称, FROM ORDERS O inner JOIN /*(SELECT OD.ORDERKEY, OD.SKU, OD.Lottable02, SUM(OD.ORIGINALQTY) ORIGINALQTY, SUM(OD.OPENQTY) OPENQTY, SUM(OD.QTYALLOCATED) QTYALLOCATED, SUM(OD.QTYPICKED) QTYPICKED, SUM(OD.SHIPPEDQTY) SHIPPEDQTY FROM ORDERDETAIL OD where '' is null or OD.Lottable02 = '' GROUP BY OD.ORDERKEY, OD.SKU, OD.LOTTABLE02) ODD*/ ORDERDETAIL OD ON O.ORDERKEY = OD.ORDERKEY inner JOIN sku s ON od.sku = s.sku inner join codelkup ot on listname ='ORDERTYPE'and ot.code =O.TYPE inner join orderstatussetup os on os.code = OD.STATUS left join (select Lottable02 ,orderkey,sum(qty) qty from pickdetail p inner join lotattribute l on p.lot=l.lot where p.status=9 group by orderkey,Lottable02) lp on o.orderkey=lp.orderkey where 1=1 ${if(len(ckdlx)=0,""," and O.TYPE IN ('"+ckdlx+"')")} ${if(len(scdd) =0,""," and o.notes IN ('"+scdd+"')")} ORDER BY O.Requestedshipdate, s.sku |
1min目标场景问卷
立即参与
最佳回答 |
||||
|
0
|
|
|||
|
0
|
|
|||
