Objektová akce

Popis:

Vrátí ID, pokud se jedná o duplicitní úkon

Kód:

18

Tělo:

SELECT A.ID
  FROM PLMWorkScheduleItems A
WHERE
  A.ID = :OBJID
AND
(
  A.ReqRoutine_ID is not null
  AND
  (A.JORoutine_ID IS NULL)
  AND
  EXISTS
    (SELECT ID
       FROM PLMWorkScheduleItems
       WHERE (RequestWSI_ID = A.ID) AND
         (ID <> RequestWSI_ID) AND
         (JORoutine_id is not null) AND
         (ReqRoutine_ID IS NULL))
)

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