Třídová akce

Popis:

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

Kód:

17

Tělo:

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