select master.name, doc.versionida2versioninfo||'.'||doc.iterationida2iterationinfo version, app.filename, to_char(fvitem.uniquesequencenumber,'FM0XXXXXXXXXXXXX') "VAULTFILE", folder.name FOLDER
from wtdocumentmaster master, wtdocument doc, holdertocontent h, applicationdata app, fvitem fvitem, fvfolder folder
where doc.ida3masterreference= master.ida2a2 and doc.IDA2A2=h.IDA3A5 and h.IDA3B5=app.IDA2A2(+) and app.IDA3A5=fvitem.IDA2A2(+) and fvitem.IDA3A4=folder.IDA2A2
and master.wtdocumentnumber =< 文档编号 >;