U r question was not clear . U can reimport the source tables and try again if u had any source qualifier query override u cannot write the query manually
by using sequence generating option write...