Třídová akce

Popis:

Vrátí typy technologických postupů - aktuální

Kód:

6

Tělo:

SELECT RT.ID FROM PLMRoutines R, PLMRoutineTypes RT
WHERE (R.StoreCard_ID=:StoreCard_ID) 
  AND (R.RoutineType_ID = RT.ID) 
  AND (RT.ManuallyEnteredRtn = 'N' 
  AND R.REVIDED_ID IS NULL)
  AND RT.DEFAULTTYPE = 'A'
UNION ALL
SELECT RT.ID FROM PLMRoutines R, PLMRoutineTypes RT
WHERE (R.StoreCard_ID=:StoreCard_ID) 
  AND (R.RoutineType_ID = RT.ID) 
  AND (RT.ManuallyEnteredRtn = 'N' 
  AND R.REVIDED_ID IS NULL)
  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