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) )
Generated by ABRA Software a.s. 27.10.2021 16:35:46