Třídová akce

Kód:

13

Tělo:

Select
  WSI.ID
From
  PLMWorkScheduleItems WSI
  join PLMJobOrdersRoutines JOR on WSI.JORoutine_ID = JOR.ID
  join PLMJOOutputItems JOI on JOR.Parent_ID = JOI.ID
  join PLMJONodes JON on JOI.Owner_ID = JON.ID
Where
  (Lower(JOR.Title) like :ATitle) and
  (JON.StoreCard_ID = :AStoreCardID) and
  (WSI.Status < 3)

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