Třídová akce

Popis:

Kontrola unikátnosti za firmu, provozovnu a oblast schvalování.

Kód:

1

Tělo:

SELECT A.ID FROM ApprovedSuppliers A
LEFT JOIN FirmOffices FO ON FO.ID = A.FirmOffice_ID
WHERE 
  A.Firm_ID IN (SELECT ID FROM Firms WHERE ID = :Firm_ID OR Firm_ID = :Firm_ID) AND
  ( 
    FO.OfficeUnique_ID IN (SELECT OfficeUnique_ID FROM FirmOffices WHERE ID = :FirmOffice_ID) OR
    (((COALESCE(:FirmOffice_ID, '0000000000')) = '0000000000') AND (A.FirmOffice_ID IS NULL)) 
  ) AND
  A.ApprovingArea_ID = :ApprovingArea_ID

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