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

Line 691: jtf_rs_group_members groups,

687: SUM(agt_sum.login_time) login_time,
688: SUM(agt_sum.idle_time) idle_time,
689: SUM(agt_sum.agent_cost) group_cost
690: FROM bix_dm_agent_session_sum agt_sum,
691: jtf_rs_group_members groups,
692: jtf_rs_groups_denorm group_denorm
693: WHERE agt_sum.period_start_date_time BETWEEN g_rounded_collect_start_date
694: AND g_rounded_collect_end_date
695: AND agt_sum.resource_id = groups.resource_id

Line 703: from jtf_rs_group_members mem1

699: NVL(group_denorm.start_date_active,agt_sum.period_start_date_time)
700: AND NVL(group_denorm.end_date_active,SYSDATE)
701: AND groups.group_member_id =
702: (select max(mem1.group_member_id)
703: from jtf_rs_group_members mem1
704: where mem1.group_id in
705: (select den1.group_id
706: from jtf_rs_groups_denorm den1
707: where den1.parent_group_id = group_denorm.parent_group_id