SBO库位查询

点击(此处)折叠或打开

1. SELECT T0.DocNum,T1.VisOrder,T1.ItemCode,T1.Dscription,T4.BinCode,T4.SL1Code
   
2.          FROM OPDN T0
   
3.          INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry
   
4.          INNER JOIN OILM T2 ON T2.TransType = T0.ObjType AND T2.DocEntry = T1.DocEntry AND T2.DocLineNum = T1.LineNum
   
5.          INNER JOIN OBTL T3 ON T3.MessageID = T2.MessageID --库位记录
   
6.          INNER JOIN OBIN T4 ON T4.AbsEntry = T3.BinAbs   --库位名称

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7518874/viewspace-1415464/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7518874/viewspace-1415464/