1074: FROM fnd_attached_documents fad,
1075: fnd_documents fd,
1076: fnd_documents_tl fdtl,
1077: fnd_lobs fl,
1078: fnd_documents_short_text fst
1079: WHERE fad.document_id = fd.document_id
1080: AND fd.document_id = fdtl.document_id
1081: AND fl.file_id(+) = fd.media_id
1082: AND fst.media_id(+) = fd.media_id