Document of Record Link Query in Fusion HCM

select
fad.DOCUMENT_ID  ,
fdv.DM_DOCUMENT_ID CONTENT_ID,
fdv.datatype_code ,
fdv.FILE_NAME ,
fdv.TITLE ,
fdv.URL ,
fdv.DESCRIPTION ,
HDOR.DOCUMENT_CODE ,
PAPF.PERSON_NUMBER ,
HDTB.DOCUMENT_TYPE ,
fad.ENTITY_NAME ,
fdv.DM_VERSION_NUMBER COLUMNDATA,
'https://'||(SELECT EXTERNAL_VIRTUAL_HOST INSTANCE_NAME
   FROM FUSION.ASK_DEPLOYED_DOMAINS
  WHERE DEPLOYED_DOMAIN_NAME = 'FADomain')
||'/cs/idcplg?IdcService=GET_FILE&dID='
|| fdt.dm_version_number
||'&dDocName='
|| fdt.dm_document_id
|| '&allowInterrupt=1' UCM_file_link

FROM
FND_ATTACHED_DOCUMENTS fad,
fnd_documents_vl fdv,
PER_ALL_PEOPLE_F PAPF,
HR_DOCUMENT_TYPES_vl HDTB,
HR_DOCUMENTS_OF_RECORD HDOR,
fnd_documents_tl   FDT
WHERE fad.document_id = fdv.document_id
and   PAPF.PERSON_ID = HDOR.PERSON_ID
AND HDTB.DOCUMENT_TYPE_ID = HDOR.DOCUMENT_TYPE_ID
and to_char(HDOR.documents_of_record_id) = to_char(FAD.pk1_value)
AND PAPF.PERSON_NUMBER = '500027'
AND fad.document_id = fdt.document_id

AND fdt.language = 'US'