USE [NAVDEMO]
GO
 
CREATE VIEW [dbo].[CRONUS International Ltd_$Orders to receive] AS
SELECT			
	i.No_ AS [Item Code],
	l.[Expected Receipt Date] AS [Delivery Date],
	l.[Order Date] AS [Sendout Date],
	l.[Outstanding Qty_ (Base)] - l.[Return Qty_ to Ship (Base)] AS [Qty to Receive],
	l.[Location Code] AS Location,
	l.[Unit Cost (LCY)] * (l.[Outstanding Qty_ (Base)] - l.[Return Qty_ to Ship (Base)]) as [Lot cost],
	l.[Document No_] as [PO Number]
FROM dbo.[CRONUS International Ltd_$Purchase Line] l
INNER JOIN dbo.[CRONUS International Ltd_$Item] i
  ON l.No_ = i.No_
WHERE l.[Outstanding Qty_ (Base)] - l.[Return Qty_ to Ship (Base)] > 0 
  AND l.Type = 2
  AND l.[Document Type] = 1