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

Line 582: jtf_rs_group_members grp_mem,

578: agt_sum.period_start_date_time,
579: SUM(agt_sum.available_time) available_time,
580: SUM(agt_sum.work_time) work_time
581: FROM BIX_DM_AGENT_SESSBYCAMP_sum agt_sum,
582: jtf_rs_group_members grp_mem,
583: jtf_rs_groups_denorm grp_denorm
584: WHERE agt_sum.period_start_date_time BETWEEN g_rounded_collect_start_date
585: AND g_rounded_collect_end_date
586: AND agt_sum.resource_id = grp_mem.resource_id

Line 600: from jtf_rs_group_members mem1

596: NVL(grp_denorm.start_date_active,agt_sum.period_start_date_time)
597: AND NVL(grp_denorm.end_date_active,SYSDATE)
598: AND grp_mem.group_member_id =
599: (select max(mem1.group_member_id)
600: from jtf_rs_group_members mem1
601: where mem1.group_id in
602: (select den1.group_id
603: from jtf_rs_groups_denorm den1
604: where den1.parent_group_id = grp_denorm.parent_group_id