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.IEX_UTILITIES dependencies on JTF_RS_ROLE_RELATIONS

Line 84: from jtf_rs_role_relations rel, jtf_rs_roles_b rol,jtf_rs_resource_extns ext

80: l_manager varchar2(1) := 'N';
81:
82: Cursor get_manager_role_c(l_user_id number) is
83: select nvl(rol.manager_flag,'N') manager_role
84: from jtf_rs_role_relations rel, jtf_rs_roles_b rol,jtf_rs_resource_extns ext
85: where rel.role_resource_id = ext.resource_id
86: and rol.role_id = rel.role_id
87: and rol.active_flag = 'Y'
88: and rol.role_code = 'IEX_MANAGER'

Line 4948: l_select1 := l_select1 || ' jtf_rs_role_relations jtr, jtf_rs_roles_b jtrr '; -- Added by bibeura for bug 12562473

4944:
4945: -- Initialize SQL statements - REMEMBER CHANGING 1 MEANS CHANGING ALL
4946: l_select1 := 'SELECT ac.employee_id, ac.resource_id, 0 ';
4947: l_select1 := l_select1 || 'FROM hz_customer_profiles hp, ar_collectors ac,jtf_rs_resource_extns rs, ';
4948: l_select1 := l_select1 || ' jtf_rs_role_relations jtr, jtf_rs_roles_b jtrr '; -- Added by bibeura for bug 12562473
4949: l_where1 := 'WHERE ';
4950: l_where1 := l_where1 || ' hp.collector_id = ac.collector_id ';
4951: l_where1 := l_where1 || ' and ac.resource_type = ''RS_RESOURCE'' ';
4952: l_where1 := l_where1 || ' and trunc(nvl(ac.inactive_date,sysdate)) >= trunc(sysdate) ';

Line 4967: l_select2 := l_select2 || ' , jtf_rs_role_relations jtr,JTF_RS_ROLES_b jtrr ';

4963:
4964: l_select2 := 'SELECT jtg.person_id, jtg.resource_id, count(work_item_id) ';
4965: l_select2 := l_select2 || 'FROM hz_customer_profiles hp, iex_strategy_work_items wi, ';
4966: l_select2 := l_select2 || ' ar_collectors ac, jtf_rs_group_members jtg, jtf_rs_resource_extns rs ';
4967: l_select2 := l_select2 || ' , jtf_rs_role_relations jtr,JTF_RS_ROLES_b jtrr ';
4968: l_where2 := 'WHERE ';
4969: l_where2 := l_where2 || ' hp.collector_id = ac.collector_id ';
4970: l_where2 := l_where2 || ' and ac.resource_type = ''RS_GROUP'' ';
4971: l_where2 := l_where2 || ' and ac.resource_id = jtg.group_id ';

Line 4994: l_select3 := l_select3 || ' , jtf_rs_role_relations jtr,JTF_RS_ROLES_b jtrr ';

4990:
4991: l_select3 := 'SELECT jtg.person_id, jtg.resource_id, 0 ';
4992: l_select3 := l_select3 || 'FROM hz_customer_profiles hp, ar_collectors ac, ';
4993: l_select3 := l_select3 || ' jtf_rs_group_members jtg, jtf_rs_resource_extns rs ';
4994: l_select3 := l_select3 || ' , jtf_rs_role_relations jtr,JTF_RS_ROLES_b jtrr ';
4995: l_where3 := ' WHERE ';
4996: l_where3 := l_where3 || ' hp.collector_id = ac.collector_id ';
4997: l_where3 := l_where3 || ' and ac.resource_type = ''RS_GROUP'' ';
4998: l_where3 := l_where3 || ' and ac.resource_id = jtg.group_id ';

Line 5041: l_select5 := l_select5 || ' , jtf_rs_role_relations jtr,JTF_RS_ROLES_b jtrr ';

5037: --Added following sql's for getting resource for task creation in dunning callback concurrent program
5038: l_select5 := ' SELECT jtg.person_id, jtg.resource_id, count(t.task_id) ';
5039: l_select5 := l_select5 || ' FROM hz_customer_profiles hp, jtf_tasks_vl t, jtf_task_statuses_vl s, ';
5040: l_select5 := l_select5 || ' ar_collectors ac, jtf_rs_group_members jtg, jtf_rs_resource_extns rs ';
5041: l_select5 := l_select5 || ' , jtf_rs_role_relations jtr,JTF_RS_ROLES_b jtrr ';
5042: l_where5 := ' WHERE ';
5043: l_where5 := l_where5 || ' hp.collector_id = ac.collector_id ';
5044: l_where5 := l_where5 || ' and ac.resource_type = ''RS_GROUP'' ';
5045: l_where5 := l_where5 || ' and ac.resource_id = jtg.group_id ';

Line 5070: l_select6 := l_select6 || ' , jtf_rs_role_relations jtr,JTF_RS_ROLES_b jtrr ';

5066:
5067: l_select6 := 'SELECT jtg.person_id, jtg.resource_id, 0 ';
5068: l_select6 := l_select6 || ' FROM hz_customer_profiles hp, ar_collectors ac, ';
5069: l_select6 := l_select6 || ' jtf_rs_group_members jtg, jtf_rs_resource_extns rs ';
5070: l_select6 := l_select6 || ' , jtf_rs_role_relations jtr,JTF_RS_ROLES_b jtrr ';
5071: l_where6 := ' WHERE ';
5072: l_where6 := l_where6 || ' hp.collector_id = ac.collector_id ';
5073: l_where6 := l_where6 || ' and ac.resource_type = ''RS_GROUP'' ';
5074: l_where6 := l_where6 || ' and ac.resource_id = jtg.group_id ';