DBA Data[Home] [Help]

APPS.IEM_EMAIL_PROC_PVT dependencies on FND_LOBS

Line 4421: FROM jtf_amv_items_tl b ,jtf_amv_attachments a ,fnd_lobs fl

4417: ELSIF p_doc_tbl(i).type='A' THEN
4418:
4419: SELECT fl.file_name
4420: INTO l_file_name
4421: FROM jtf_amv_items_tl b ,jtf_amv_attachments a ,fnd_lobs fl
4422: WHERE b.item_id = a.attachment_used_by_id
4423: and a.attachment_used_by='ITEM'
4424: AND a.file_id = fl.file_id
4425: AND b.item_id=p_doc_tbl(i).doc_id