Objektová akce

Kód:

27

Tělo:

Select SUM(CAST(SD2.LocalTAmount*CAST( VT2.materialquantity / SD2.Quantity AS NUMERIC(15,6)) AS NUMERIC(13,2)))
, MAX(SD.DocDate$Date)
from storedocuments2 SD2
inner join storedocuments SD ON (SD.Id = SD2.Parent_ID)
inner join ProductionTasks2 VT2 On SD2.ID = VT2.MaterialRow_ID
inner Join ProductionTasks VT On VT.ID=VT2.Parent_ID
inner Join plmjoborders VJO On VJO.productiontask_id=VT.ID
Where VT.OwnerType=1 And VJO.ID=:OBJID
AND SD2.id In
    (Select PT2.MaterialRow_ID FRom ProductionTasks2 PT2
      Left Join ProductionTasks PT On PT.ID=PT2.Parent_ID
      Left Join plmjoborders JO On JO.productiontask_id=PT.ID
      Where PT.OwnerType=1 And JO.ID=:OBJID
     )

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