Třídová akce

Popis:

Potenciální skladové karty materiálů pro operace omezené za skladová menu

Kód:

48

Tělo:

SELECT RM.STORECARD_ID FROM PLMWORKSCHEDULEITEMS WS
JOIN PLMREQROUTINES RR ON  WS.REQROUTINE_ID = RR.ID 
JOIN PLMREQROUTINESMAT RM ON RM.PARENT_ID = RR.ID
WHERE WS.ID = :WSIOID
  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 = RM.STORECARD_ID
  		)
  )  

UNION
SELECT JM.STORECARD_ID FROM PLMWORKSCHEDULEITEMS WS
JOIN PLMJOBORDERSROUTINES JR ON  WS.JOROUTINE_ID = JR.ID 
JOIN PLMJOROUTINESMAT JM ON JM.PARENT_ID = JR.ID
WHERE WS.ID = :WSIOID
  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 = JM.STORECARD_ID
  		)
  )  

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