Hootermania(1994)

"Sir" Bob Thing is a tit-deprived "idiot" who's lived in a bathtub all his life. The celestial Mama Jama gives him the commission to search for the "impeccable pair of fleshy orbs" with the understanding that his success will re-establish and set the world back into the proper order of erotic well-being. Sir Bob's guide and companion on his quest is a talking pocket pussy with an attitude. That should help.