In Teradata SQL how to get random number between a pair, coming from field/column?
This will return a number within the requested range:
RANDOM(0, 2147483647) mod (T.VAL_MAX - T.VAL_MIN +1 ) + T.VAL_MIN

But there might be a minimal bias towards the lower numbers due to MOD, e.g. for 1-3 you get following probablities:
1,2 = 715,827,883 / 2,147,483,648 
  3 = 715,827,882 / 2,147,483,648