"erotically willing and desirable female," 1929, from sex (n.) + pot (n.1), perhaps suggested by fleshpot.
A person, esp a woman, who is especially attractive and provocative sexually: How pitiful the American who cannot command the smile of a sexpot (1954+)