APPS.IEM_SENDMAIL_PVT dependencies on JTF_AMV_ATTACHMENTS

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

43:
44: l_val2:=l_tval||'(187)';
45: SELECT fl.file_id
46: INTO l_file_id
47: FROM jtf_amv_items_tl b ,jtf_amv_attachments a ,fnd_lobs fl
48: WHERE b.item_id = a.attachment_used_by_id
49: and a.attachment_used_by='ITEM'
50: AND a.file_id = fl.file_id
51: AND b.item_id=p_template_id