Třídová akce

Popis:

Vrátí všechny neukončené ML a nekooperační

Kód:

3

Tělo:

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