263: SELECT lobs.file_id, acc.resource_id
264: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
265: fnd_document_categories_tl fnddoccat_tl,
266: fnd_attached_documents fndattdoc, fnd_lobs lobs,
267: csl_jtf_tasks_acc acc, asg_user asg
268: WHERE fndattdoc.document_id = fnddoc_tl.document_id
269: AND fnddoc_tl.language = asg.language
270: AND fnddoc_tl.document_id = fnddoc.document_id
271: AND fnddoc_tl.media_id = lobs.file_id
698: SELECT lobs.file_id, acc.resource_id
699: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
700: fnd_document_categories_tl fnddoccat_tl,
701: fnd_attached_documents fndattdoc, fnd_lobs lobs,
702: csl_jtf_tasks_acc acc, asg_user asg
703: WHERE fndattdoc.document_id = fnddoc_tl.document_id
704: AND fnddoc_tl.language = asg.language
705: AND fnddoc_tl.document_id = fnddoc.document_id
706: AND fnddoc_tl.media_id = lobs.file_id