Objektová akce

Kód:

5

Tělo:

/* Kompletační listy SPM */
SELECT 
  DISTINCT 'AL', B.Parent_ID
FROM
  DemandSheets2 A
  JOIN SPMAssemblyLists2 B ON B.ID = A.DemandingDocRow_ID AND A.DemandingDocType = 'AL'
WHERE
  A.Parent_ID = :OBJID AND
  A.DemandingDocRow_ID IS NOT NULL AND
  B.RowType = 5 

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