Objektová akce

Popis:

Vrátí celkový čas operace

Kód:

3

Tělo:

SELECT
  sum(COALESCE(SOVAR.WorkHoursPlanned, SO2.WorkHoursPlanned))
FROM
  ServiceOperations2 SO2
LEFT JOIN
  ServiceOperationVariants SOVAR ON  (SOVAR.Parent_ID = SO2.ID) and (SOVAR.ServiceObjectType_ID = :ServicedObjectType_ID)
where 
  (SO2.ItemType = 0) and 
  (SO2.Parent_ID = :OBJID)

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