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_ACCESSES_REPORT dependencies on JTF_RS_GROUP_MEMBERS

Line 73: jtf_rs_group_members mem,

69: from jtf_rs_groups_b grpb,
70: jtf_rs_role_relations rrel2,
71: jtf_rs_roles_b rrb2,
72: jtf_rs_resource_extns rsc2,
73: jtf_rs_group_members mem,
74: fnd_user fnu
75: where grpb.group_id = mem.group_id
76: and trunc(sysdate) between grpb.start_date_active
77: and nvl(grpb.end_date_active, trunc(sysdate))

Line 101: jtf_rs_group_members gmem,

97: CURSOR cur_sales_rep IS
98: select distinct rsc.source_id pid,
99: rsc.source_name flname
100: from jtf_rs_resource_extns rsc,
101: jtf_rs_group_members gmem,
102: jtf_rs_role_relations rrel,
103: jtf_rs_roles_b rrb,
104: (select distinct grpd.group_id
105: from jtf_rs_groups_denorm grpd,

Line 109: jtf_rs_group_members mem,

105: from jtf_rs_groups_denorm grpd,
106: jtf_rs_role_relations rrel2,
107: jtf_rs_roles_b rrb2,
108: jtf_rs_resource_extns rsc2,
109: jtf_rs_group_members mem,
110: fnd_user fnu
111: where grpd.parent_group_id = mem.group_id
112: and nvl(grpd.end_date_active, trunc(sysdate)) >= trunc(sysdate)
113: and rrb2.role_type_code in ('SALES','TELESALES')