SELECT distinct RT.ID FROM PLMRoutines R, PLMRoutineTypes RT WHERE ((R.StoreCard_ID=:StoreCard_ID) AND (R.ReleasedBy_ID IS NOT NULL) AND (R.RoutineType_ID = RT.ID) AND (RT.ManuallyEnteredRtn = 'N') AND RT.DEFAULTTYPE = 'A' ) UNION ALL SELECT distinct RT.ID FROM PLMRoutines R, PLMRoutineTypes RT WHERE ((R.StoreCard_ID=:StoreCard_ID) AND (R.ReleasedBy_ID IS NOT NULL) AND (R.RoutineType_ID = RT.ID) AND (RT.ManuallyEnteredRtn = 'N') AND RT.DEFAULTTYPE = 'N' ) UNION ALL SELECT RT.ID FROM PLMRoutineTypes RT WHERE RT.ManuallyEnteredRtn = 'A'
Generated by ABRA Software a.s. 27.10.2021 16:34:49