Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How to download the files that are uploaded in DOR against employee
hi
i have a query which shows al the files uploaded in DOR of emplyee .
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
FROM
FND_ATTACHED_DOCUMENTS fad,
fnd_documents_vl fdv,
PER_ALL_PEOPLE_F PAPF,
HR_DOCUMENT_TYPES_vl HDTB,
HR_DOCUMENTS_OF_RECORD HDOR
WHERE fad.document_id = fdv.document_id
and PAPF.PERSON_ID = HDOR.PERSON_ID
and papf.person_number = '<PERSON_NUMBER>'
Tagged:
0