Objektová akce

Kód:

3

Tělo:

SELECT
  COUNT(*)
FROM
  Storedocuments2 A
  JOIN ProductionTasks2 PT2 ON PT2.MaterialRow_ID = A.ID
  JOIN Storedocuments2 SD2 ON PT2.ProductRow_ID = SD2.ID
  JOIN Stores S ON S.ID = SD2.Store_ID
WHERE
  A.ID = :OBJID AND
  S.FIFO <> :FIFO

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