Yeah
He was found in his coffin in the basement of Shinra Mansion in Nibelheim after you defeat Lost Number.
You go to the cave to close up Vincents storyline and get his ultimate weapon and final limit break.
(
phoenixmay Put some depleted uranium on it!,
Thu 28 Feb 2008, 0:54,
archived)