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.

APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_INTENT_DTLS

Line 4713: from iem_intent_dtls a,iem_account_intents b

4709: l_theme_buf IEM_TEXT_PVT.theme_tAble;
4710: l_token_buf IEM_TEXT_PVT.token_table;
4711: cursor c1 is
4712: SELECT a.intent_id, a.keyword,a.weight
4713: from iem_intent_dtls a,iem_account_intents b
4714: WHERE b.email_account_id=l_email_account_id
4715: AND a.intent_id=b.intent_id
4716: AND QUERY_RESPONSE='Q'
4717: and weight>0

Line 4720: SELECT keyword,weight FROM iem_intent_dtls

4716: AND QUERY_RESPONSE='Q'
4717: and weight>0
4718: order by 1;
4719: CURSOR get_theme_csr IS
4720: SELECT keyword,weight FROM iem_intent_dtls
4721: where intent_id=l_class_id
4722: AND QUERY_RESPONSE='Q'
4723: and weight>0
4724: order by 2 desc;

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

5515: g_app_id number;
5516: cursor c1 is select category_id from iem_account_categories
5517: where email_account_id=l_email_account_id;
5518: cursor c2 is
5519: select keyword,weight from iem_intent_dtls where intent_id=l_classification_id
5520: and query_response='R';
5521: cursor c_doc is
5522: select document_id,KB_REPOSITORY_NAME,score,kb_result_id from iem_kb_results
5523: where message_id=l_msg_id