1、接口：
（1）基础数据 IS_DUE_DATE 为 X时，为E 其余为 M
（2）所有接口出货订单站点默认从线路维护表中取
SELECT LINE_NUMBER, LINE_NAME, TRANSPORT_ORDER  FROM SHIPPINGLINE WHERE REGION_ID = ?
 (3) 部门领用：replace(V_REC.SGTXT, '|', '')

2、发运时装载箱数的查询修改：

select nvl(sum(casenum), 0) casenum
   from (select loadid,
                caseid,
                (case sum(casenum)
                  when 0 then
                   1
                  else
                   sum(casenum)
                end) casenum
           from (select o.loadid,
                        (case to_char(pd.cartontype)
                          when 'PALLET' then
                           pd.qty / pack.casecnt
                          else
                           0
                        end) casenum,
                        pd.caseid
                   from Orders o, PickDetail pd, SKU, PACK
                  where o.orderkey = pd.orderkey
                    and o.loadid = '0000017847'
                    and PD.SKU = SKU.SKU
                    and SKU.Packkey = PACK.Packkey
                    and SKU.Storerkey = pd.storerkey
                    AND pd.status >= '5'
                    and pd.status <> '9')
          group by loadid, caseid)