I think the drinking music in "By Any Other Name" is new to the episode, and is not a version of the Finnegan music in "Shore Leave" (despite both being in 6/8 time). Nor does it derive from "Tribbles." Nor do I think any other episode reused it thereafter. I love it.