Sunday, September 13, 2020
attachment details of any entity
SELECT fad.document_id, fad.entity_name, fad.pk1_value, fds.media_id,
fds.file_name
FROM fnd_attached_documents fad,
per_objectives peo,
fnd_documents fds
--, fnd_lobs flb ,FND_DOCUMENTS_LONG_TEXT, FND_DOCUMENTS_SHORT_TEXT,FND_DOCUMENTS_LONG_RAW
WHERE fad.pk1_value = TO_CHAR (peo.objective_id)
AND fad.entity_name = 'PER_OBJECTIVES'
AND fad.document_id = fds.document_id
-- AND fds.media_id = flb.file_id
AND ( TO_CHAR (peo.start_date, 'YYYY') = '2020'
OR TO_CHAR (peo.target_date, 'YYYY') = '2020'
);
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment