Objektová akce

Kód:

14

Tělo:

Select
  WSI2.ID
From
  PLMWorkScheduleItems WSI2
  join PLMJobOrdersRoutines JOR2 on WSI2.JORoutine_ID = JOR2.ID
  join PLMJOOutputItems JOO2 on JOR2.Parent_ID = JOO2.ID
  join PLMJONodes JON2 on JOO2.Owner_ID = JON2.ID
  join PLMJONodes JON on (JON2.Parent_ID = JON.Parent_ID) and (JON2.StoreCard_ID = JON.StoreCard_ID)
  join PLMJOOutputItems JOO on JOO.Owner_ID = JON.ID
  join PLMJobOrdersRoutines JOR on JOR.Parent_ID = JOO.ID and Lower(JOR.Title) = Lower(JOR2.Title) 
Where
  JOR.ID = :OBJID and
  WSI2.Status < 3

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