SELECT

TO_NUMBER(SUBSTR(T.FBILLTIME186, 5, 2))||'月' AS M_GROUP,

T.FGOODSID390NUMBER,

T.FGOODSID390NAME,

T.FINTERFACENUMBERB186,

T.FDELIVERYTIME186,

T.FBILLTIME186,

T.FGOODSID390UDFB,

T.FCUSTOMERID186NAME,

T.FOPERATEQUANTITY390,

T.FCUSTOMERID186NUMBER,

T.FBILLEMPID186NAME,

T.FWAREHOUSEID390NUMBER,

T.FWAREHOUSEID390NAME

--SUM(T.FOPERATEQUANTITY390) AS M_QTY

FROM

  DWR_WMS_TIMELY3104_V721 T

WHERE

T.PERIOD_DATE >= TO_DATE('${start}', 'YYYY-MM-DD')

  AND T.PERIOD_DATE < TO_DATE('${end}', 'YYYY-MM-DD')

  AND T.FBILLTYPEID186 = 'S30006'

  AND concat(T.FBILLTIME186,T.FCUSTOMERID186NUMBER) NOT IN ('3月3090PA1403'）

  AND T.FCUSTOMERID186NUMBER IN ('3090PA1400','3090PA1401','3090PA1402','3090PA1403','3090PA1404','3090PA1405','3090PA1406')

  ${IF(LEN(WLID) == 0, "", "AND T.FGOODSID390NAME IN ('" + WLID + "')") }

  ${IF(LEN(KSID) == 0, "", "AND T.FCUSTOMERID186NAME IN ('" + KSID + "')") }

你表字段是什么格式

用not exists