入库通知单一览
界面 入库通知单
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 作者:周骏