Delve into the scientific basis of Flavoxate Hydrochloride's effectiveness in treating urological conditions, explaining its pharmacological action.