SELECT R.ID, RT.DEFAULTTYPE
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
R.Revided_ID IS NULLGenerated by ABRA Software a.s. 27.10.2021 16:34:49