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_QUEUE_MANAGEMENT_PVT dependencies on IEM_AGENTS

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

283:
284: -- l_current_user := 1000691;
285:
286: Begin
287: select a.agent_id into l_agent_account_id from iem_agents a, jtf_rs_resource_extns b
288: where a.resource_id=b.resource_id and b.user_id=l_current_user and a.email_account_id=l_post_mdts.email_account_id;
289: Exception
290: WHEN NO_DATA_FOUND THEN
291: l_agent_account_id := 0;

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

616:
617: l_string := 'select resource_id, resource_name, last_login_time, real_last_login_time from (
618: select a.resource_id, concat(concat(rs.source_last_name, '', ''), rs.source_first_name) as resource_name,
619: 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
620: from iem_agents a, jtf_rs_resource_extns rs, ieu_sh_sessions c
621: where a.resource_id = rs.resource_id and a.resource_id=c.resource_id
622: and a.email_account_id =:email_account_id and c.application_id=680
623: and trunc(sysdate) between trunc(nvl(rs.start_date_active, sysdate))
624: and trunc(nvl(rs.end_date_active, sysdate))

Line 645: from iem_agents a, jtf_rs_resource_extns rs

641: l_string2 := ' group by a.resource_id, rs.source_last_name, rs.source_first_name
642: union all
643: select a.resource_id, concat(concat(rs.source_last_name, '', ''), rs.source_first_name) as resource_name
644: , '''' as last_login_time, to_date('''', ''dd-mon-yy'') as real_last_login_time
645: from iem_agents a, jtf_rs_resource_extns rs
646: where a.resource_id = rs.resource_id and a.email_account_id = :email_account_id
647: and trunc(sysdate) between trunc(nvl(rs.start_date_active, sysdate))
648: and trunc(nvl(rs.end_date_active, sysdate))
649: and rs.user_id in

Line 665: (select a.resource_id from iem_agents a, ieu_sh_sessions b where b.application_id=680 and

661: and rel.role_resource_type = ''RS_INDIVIDUAL''
662: and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
663: and trunc(nvl(rel.end_date_active, sysdate)) )
664: and a.resource_id not in
665: (select a.resource_id from iem_agents a, ieu_sh_sessions b where b.application_id=680 and
666: a.resource_id=b.resource_id and a.email_account_id =:email_account_id ) ) order by real_last_login_time ';
667:
668: l_string := l_string || l_string2 || l_sort_order;
669:

Line 719: from iem_agents agact, iem_rt_proc_emails pm, jtf_rs_resource_extns rs

715: end if;
716:
717: l_string := 'select resource_id, fetched_emails, resource_name from
718: ( SELECT agact.resource_id, count(*) fetched_emails, concat(concat(rs.source_last_name, '',''), rs.source_first_name) as resource_name
719: from iem_agents agact, iem_rt_proc_emails pm, jtf_rs_resource_extns rs
720: WHERE pm.resource_id=agact.resource_id
721: and agact.resource_id = rs.resource_id
722: and pm.email_account_id=agact.email_account_id and pm.queue_status is null
723: and agact.email_account_id=:email_account_id

Line 744: from iem_agents agact, jtf_rs_resource_extns rs

740: and trunc(nvl(rel.end_date_active, sysdate)) )
741: group by agact.resource_id, rs.source_last_name, rs.source_first_name ';
742:
743: l_string2 := ' union all SELECT agact.resource_id, 0, concat(concat(rs.source_last_name, '', ''), rs.source_first_name) as resource_name
744: from iem_agents agact, jtf_rs_resource_extns rs
745: WHERE agact.resource_id = rs.resource_id
746: and agact.email_account_id=:email_account_id
747: and trunc(sysdate) between trunc(nvl(rs.start_date_active, sysdate))
748: and trunc(nvl(rs.end_date_active, sysdate))

Line 917: jtf_rs_group_members c, iem_agents d, jtf_rs_group_usages gu

913: trunc(sysdate) between trunc(nvl(e.start_date_active, sysdate))
914: and trunc(nvl(e.end_date_active, sysdate))
915: and f.group_id=e.group_id and f.resource_id=0 and f.email_account_id=:email_account_id and f.group_id in (
916: select unique c.group_id from
917: jtf_rs_group_members c, iem_agents d, jtf_rs_group_usages gu
918: where
919: c.delete_flag = ''N'' and c.resource_id = d.resource_id and d.email_account_id =:l_email_account_id
920: and c.group_id = gu.group_id and gu.usage = ''CALL''
921: ) group by f.group_id, e.group_name

