Třídová akce

Popis:

Hodnotící kritéria pro skladové karty a skladová menu.

Kód:

1

Tělo:

SELECT DISTINCT EC.ID, EC.Code  
FROM 
  EvaluationCriteria EC 
WHERE EC.CriterionType = 2 and 
EC.ID IN
(
  SELECT AAC.EvaluationCriterion_ID FROM ApprovingAreaCriteria AAC
  JOIN ApprovingAreas AA ON AA.ID = AAC.Parent_ID
  WHERE 
    AAC.RequiredFromDate$Date <= :FromDate AND
    (
      (AA.TypeDefinition = 0) OR 
      (AA.TypeDefinition = 1 AND AAC.Parent_ID IN
        (
          SELECT AA2.Parent_ID FROM ApprovingAreaStoreCards AA2 WHERE AA2.StoreCard_ID IN
          (
            SELECT SD.Obj_ID FROM SelDat SD where SD.Sel_ID = :StoreCardsOIDList   
          )
        )
      )
    )
)
UNION
SELECT DISTINCT EC.ID, EC.Code 
FROM 
  EvaluationCriteria EC 
WHERE EC.CriterionType = 2 and 
EC.ID IN
(
  SELECT AAC.EvaluationCriterion_ID FROM ApprovingAreaCriteria AAC
  JOIN ApprovingAreas AA ON AA.ID = AAC.Parent_ID
  WHERE 
    AAC.RequiredFromDate$Date <= :FromDate AND
    AA.TypeDefinition = 2 AND AAC.Parent_ID IN
      (
        SELECT AASM.Parent_ID FROM ApprovingAreaStoreMenus AASM WHERE AASM.StoreMenuItem_ID IN
        (
          SELECT SD.Obj_ID FROM SelDat SD where SD.Sel_ID = :StoreMenusItemsOIDList   
        )
      )
)
ORDER BY 2 

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