Třídová akce

Kód:

12

Tělo:

Select
  LSC.ID Content_ID,
  (LSC.Quantity - LSC.QuantityReserved) Quantity
From
  LogStorePositions SP
  JOIN LogStoreContents LSC ON SP.ID = LSC.Parent_ID
Where
  SP.Store_ID = :StoreID and
  LSC.StoreCard_ID = :StoreCardID and
  LSC.QUnit = :QUnit and
  LSC.UnitRate = :UnitRate and
  LSC.StoreCard_ID = :StoreCardID and
  (LSC.Quantity - LSC.QuantityReserved) > 0 and
  SP.ReservedForDoc_ID = :ReservedForDocID and
  SP.ReservedForDocType = :ReservedForDocType

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