SELECT A.ID FROM
ServiceAssemblyForms A
JOIN ServiceDocuments SD on A.ServiceDocument_ID = SD.ID
WHERE
(A.AssemblyState < 3) AND (Cooperation='N') AND
((:Currency_ID = '0000000000') or (A.Currency_ID = :Currency_ID)) AND
(
(:ServiceType_ID = '0000000000') or
(A.ServiceDocument_ID = SD.ID) and (SD.ServiceType_ID = :ServiceType_ID)
) AND
Exists (
SELECT 1 FROM ServiceAssemblyForms2 SAF2
WHERE (SAF2.Parent_ID = A.ID) AND (SAF2.ITEMTYPE = 1) AND (SAF2.Quantity > SAF2.QuantityDelivered) AND (SAF2.Intermediation <> 'A')
) Generated by ABRA Software a.s. 27.10.2021 16:35:46