Technology Stack - EBS (MOSC)

MOSC Banner

Question about FND_LOBS

edited Jun 12, 2015 10:02AM in Technology Stack - EBS (MOSC) 5 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center