eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_INTENT_DTLS

Line 3618: from iem_intent_dtls a,iem_account_intents b

3614: l_theme_buf IEM_TEXT_PVT.theme_tAble;
3615: l_token_buf IEM_TEXT_PVT.token_table;
3616: cursor c1 is
3617: SELECT a.intent_id, a.keyword,a.weight
3618: from iem_intent_dtls a,iem_account_intents b
3619: WHERE b.email_account_id=l_email_account_id
3620: AND a.intent_id=b.intent_id
3621: AND QUERY_RESPONSE='Q'
3622: and weight>0

Line 3625: SELECT keyword,weight FROM iem_intent_dtls

3621: AND QUERY_RESPONSE='Q'
3622: and weight>0
3623: order by 1;
3624: CURSOR get_theme_csr IS
3625: SELECT keyword,weight FROM iem_intent_dtls
3626: where intent_id=l_class_id
3627: AND QUERY_RESPONSE='Q'
3628: and weight>0
3629: order by 2 desc;

Line 4424: select keyword,weight from iem_intent_dtls where intent_id=l_classification_id

4420: g_app_id number;
4421: cursor c1 is select category_id from iem_account_categories
4422: where email_account_id=l_email_account_id;
4423: cursor c2 is
4424: select keyword,weight from iem_intent_dtls where intent_id=l_classification_id
4425: and query_response='R';
4426: cursor c_doc is
4427: select document_id,KB_REPOSITORY_NAME,score,kb_result_id from iem_kb_results
4428: where message_id=l_msg_id