DBA Data[Home] [Help]

APPS.IEM_EMAIL_PROC_PVT dependencies on FND_LOBS

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

3322: ELSIF p_doc_tbl(i).type='A' THEN
3323:
3324: SELECT fl.file_name
3325: INTO l_file_name
3326: FROM jtf_amv_items_tl b ,jtf_amv_attachments a ,fnd_lobs fl
3327: WHERE b.item_id = a.attachment_used_by_id
3328: and a.attachment_used_by='ITEM'
3329: AND a.file_id = fl.file_id
3330: AND b.item_id=p_doc_tbl(i).doc_id