Objektová akce

Popis:

Vrátí maximum z pořadí v operaci

Kód:

8

Tělo:

SELECT MAX(WSI.NoInRoutine)
  From PLMWorkScheduleItems WSI
  WHERE
    WSI.JORoutine_id IN
      (SELECT WSIJO.JORoutine_id FROM PLMWorkScheduleItems WSIJO WHERE WSIJO.ID = :OBJID)
  OR
    WSI.ReqRoutine_id IN
      (SELECT WSIReq.ReqRoutine_id FROM PLMWorkScheduleItems WSIReq WHERE WSIReq.ID = :OBJID)

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