Třídová akce

Kód:

5

Tělo:

SELECT SUM(O.SalaryCosts), SUM(O.OverheadCosts), SUM(O.GeneralExpense)
  ,(select max(OP.ID) FROM PLMOperations OP WHERE OP.JobOrdersRoutines_ID = JOR.ID AND  OP.finishedat$date >=
    (SELECT MAX(OO.finishedat$date) FROM  PLMOperations OO WHERE OO.JobOrdersRoutines_ID = JOR.ID AND OO.ID = OP.ID))
  ,JOR.ID , MAX(JO.ID), COUNT (O.ID)
FROM PLMJobOrders JO
JOIN PLMJONodes N ON N.Parent_ID = JO.ID
JOIN PLMJOOutputItems MI ON MI.Owner_ID = N.ID
JOIN PLMJobOrdersRoutines JOR ON JOR.Parent_ID = MI.ID
JOIN PLMOperations O ON O.JobOrdersRoutines_ID = JOR.ID
WHERE
  JO.ID = :JOID
GROUP BY JOR.ID  

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