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.AST_OFL_LEAD_ASSIGN_PARAM dependencies on JTF_RS_GROUP_MEMBERS

Line 97: , Jtf_rs_group_members mem

93: FROM Jtf_rs_groups_b grpb
94: , Jtf_rs_role_relations rrel2
95: , Jtf_rs_roles_b rrb2
96: , Jtf_rs_resource_extns rsc2
97: , Jtf_rs_group_members mem
98: , Fnd_user fnu
99: WHERE grpb.group_id = mem.group_id
100: AND TRUNC(SYSDATE) BETWEEN grpb.start_date_active
101: AND NVL(grpb.end_date_active, TRUNC(SYSDATE))

Line 136: jtf_rs_group_members gmem,

132: /*
133: select distinct rsc.source_id pid,
134: rsc.source_name flname
135: from jtf_rs_resource_extns rsc,
136: jtf_rs_group_members gmem,
137: jtf_rs_role_relations rrel,
138: jtf_rs_roles_b rrb,
139: (select distinct grpd.group_id
140: from jtf_rs_groups_denorm grpd,

Line 144: jtf_rs_group_members mem,

140: from jtf_rs_groups_denorm grpd,
141: jtf_rs_role_relations rrel2,
142: jtf_rs_roles_b rrb2,
143: jtf_rs_resource_extns rsc2,
144: jtf_rs_group_members mem,
145: fnd_user fnu
146: where grpd.parent_group_id = mem.group_id
147: and nvl(grpd.end_date_active, trunc(sysdate)) >= trunc(sysdate)
148: and rrb2.role_type_code in ('SALES','TELESALES')