Třídová akce

Popis:

Kontrola, zda omezující údaje z karty majetku nejsou v zahájené inventuře

Kód:

4

Tělo:

select
  C.ID as AssetInv_ID,
  A.ID as ID,
  A.IncludedAssetTypes,
  A.Responsible_ID,
  A.AssetLocation_ID,
  A.EvidenceDivision_ID,
  A.ExpensesDivision_ID
 from AssetInvListRestrictions A
 join AssetInvLists B on B.ID = A.Parent_ID
 join AssetInv C on C.ID = B.Parent_ID
 where
  (C.InventoryState = 1)
  and ((A.IncludedAssetTypes = 0) or (A.IncludedAssetTypes = :AAssetTypePlusOne))
  and (((A.Responsible_ID = :AResponsible_ID))
    or ((A.AssetLocation_ID = :AAssetLocation_ID))
    or ((A.EvidenceDivision_ID = :AEvidenceDivision_ID))
    or ((A.ExpensesDivision_ID = :AExpensesDivision_ID)))

Generated by ABRA Software a.s. 27.10.2021 16:34:24