select ws.id
from PLMWorkScheduleItems ws
INNER JOIN PLMJobOrdersRoutines JOR ON (JOR.id = ws.JORoutine_id)
INNER JOIN PLMJOOutputItems JOO ON (JOR.parent_id = JOO.ID)
INNER JOIN PLMJONodes JON ON (JOO.owner_id = JON.ID)
where JON.parent_id = :OBJID
Generated by ABRA Software a.s. 27.10.2021 16:34:49