波次释放

 SELECT   A.PICKWAVESTATUS, F.SNAME PICKWAVESTATUSNAME, A.PICKWAVEID, A.CREATOR,A.RELEASEMAN,A.RELEASETIME,
          A.CREATEDATE, SUM(nvl(a.BOXNUM,0)) BOXNUM, MAX(nvl(a.ISPREPICK,'-')) ISPREPICK 
     FROM PICKWAVETBL A,
          (SELECT CODEVALUE, SNAME
             FROM BASEDETAILMST
            WHERE CODEID = 'SYS_PICKWAVESTATUS') F
            where 1=1
      AND A.PICKWAVESTATUS = F.CODEVALUE
     AND A.PICKWAVEID LIKE 'PW802023122700002%'
 GROUP BY A.PICKWAVESTATUS, F.SNAME, A.PICKWAVEID, A.CREATOR,A.RELEASEMAN,A.RELEASETIME, A.CREATEDATE
   ORDER BY A.CREATEDATE DESC