Objektová akce

Popis:

Vrátí všechny ReqRoutine.ID pro stejný požadavek

Kód:

6

Tělo:

 Select
  RR2.ID
From
  PLMReqRoutines RR2 
  join PLMReqOutputItems ROI2 on RR2.Parent_ID = ROI2.ID
  join PLMReqNodes RN2 on ROI2.Owner_ID = RN2.id
  join PLMReqNodes RN on RN2.Parent_ID = RN.Parent_ID
  join PLMReqOutputItems ROI on ROI.Owner_ID = RN.ID
  join PLMReqRoutines RR on RR.Parent_ID = ROI.ID
Where
  RR.ID = :OBJID AND
  RR2.Planned = 'A'
Order by
  RR2.CompulsoryOperation, RN2.PosIndex, RR2.PosIndex  

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