Třídová akce

Kód:

2

Tělo:

SELECT R.ID AS ID1, RT.ID AS ID2 
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 NULL 
ORDER BY RT.DefaultType ASC

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