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.JTF_RS_ROLES_VUHK dependencies on CN_SRP_COMP_TEAMS_V

Line 122: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_srp_comp_groups_v scg

118: select distinct ct.name name,
119: ct.comp_team_id team_id,
120: greatest(scg.start_date_active, ct.start_date_active) start_date,
121: Least(nvl(ct.end_date_active, l_max_date) , nvl(scg.end_date_active, l_max_date)) end_date
122: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_srp_comp_groups_v scg
123: where scg.role_id = p_role_id
124: and srt.salesrep_id = scg.salesrep_id
125: and srt.comp_team_id = ct.comp_team_id
126: and (scg.start_date_active <= ct.start_date_active