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 JTF_RS_ROLE_RELATIONS

Line 635: and rs.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where

631: and trunc(nvl(respgrp.end_date, sysdate))
632: and trunc(sysdate) between trunc(nvl(fu.start_date, sysdate))
633: and trunc(nvl(fu.end_date, sysdate))
634: )
635: and rs.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where
636: rel.role_id in (28, 29, 30) and rel.delete_flag = ''N''
637: and rel.role_resource_type = ''RS_INDIVIDUAL''
638: and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
639: and trunc(nvl(rel.end_date_active, sysdate)) ) ';

Line 659: and rs.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where

655: and trunc(nvl(respgrp.end_date, sysdate))
656: and trunc(sysdate) between trunc(nvl(fu.start_date, sysdate))
657: and trunc(nvl(fu.end_date, sysdate))
658: )
659: and rs.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where
660: rel.role_id in (28, 29, 30) and rel.delete_flag = ''N''
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)) )

Line 736: and rs.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where

732: and trunc(nvl(respgrp.end_date, sysdate))
733: and trunc(sysdate) between trunc(nvl(fu.start_date, sysdate))
734: and trunc(nvl(fu.end_date, sysdate))
735: )
736: and rs.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where
737: rel.role_id in (28, 29, 30) and rel.delete_flag = ''N''
738: and rel.role_resource_type = ''RS_INDIVIDUAL''
739: and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
740: and trunc(nvl(rel.end_date_active, sysdate)) )

Line 759: and rs.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where

755: and trunc(nvl(respgrp.end_date, sysdate))
756: and trunc(sysdate) between trunc(nvl(fu.start_date, sysdate))
757: and trunc(nvl(fu.end_date, sysdate))
758: )
759: and rs.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where
760: rel.role_id in (28, 29, 30) and rel.delete_flag = ''N''
761: and rel.role_resource_type = ''RS_INDIVIDUAL''
762: and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
763: and trunc(nvl(rel.end_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 969: (select b.role_resource_id from jtf_rs_role_relations b

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'
972: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(b.start_date_active, sysdate))
973: AND TRUNC(NVL(b.end_date_active, sysdate)))

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 1024: (select b.role_resource_id from jtf_rs_role_relations b

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
1025: where b.role_resource_id=c.resource_id and b.role_id IN (28,29,30) and b.delete_flag=''N''
1026: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(b.start_date_active, sysdate))
1027: AND TRUNC(NVL(b.end_date_active, sysdate)))
1028: AND gu.usage = ''CALL''