Line 924: jtf_rs_group_members c, iem_agents d, jtf_rs_groups_vl e,

920: and c.group_id = gu.group_id and gu.usage = ''CALL''
921: ) group by f.group_id, e.group_name
922: union all
923: select unique e.group_id, group_name, 0 from
924: jtf_rs_group_members c, iem_agents d, jtf_rs_groups_vl e,
925: jtf_rs_group_usages gu where
926: c.group_id = e.group_id
927: and c.delete_flag = ''N'' and c.resource_id = d.resource_id and d.email_account_id =:l_email_account_id
928: and trunc(sysdate) between trunc(nvl(e.start_date_active, sysdate))

Line 962: --select count(*) into l_agent_count from jtf_rs_roles_tl a, jtf_rs_role_relations b, jtf_rs_group_members c, iem_agents d

958: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_group_name);
959: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_email_count);
960:
961: -- Start changes for bug no. 7418671
962: --select count(*) into l_agent_count from jtf_rs_roles_tl a, jtf_rs_role_relations b, jtf_rs_group_members c, iem_agents d
963: --where a.role_id in (28, 29, 30) and a.language = USERENV ('LANG') and a.role_id = b.role_id and b.delete_flag = 'N'
964: --and b.role_resource_id = c.resource_id and c.delete_flag = 'N' and c.resource_id = d.resource_id
965: --and d.email_account_id = l_email_account_id and c.group_id = l_group_id;
966: SELECT count(*) into l_agent_count

Line 967: FROM jtf_rs_group_members c, iem_agents d

963: --where a.role_id in (28, 29, 30) and a.language = USERENV ('LANG') and a.role_id = b.role_id and b.delete_flag = 'N'
964: --and b.role_resource_id = c.resource_id and c.delete_flag = 'N' and c.resource_id = d.resource_id
965: --and d.email_account_id = l_email_account_id and c.group_id = l_group_id;
966: SELECT count(*) into l_agent_count
967: FROM jtf_rs_group_members c, iem_agents d
968: WHERE c.resource_id IN
969: (select b.role_resource_id from jtf_rs_role_relations b
970: where b.role_resource_id=c.resource_id and b.role_id IN (28,29,30)
971: AND b.delete_flag='N'

Line 1004: -- jtf_rs_role_relations b, jtf_rs_group_members c, iem_agents d, jtf_rs_groups_vl e, jtf_rs_resource_extns res, jtf_rs_group_usages gu

1000: end if;
1001:
1002: -- Start changes for bug no. 7418671
1003: --l_string := 'select e.group_id, e.group_name, count(*) agent_count from
1004: -- jtf_rs_role_relations b, jtf_rs_group_members c, iem_agents d, jtf_rs_groups_vl e, jtf_rs_resource_extns res, jtf_rs_group_usages gu
1005: -- where b.delete_flag = ''N'' and b.role_id in (28, 29, 30)
1006: -- and b.role_resource_id = c.resource_id and c.group_id = e.group_id
1007: -- and c.resource_id=res.resource_id
1008: -- and c.group_id = gu.group_id

Line 1020: FROM jtf_rs_group_members c, iem_agents d, jtf_rs_groups_vl e, jtf_rs_resource_extns res, jtf_rs_group_usages gu

1016: -- and c.delete_flag = ''N''
1017: -- and c.resource_id = d.resource_id and d.email_account_id = :l_email_account_id
1018: -- group by e.group_id, e.group_name ';
1019: l_string := 'SELECT e.group_id, e.group_name, COUNT(*) agent_count
1020: FROM jtf_rs_group_members c, iem_agents d, jtf_rs_groups_vl e, jtf_rs_resource_extns res, jtf_rs_group_usages gu
1021: WHERE c.group_id = e.group_id AND c.resource_id = res.resource_id
1022: AND c.group_id = gu.group_id
1023: AND c.resource_id in
1024: (select b.role_resource_id from jtf_rs_role_relations b