Skip to Content
0
Nov 20, 2012 at 08:49 AM

instock,min,max records are missing

39 Views

select case A.ItemCode when isnull(A.ItemCode,null) then A.ItemCode else B.ItemCode end as 'ItemCode' ,case A.ItemName when isnull(A.ItemName,null) then A.ItemName else B.ItemName end as 'ItemName' ,B.PlannedQty as Planned,B.CmpltQty as Completed, A.OnHand, A.MinLevel as Min, A.MaxLevel as Max,A.MinOrder as Reorder,B.DocNum from (

(SELECT T0.ItemCode, T0.ItemName, T1.OnHand, T0.MinLevel , T0.MaxLevel ,T1.MinOrder

FROM dbo.OITM AS T0 left outer JOIN

dbo.OITW AS T1 ON T0.ItemCode = T1.ItemCode

WHERE (T1.WhsCode = 'SIP') AND (T1.MinOrder >= T1.OnHand )and MaxLevel<>0 )A

full outer join (select T0.DocNum,T0.ItemCode,T1.ItemName,T0.PlannedQty,T0.CmpltQty from OWOR T0 inner join OITM T1 on T0.ItemCode=T1.ItemCode where (T0.Series=411) and T0.status<>'C' and T0.status<>'L') B on

A.ItemCode=B.ItemCode

)