Objektová akce

Popis:

Vrátí možnou problémovou servisní závadu

Kód:

4

Tělo:

SELECT DOp.Parent_Id, COUNT(DOp.Serviceoperation_Id)
FROM ServiceDefectOperations DOp
JOIN ServiceDefectOperations DOpS on (Dop.Parent_Id = DOPS.Parent_ID)
WHERE DOpS.Serviceoperation_Id = :OBJID
GROUP BY DOp.Parent_Id
HAVING COUNT(DOp.Serviceoperation_Id) > 1

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