Johnny-one-noted

adj.

Displaying impaired speech or articulation due to alcohol.

Source: Wiktionary