I'm never that intoxicated. And I also talk to my friends at home, not just at parties, that helps. And being a safe haven has downsides... "The Friend Zone".
I must say that most of my female friends know I that I both like them as a friend and as an sexually attractive human being. They seem okay with that. I'm not going to deny that I have fantasies of well... All of my female friends. They usually say it's pretty flattering and I tend to keep all of my friends, so I guess there's no harm in being honest about that. Sometimes it's mutual. Which is nice