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_AGENT_INBOX_MGMT_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 62: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;

58: l_customer_name hz_parties.party_name%type;
59: l_received_date varchar2(500);
60: l_real_received_date iem_rt_proc_emails.received_date%type;
61: l_message_uid iem_rt_proc_emails.message_id%type;
62: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;
63: l_rt_media_item_id iem_rt_media_items.rt_media_item_id%type;
64: l_agent_id iem_rt_proc_emails.resource_id%type;
65:
66: l_cursorID INTEGER;

Line 137: from iem_rt_proc_emails a, iem_route_classifications b, hz_parties c, jtf_rs_resource_extns_vl d, iem_rt_media_items e

133: l_query_string1 := 'select a.message_id, a.email_account_id, a.from_address, a.subject, b.name as classification_name,
134: c.party_name as customer_name,
135: to_char(a.received_date, ''MM/DD/RRRR HH24:MI:SS'') as received_date, a.received_date as real_received_date, a.message_id,
136: d.resource_name, e.rt_media_item_id, a.resource_id
137: from iem_rt_proc_emails a, iem_route_classifications b, hz_parties c, jtf_rs_resource_extns_vl d, iem_rt_media_items e
138: where a.resource_id <> 0 and a.message_id=e.message_id and e.expire=''N'' and a.email_account_id=:email_account_id
139: and a.rt_classification_id=b.route_classification_id and a.customer_id=c.party_id and a.resource_id=d.resource_id ';
140:
141: l_customer_string2 := ' and UPPER(c.party_name) like UPPER(:customer_name)';

Line 150: from iem_rt_proc_emails a, iem_route_classifications b, jtf_rs_resource_extns_vl d, iem_rt_media_items e

