APPS.IEX_DUNNING_PVT dependencies on JTF_FM_TEMPLATE_CONTENTS

Line 5966: FROM JTF_FM_TEMPLATE_CONTENTS

5962: CURSOR C_GET_CONTENTS (IN_TEMPLATE_ID NUMBER) IS
5963: SELECT --content_NUMBER,
5964: upper(substr(content_name,instr(content_name,'.')+1,length(content_name)-instr(content_name,'.'))) DocType,
5965: mes_doc_ID
5966: FROM JTF_FM_TEMPLATE_CONTENTS
5967: WHERE template_ID = in_template_ID
5968: AND nvl(upper(f_deletedflag),'0') <>'D'
5969: --bug 3090268
5970: --ORDER BY content_number;

Line 6411: || Source Tables: JTF_FM_TEMPLATE_CONTENTS, HZ_PARTIES, HZ_CONTACT_POINTS,

6407: || p_template_id = fulfillment template
6408: || p_method = Fulfillment Type, currently only 'EMAIL' is supported
6409: || p_party_id = pk to hz_parties
6410: ||
6411: || Source Tables: JTF_FM_TEMPLATE_CONTENTS, HZ_PARTIES, HZ_CONTACT_POINTS,
6412: || jtf_FM_query_mes
6413: || jtf_FM_query
6414: ||
6415: || Target Tables:

Line 6454: FROM JTF_FM_TEMPLATE_CONTENTS

6450: CURSOR C_GET_CONTENTS (IN_TEMPLATE_ID NUMBER) IS
6451: SELECT --content_NUMBER,
6452: upper(substr(content_name,instr(content_name,'.')+1,length(content_name)-instr(content_name,'.'))) DocType,
6453: mes_doc_ID
6454: FROM JTF_FM_TEMPLATE_CONTENTS
6455: WHERE template_ID = in_template_ID
6456: AND nvl(upper(f_deletedflag),'0') <>'D'
6457: --bug 3090268
6458: --ORDER BY content_number;