Objektová akce

Kód:

7

Tělo:

/* Požadavky na výrobu */
SELECT 
  DISTINCT 'PQ', N.Parent_ID
FROM
  DemandSheets2 A
  JOIN PLMReqInputItems B ON B.ID = A.DemandingDocRow_ID AND A.DemandingDocType = 'PQ'
  JOIN PLMReqNodes N ON N.ID = B.Owner_ID
WHERE
  A.Parent_ID = :OBJID AND
  A.DemandingDocRow_ID IS NOT NULL

Generated by ABRA Software a.s. 27.10.2021 16:35:50