Instead of static list, using a table select result for IN key
In most cases replacement IN clause with EXISTS clause gives performance boost.
Try this:

WHERE exists (SELECT 1 FROM LOVs WHERE value = STypeID )