Document Number is empty in FND_DOCUMENTS_VL table

Summary:

Hi all,

I have an issue when I try to retrive a file loaded on a Document of Record.

I use this query because I need to retrieve DM_VERSION_NUMBER,DM_DOCUMENT_ID to create the link to retrieve the link from content server, but these fields are empty.

select

FDT.DM_VERSION_NUMBER,
FDT.DM_DOCUMENT_ID,
fad.CATEGORY_NAME ,
DOC_TYPE.DOCUMENT_TYPE,
fdt.file_name,
PN.FULL_NAME
from
HR_DOCUMENTS_OF_RECORD HDR
JOIN HR_DOCUMENT_TYPES_TL DOC_TYPE ON DOC_TYPE.DOCUMENT_TYPE_ID = HDR.DOCUMENT_TYPE_ID
JOIN FND_ATTACHED_DOCUMENTS FAD ON HDR.DOCUMENTS_OF_RECORD_ID = FAD.PK1_VALUE