Třídová akce

Kód:

12

Tělo:

Select
  WSI.ID
From
  PLMWorkScheduleItems WSI
  join PLMReqRoutines RR on WSI.ReqRoutine_ID = RR.ID
  join PLMReqOutputItems ROI on RR.Parent_ID = ROI.ID
  join PLMReqNodes RN on ROI.Owner_ID = RN.ID
Where
  (Lower(RR.Title) like :ATitle) and
  (RN.StoreCard_ID = :AStoreCardID) and
  (WSI.Status < 3) and
  (WSI.JORoutine_ID is null) 

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