Objektová akce

Popis:

Zjistí jestli je výrobní číslo použito.

Kód:

3

Tělo:

SELECT COUNT(C.ID) FROM
(
  SELECT A.ID
  FROM PLMCoopSN A
  WHERE A.SN_ID = :OBJID
  
  UNION
  
  SELECT A.ID
  FROM PLMFinishedProducts2 A
  WHERE A.JobOrdersSN_ID = :OBJID
  
  UNION
  
  SELECT A.ID
  FROM PLMJobOrdersNotices A
  WHERE A.SN_ID = :OBJID
  
  UNION
  
  SELECT A.ID
  FROM PLMProduceServices A
  WHERE A.SN_ID = :OBJID
) C

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