Třídová akce

Popis:

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

Kód:

3

Tělo:

SELECT 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 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.ReleasedBy_ID IS NOT NULL)  
  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