In this article, we will try to fetch the requisition attachment details using SQL Query.
As part of ORC, when we create requisitions we have an option to attach relevant documents to the Job Requisition which will help the Hiring Manager/Recruiter identify any supporting documents which identify the purpose of the requisition (Replacement/New).
SELECT irc.requisition_number, irc.title,
fd.file_name,
TO_CHAR(fd.creation_date, 'DD/MM/YYYY') attached_date
FROM irc_requisitions_vl irc,
fnd_attached_documents fad,
fnd_documents_vl fd
WHERE 1=1
AND TO_CHAR(irc.requisition_id) = fad.pk1_value
AND fad.document_id = fd.document_id
AND datatype_code = 'FILE'
--AND irc.requisition_number = :P_REQUISITION_NUMBER
ORDER BY fad.last_update_date desc
