Třídová akce

Kód:

13

Tělo:

Select
  I2.StoreCard_ID,
  Sum(I2.Quantity - I2.DeliveredQuantity) Quantity
From
  IssuedOrders2 I2
  JOIN IssuedOrders I ON I.ID = I2.Parent_id
  JOIN SelDat S ON S.Obj_ID = I2.StoreCard_ID
Where
  I2.RowType = 3 and
  I.Closed = 'N' and
  I2.DeliveredQuantity < I2.Quantity and
  I2.Revided_ID is Null and
  S.Sel_ID = :SelID and      
  I2.Store_ID = :StoreID
Group by
  I2.StoreCard_ID

Generated by ABRA Software a.s. 27.10.2021 16:34:09