146: l_query_string1 := 'select a.message_id, a.email_account_id, a.from_address, a.subject, b.name as classification_name,
147: decode(a.customer_id, -1, '''', 0, '''', (select party_name from hz_parties where party_id=a.customer_id) ) as customer_name,
148: to_char(a.received_date, ''MM/DD/RRRR HH24:MI:SS'') as received_date, a.received_date as real_received_date, a.message_id, d.resource_name,
149: e.rt_media_item_id, a.resource_id
150: from iem_rt_proc_emails a, iem_route_classifications b, jtf_rs_resource_extns_vl d, iem_rt_media_items e
151: where a.resource_id <> 0 and a.message_id=e.message_id and e.expire=''N'' and a.email_account_id=:email_account_id
152: and a.rt_classification_id=b.route_classification_id and a.resource_id=d.resource_id ';
153: end if;
154:

Line 269: select a.agent_id into l_agent_account_id from iem_agents a, jtf_rs_resource_extns b

265:
266: --l_current_user := 1001608;
267:
268: Begin
269: select a.agent_id into l_agent_account_id from iem_agents a, jtf_rs_resource_extns b
270: where a.resource_id=b.resource_id and b.user_id=l_current_user and a.email_account_id=l_email_account_id;
271: Exception
272: WHEN NO_DATA_FOUND THEN
273: l_agent_account_id := 0;

Line 353: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;

349: email_dtl_cur get_message_rec;
350: l_post_mdts iem_agent_inbox_mgmt_pvt.temp_message_type;
351: l_classification_name iem_route_classifications.name%type;
352: l_party_name hz_parties.party_name%type;
353: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;
354: l_received_date varchar2(500);
355: l_string varchar2(32767):='';
356: l_query_string1 varchar2(15000):='';
357: l_query_string2 varchar2(15000):='';

Line 400: from iem_rt_proc_emails a, iem_route_classifications b, hz_parties c, jtf_rs_resource_extns_vl d, iem_rt_media_items e

396:
397: if (p_customer_name is not null) then
398:
399: l_query_string1 := 'select count(*)
400: from iem_rt_proc_emails a, iem_route_classifications b, hz_parties c, jtf_rs_resource_extns_vl d, iem_rt_media_items e
401: where a.resource_id <> 0 and a.message_id=e.message_id and e.expire=''N'' and a.email_account_id=:email_account_id
402: and a.rt_classification_id=b.route_classification_id and a.customer_id=c.party_id and a.resource_id=d.resource_id ';
403:
404: l_customer_string2 := ' and UPPER(c.party_name) like UPPER(:customer_name)';

Line 410: from iem_rt_proc_emails a, iem_route_classifications b, jtf_rs_resource_extns_vl d, iem_rt_media_items e

406:
407: else
408:
409: l_query_string1 := 'select count(*)
410: from iem_rt_proc_emails a, iem_route_classifications b, jtf_rs_resource_extns_vl d, iem_rt_media_items e
411: where a.resource_id <> 0 and a.message_id=e.message_id and e.expire=''N'' and a.email_account_id=:email_account_id
412: and a.rt_classification_id=b.route_classification_id and a.resource_id=d.resource_id ';
413: end if;
414:

Line 621: from iem_agents a, jtf_rs_resource_extns rs, ieu_sh_sessions c,

617:
618: l_string1 := 'select resource_id, resource_name, last_login_time, real_last_login_time from (
619: select a.resource_id, concat(concat(rs.source_last_name, '', ''), rs.source_first_name) as resource_name,
620: to_char(max(c.begin_date_time), ''MM/DD/RRRR HH24:MI:SS'') as last_login_time, max(c.begin_date_time) as real_last_login_time
621: from iem_agents a, jtf_rs_resource_extns rs, ieu_sh_sessions c,
622: fnd_responsibility resp, fnd_user_resp_groups respgrp, fnd_user fu
623: where a.resource_id = rs.resource_id and a.resource_id=c.resource_id
624: and a.email_account_id =:email_account_id and c.application_id=680
625: and rs.user_id=respgrp.user_id and respgrp.user_id=fu.user_id

Line 644: from iem_agents a, jtf_rs_resource_extns rs,

640: l_string2 := ' group by a.resource_id, rs.source_last_name, rs.source_first_name
641: union all
642: select a.resource_id, concat(concat(rs.source_last_name, '', ''), rs.source_first_name) as resource_name
643: , '''' as last_login_time, to_date('''', ''dd-mon-yy'') as real_last_login_time
644: from iem_agents a, jtf_rs_resource_extns rs,
645: fnd_responsibility resp, fnd_user_resp_groups respgrp, fnd_user fu
646: where a.resource_id = rs.resource_id and a.email_account_id = :email_account_id
647: and rs.user_id=respgrp.user_id and respgrp.user_id=fu.user_id
648: and respgrp.responsibility_id=resp.responsibility_id and resp.application_id=680

Line 738: jtf_rs_resource_extns rs, fnd_responsibility resp,fnd_user_resp_groups respgrp, fnd_user fu

734:
735: l_string1 := 'select resource_id, fetched_emails, resource_name from
736: ( SELECT agact.resource_id, count(*) fetched_emails, concat(concat(rs.source_last_name, '',''), rs.source_first_name) as resource_name
737: from IEM_AGENTS agact, iem_rt_proc_emails pm,
738: jtf_rs_resource_extns rs, fnd_responsibility resp,fnd_user_resp_groups respgrp, fnd_user fu
739: WHERE pm.resource_id=agact.resource_id
740: and agact.resource_id = rs.resource_id and rs.user_id=respgrp.user_id and respgrp.user_id=fu.user_id
741: and pm.email_account_id=agact.email_account_id and pm.queue_status is null
742: and agact.email_account_id=:email_account_id

Line 759: from IEM_AGENTS agact, jtf_rs_resource_extns rs, fnd_responsibility resp,fnd_user_resp_groups respgrp, fnd_user fu

755: and trunc(nvl(rel.end_date_active, sysdate)) ) ';
756:
757: l_string2 := 'group by agact.resource_id, rs.source_last_name, rs.source_first_name
758: union all SELECT agact.resource_id, 0, concat(concat(rs.source_last_name, '', ''), rs.source_first_name) as resource_name
759: from IEM_AGENTS agact, jtf_rs_resource_extns rs, fnd_responsibility resp,fnd_user_resp_groups respgrp, fnd_user fu
760: WHERE agact.resource_id = rs.resource_id and rs.user_id=respgrp.user_id and respgrp.user_id=fu.user_id
761: and agact.email_account_id=:email_account_id
762: and respgrp.responsibility_id=resp.responsibility_id and resp.application_id=680
763: and resp.responsibility_key = :resource_role