Objektová akce

Kód:

33

Tělo:

SELECT O.SalaryCosts, O.OverheadCosts, O.GeneralExpense
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 = :OBJID AND
  JO.FinishedAt$Date > 0

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