A review petition under Article 137 of the Constitution is heard by the same judges (unless they are unavailable) who disposed of the original matter, which in this case is a transfer petition under section 25 of CPC.
It is to be filed with the Supreme Court within 30 days of the order/judgement sought to be reviewed.
First things first, a review petition is not the same thing as an appeal. With an appeal, you can challenge a decision on facts, on law or on both, depending on the nature of the appeal. Usually, the entire case is open for hearing. An appeal is to a higher court or forum.
A review on the other hand is fairly limited and is only maintainable in three situations:
1. Error apparent on the face of the record (read: a very major mistake by the court whose order is sought to be reviewed):
2. The discovery of new evidence that would make the order sought to be reviewed unsustainable (but it needs to be shown that such evidence is actually new and wasn’t available with the party filing review earlier); and
3.Other sufficient reason.
Whether it would be advisable and worthwhile (or a waste of time and money) to file a review in your friend’s case is something that can only be answered by an advocate who has access to the file and record of proceedings.
Let’s say if you have any fresh evidence pertaining to the threat to your friend’s life, it would be advisable to file a review petition. Or in case the Supreme Court overlooked something that it should have not ignored, your friend has a case for review. There are other possibilities but I would advise you to consult an advocate either offline or through this site.
In an appropriate case, where circumstances so justify, a petition for re-transfer might also be maintainable — especially in case of changed circumstances (say the in-laws harm or try to harm your friend and he files a criminal complaint against them).
I hope that answers your question. In case you have further queries, please feel free to ask.