Objektová akce

Kód:

19

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 = :OBJID AND
  ( O.FinishedAt$DATE >= :FinishedDATE + 1 OR O.FinishedAt$DATE = 0) AND
  O.Cooperation = 'N'

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