Objektová akce

Kód:

15

Tělo:

/* Poptavkove listy */
SELECT 
  DISTINCT 'DS', B.Parent_ID
FROM PLMJOInputItems A
JOIN PLMJONodes N ON N.ID = A.Owner_ID
JOIN DemandSheets2 B ON A.ID = B.DemandingDocRow_ID AND B.DemandingDocType = 'JO'
WHERE
  N.Parent_ID = :OBJID AND
  B.DemandingDocRow_ID IS NOT NULL

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