All scripts above has
Code: Select all
c.status not in ('V')

replace it to
Code: Select all
c.status in ('R')