USE [NAVDEMO] GO CREATE VIEW [dbo].[CRONUS International Ltd_$In Transition] AS SELECT i.No_ AS [Item Code], '' AS Location, l.[Expected Receipt Date] AS [Arrival Date], l.Quantity FROM dbo.[CRONUS International Ltd_$Purchase Line] l INNER JOIN dbo.[CRONUS International Ltd_$Purchase Header] h ON h.[No_] = l.[Document No_] INNER JOIN dbo.[CRONUS International Ltd_$Item] i ON l.No_ = i.No_ WHERE l.Quantity > 0 AND l.[Quantity Received] = 0 AND l.Type = 2 AND h.[Document Type] = 1 GO