Objektová akce

Kód:

6

Tělo:

SELECT
  SU.WeightUnit,
  CAST(SU.Weight AS DOUBLE PRECISION) * CAST(A.Quantity AS DOUBLE PRECISION) / CAST((CASE WHEN A.UnitRate = 0 THEN 1 ELSE A.UnitRate END) AS DOUBLE PRECISION) AS Weight,
  SU.CapacityUnit,
  CAST(SU.Capacity AS DOUBLE PRECISION) * CAST(A.Quantity AS DOUBLE PRECISION) / CAST((CASE WHEN A.UnitRate = 0 THEN 1 ELSE A.UnitRate END) AS DOUBLE PRECISION) AS Capacity
FROM IssuedOrders2 A
JOIN StoreUnits SU ON SU.Parent_ID = A.StoreCard_ID AND SU.Code = A.QUnit
WHERE A.Parent_ID = :OBJID

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