Objektová akce

Popis:

Vrátí počet využitých výrobních čísel.

Kód:

9

Tělo:

SELECT COUNT(C.ID) FROM
(
  SELECT A.ID
  FROM PLMJobOrdersSN A
  JOIN PLMCoopSN B ON B.SN_ID = A.ID
  WHERE A.Parent_ID = :OBJID
  
  UNION
  
  SELECT A.ID
  FROM PLMJobOrdersSN A
  JOIN PLMFinishedProducts2 B ON B.JobOrdersSN_ID = A.ID
  WHERE A.Parent_ID = :OBJID
  
  UNION
  
  SELECT A.ID
  FROM PLMJobOrdersSN A
  JOIN PLMJobOrdersNotices B ON B.SN_ID = A.ID
  WHERE A.Parent_ID = :OBJID
  
  UNION
  
  SELECT A.ID
  FROM PLMJobOrdersSN A
  JOIN PLMOperations B ON B.JobOrdersSN_ID = A.ID
  WHERE A.Parent_ID = :OBJID
  
  UNION
  
  SELECT A.ID
  FROM PLMJobOrdersSN A
  JOIN PLMProduceServices B ON B.SN_ID = A.ID
  WHERE A.Parent_ID = :OBJID
) C

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