Firstly...........What a post!
Secondly.....my input
My analysis (for whats its worth) Rachel + Drink = Problem!
1) I think somebody needs to sit down (whilst sober) and explain to Rachel, If she is drunk she comes no where near the flat....END OF!
2) Explain that there needs to be some respect for all other parties in the flat.. may i suggest?? some house rules!!
3) I know its not your issue and some may say to keep out....however im with you on the fact that you have to live there too
4) Explain to James that its getting up your nose, if he is any sort of mate then he will do something about it.
Overall it seems that Rachel is the issue, she needs sacking off !!
I hope that helped?