Question about FND_LOBS
Hi
I try to use the following query to get the information of the FND_LOBS records grouped by application
Select
fl.file_id, fl.file_name, fde.application_id, fatl.application_name
from fnd_lobs fl, fnd_document_entities fde, fnd_attached_documents fad,
fnd_documents_TL fdtl, fnd_application_tl fatl
where fdtl.media_id = fl.file_id
and fdtl.document_id = fad.document_id
and fl.program_name = 'FNDATTCH'
and fad.entity_name=fde.data_object_code
and fatl.application_id=fde.application_id
order by fde.application_id;
but It returned many duplicate records with the same FILE_ID and FILE_NAME