Objektová akce

Kód:

19

Tělo:

SELECT
  S.Parent_ID, COALESCE(sum(S.PlannedTotalHours),0), COALESCE(sum(S.RealTotalHours),0)
FROM 
  SYS$BusOrders2 A, BusOrders B, BusOrderSources S
WHERE
  (A.Superior_ID = :OBJID) and (B.ID = A.ID) and (B.Hidden =  'N') and (B.ID = S.Parent_ID)
GROUP BY S.Parent_ID

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