Třídová akce

Kód:

13

Tělo:

SELECT O.ID
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 = :JO_ID AND (O.StartedAt$Date<>0) AND (O.FinishedAt$Date=0)

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