Třídová akce

Kód:

13

Tělo:

  select A.ID FROM PLMWorkPlaces A
  where A.Hidden =  'N'
  and A.CRPPlan > 0
  and A.WorkplaceType = 0
  and exists(
  select 1 from PLMWORKPLACESMACHINES WM 
  JOIN PLMMACHINES M ON M.ID = WM.MACHINE_ID AND M.MACHINEKIND = 0
  JOIN PLMMACHINECOMPETENCES MC ON MC.PARENT_ID = M.ID
  JOIN CRPCOMPETENCES C ON C.ID = MC.COMPETENCE_ID
  JOIN CRPCOMPETENCECATEGORIES CC ON CC.ID = C.CATEGORY 
  WHERE WM.PARENT_ID = A.ID
  )

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