Objektová akce

Kód:

10

Tělo:

 SELECT {FIELDS}
  FROM PLMReqRoutinesMat A
  WHERE A.PARENT_ID = :OBJID
  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 = A.STORECARD_ID
  		)
  )  		
  ORDER BY A.PosIndex  

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