入库通知单一览

界面 入库通知单

 SELECT A.INFORMNO, B.SNAME AS STATUSNAME, A.PURCHASENO, D.SNAME AS COMPANYNAME,
        A.INSTOCKDATE, C.SNAME AS INSTOCKTYPENAME,A.SHIPPERID  AS SHIPPERNAME,
        F.SNAME AS SUPPLIERNAME, A.MID2, A.REMARK, A.receivetime  CREATETIME,
        A.BILLNO, A.STATUS, A.ISCROSS, A.GOODSTYPE, A.BILLTYPE, A.STOCKID,
        A.OWNERID, A.SHIPPERID  , A.SUPPLIERID, A.CREATOR, A.UPDATEMAN,
        A.UPDATEDATE, A.ACTIONFLG, A.INSTOCKTYPE, A.COMPANYID,A.TRANSFERTYPE,to_number(NVL(A.ISRELATION,'0')) ISRELATION,
        to_number(NVL(A.ISADVCHARGE,'0')) ISADVCHARGE,A.EXTERNALPOID  
   FROM INFORMTBL A,
        (SELECT   ID.INFORMNO
             FROM INFORMDTTBL ID,GOODSMST G
             WHERE ID.GOODSID = G.GOODSID
         GROUP BY ID.INFORMNO) AD,
        BASEDETAILMST B,
        BASEDETAILMST C,
        CompanyMst D,
        CUSTOMERMST F
  WHERE 1 = 1 
    AND A.INFORMNO = AD.INFORMNO
    AND B.CODEID = 'SYS_INSTCINFORMSTATUS'
    AND B.CODEVALUE = A.STATUS
    AND C.CODEID = 'SYS_INSTCTYPE'
    AND C.CODEVALUE = A.INSTOCKTYPE
    AND A.OWNERID = D.OWNERID(+)
    AND A.COMPANYID = D.COMPANYID(+)
    AND A.SUPPLIERID = F.CUSTID(+)
 ORDER BY A.CREATETIME DESC

细单


 SELECT A.ASNNO, A.INSTOCKINFORMDTID, A.INFORMNO, A.INFORMDTID, A.PURCHASENO, 
        A.BILLTYPE, A.GOODSID, A.GOODSBATCH, A.QUALITYFLG, A.MID1, A.INSTOCKINFORMNUM,
        A.INNUM, A.TRANSFLG, A.CUSTGOODSID, A.BIGUNITNUM, A.MIDUNITNUM,
        A.STANDUNITNUM, A.VOLUME, A.NETWEIGHT, A.GROSSWEIGHT, A.INBIGUNITNUM,
        A.INMIDUNITNUM, A.INSTANDUNITNUM, A.PICKNUM, A.INSTOCKQTY, A.MID2, A.MID2 AS OTHERNO,
        A.MID3, A.MID4, A.MID5, B.NAME AS GOODSNAME, B.MODEL, B.FULLMARK AS TRADEMARK,
        B.GOODSCATEGORYID, B.GOODSTOPCATEGORYID, C.SNAME AS QUALITYFLGNAME, D.PRODUCTDATE, D.EXPIREDATE,
        IF.INFORMNUM, IF.LEAVENUM, A.OWNERID, A.COMPANYID, 
        CASE WHEN B.TEMPTYPEID='SYS_TEMPTYPESYS_TEMPTYPE_COOL' or B.TEMPTYPEID='SYS_TEMPTYPESYS_TEMPTYPE_FROZEN' THEN 1 ELSE 0 END ISCOLD 
   FROM INSTOCKINFORMDTTBL A, INFORMDTTBL IF, GOODSMST B,BASEDETAILMST C, 
        GOODSBATCHMST D
  WHERE A.GOODSID = B.GOODSID
    AND C.CODEID(+) = 'SYS_QUALITYFLAG'
    AND A.QUALITYFLG = C.CODEVALUE(+)
    AND A.GOODSID = D.GOODSID(+)
    AND A.GOODSBATCH = D.GOODSBATCH(+)
    AND A.INFORMNO = IF.INFORMNO(+)
    AND A.INFORMDTID = IF.INFORMDTID(+)
    AND A.INFORMNO  ='N206013028997' 
 ORDER BY A.ASNNO, TO_NUMBER(A.INSTOCKINFORMDTID)
文档更新时间: 2024-02-27 16:41   作者:周骏