The self-consistent random phase approximation