Objektová akce

Kód:

30

Tělo:

select Sum(CAST(SD2.LocalTAmount AS NUMERIC(13,2)))
, MAX(SD.DocDate$Date)
from storedocuments2 SD2
inner join storedocuments SD ON (SD.Id = SD2.Parent_ID)
inner join productiontasks PT ON (SD2.ProductionTask_ID = PT.ID)
inner Join plmjoborders JO On JO.productiontask_id=PT.ID
Where documenttype = '28'
  AND JO.ID=:OBJID

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