Is there also a shortcut in CS6?
Right-click on the filename, etc, in a document window titlebar. If the document is in a tabbed window then right-click on the tab name and pick Reveal In Finder.
By the way, for reference by the future readers of this thread: Conroy's tip works in Windows too, though the wording is a little different.
Retrieving data ...