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