Thanks for both of yours reply.....

The view is basically used to extract the data from our system and send to other system.

The strange things is that the view normally runs...