移库指示单一览

移库指示单

SELECT DISTINCT A.MOVEID, 
                A.STATUS, 
                A.INSTOCKID, 
                A.INDICATIONTIME, 
                A.MOVEREASON, 
                SUBSTR(A.CREATEDATE, 1, 10) AS CREATEDATE, 
                A.REMARK, 
                D.SHORTNAME AS CREATOR, 
                F.SHORTNAME AS UPDATEMAN, 
                A.UPDATEDATE, 
                A.AUDITDATE, 
                G.SHORTNAME AS AUDITMAN, 
                A.ISTOODDAREA 
  FROM MOVEINDICATIONTBL   A, 
       MOVEINDICATIONDTTBL B, 
       GOODSMST            C, 
       USERMST             D, 
       USERMST             F, 
       USERMST             G 
 WHERE A.MOVEID = B.MOVEID 
   AND B.GOODSID = C.GOODSID 
   AND A.CREATOR = D.USERID(+) 
   AND A.UPDATEMAN = F.USERID(+) 
   AND A.AUDITMAN = G.USERID(+) 
   AND A.MOVEREASON<>'SYS_MOVE_WAREHOUSE_REASONMOVE_WAREHOUSE_REASON_REP' 
    AND A.MOVEID LIKE '%MI8020230804001788%'