Objektová akce

Kód:

5

Tělo:

Select
  WSI2.ID
From
  PLMWorkScheduleItems WSI2
  join PLMReqRoutines RR2 on WSI2.ReqRoutine_ID = RR2.ID
  join PLMReqOutputItems RO2 on RR2.Parent_ID = RO2.ID
  join PLMReqNodes RN2 on RO2.Owner_ID = RN2.ID
  join PLMReqNodes RN on (RN2.Parent_ID = RN.Parent_ID) and (RN2.StoreCard_ID = RN.StoreCard_ID)
  join PLMReqOutputItems RO on RO.Owner_ID = RN.ID
  join PLMReqRoutines RR on RR.Parent_ID = RO.ID and Lower(RR.Title) = Lower(RR2.Title) 
Where
  RR.ID = :OBJID and
  WSI2.Status < 3

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