Objektová akce

Kód:

18

Tělo:

SELECT O.JobOrdersRoutines_ID, SUM(O.quantity), SUM(O.TotalTime), SUM(O.SalaryCosts), SUM(O.OverheadCosts), sum(O.GeneralExpense)
FROM PLMOperations O
JOIN PLMJobOrdersRoutines JOR ON O.JobOrdersRoutines_ID = JOR.ID
JOIN PLMJOOutputItems MI ON JOR.Parent_ID = MI.ID
JOIN PLMJONodes N ON N.ID = MI.Owner_ID
WHERE
  N.Parent_ID = :OBJID AND O.Finishedat$DATE > 0 and O.Cooperation = 'N'
GROUP BY O.JobOrdersRoutines_ID

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