Třídová akce

Kód:

49

Tělo:

SELECT RN.STORECARD_ID FROM PLMWORKSCHEDULEITEMS WS
JOIN PLMREQROUTINES RR ON  WS.REQROUTINE_ID = RR.ID 
JOIN PLMREQOUTPUTITEMS RO ON RR.PARENT_ID = RO.ID
JOIN PLMREQNODES RN ON RO.OWNER_ID = RN.ID
WHERE WS.ID = :WSIOID AND RR.FINISHED = 'A'
  AND (
  	NOT EXISTS (SELECT 1 FROM CRPPlanSettingsStoreMenuItems)	  	  
  	OR EXISTS (
  		SELECT 1 FROM CRPPlanSettingsStoreMenuItems SMI 
  		JOIN STORECARDMENUITEMLINKS SCL ON SCL.STOREMENUITEM_ID = SMI.CRPSTOREMENU_ID
  		WHERE SCL.STORECARD_ID = RN.STORECARD_ID
  		)
  )  

UNION
SELECT JN.STORECARD_ID FROM PLMWORKSCHEDULEITEMS WS
JOIN PLMJOBORDERSROUTINES JR ON  WS.JOROUTINE_ID = JR.ID 
JOIN PLMJOOUTPUTITEMS JO ON JR.PARENT_ID = JO.ID
JOIN PLMJONODES JN ON JO.OWNER_ID = JN.ID
WHERE WS.ID = :WSIOID AND JR.FINISHED = 'A'
  AND (
  	NOT EXISTS (SELECT 1 FROM CRPPlanSettingsStoreMenuItems)	  	  
  	OR EXISTS (
  		SELECT 1 FROM CRPPlanSettingsStoreMenuItems SMI 
  		JOIN STORECARDMENUITEMLINKS SCL ON SCL.STOREMENUITEM_ID = SMI.CRPSTOREMENU_ID
  		WHERE SCL.STORECARD_ID = JN.STORECARD_ID
  		)
  )  

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