Třídová akce

Kód:

7

Tělo:

Select
  C.StoreCard_ID,
  Sum(C.Quantity) - Sum(C.QuantityReserved)
From    
  LogStoreContents C
  JOIN LogStorePositions P on C.Parent_ID = P.ID
  JOIN SelDat S on S.Obj_ID = C.StoreCard_ID 
Where
  P.ReservedForDoc_ID is null and
  S.Sel_ID = :SelID and
  P.Store_ID = :StoreID
Group by
  C.StoreCard_ID

Generated by ABRA Software a.s. 27.10.2021 16:35:19