Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT T0.ItemCode,
- T1.ItemName,
- T0.WhsCode,
- 'Quantidade no Estoque' AS 'Posição',
- T0.OnHand
- FROM OITW T0
- INNER JOIN OITM T1 ON T1.ItemCode = T0.ItemCode
- UNION ALL
- SELECT T0.ItemCode,
- T0.ItemName,
- T2.WhsCode,
- T2.BinCode,
- T1.OnHandQty
- FROM OITM T0
- INNER JOIN OIBQ T1 ON T1.ItemCode = T0.ItemCode
- INNER JOIN OBIN T2 ON T2.AbsEntry = T1.BinAbs
- ORDER BY 1, 3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement