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_REAL_TIME_RPTS_PKG dependencies on IEU_SH_SESSIONS

Line 214: from IEU_SH_SESSIONS I1,

210: and (sysdate - last_update_date) * 24 * 60 > 60;
211:
212: /* get talking agents for graph */
213: select count(distinct I1.resource_id) into talk_graph
214: from IEU_SH_SESSIONS I1,
215: IEU_SH_ACTIVITIES I2,
216: CCT_media_items M,
217: JTF_RS_GROUP_MEMBERS J4,
218: CCT_AGENT_RT_STATS C1

Line 240: from IEU_SH_SESSIONS I1,

236:
237: /* get wrapping agents for graph */
238: /* removed
239: Select count(distinct I1.resource_id) into wrap_graph
240: from IEU_SH_SESSIONS I1,
241: IEU_SH_ACTIVITIES I2,
242: CCT_AGENT_RT_STATS C1,
243: CCT_media_items M,
244: JTF_RS_GROUP_MEMBERS J4

Line 508: from ieu_sh_sessions

504: ------------------*/
505:
506: select sum(decode(end_date_time, null, l_date_high-begin_date_time,
507: end_date_time-begin_date_time))*3600*24 into loggedin
508: from ieu_sh_sessions
509: where resource_id = v_agent_id
510: and begin_date_time between l_date_low and l_date_high
511: and application_id = 696;
512:

Line 522: ieu_sh_sessions I2

518: ----------*/
519: select sum(decode(I1.deliver_date_time,null,l_date_high-I1.begin_date_time,
520: I1.deliver_date_time-I1.begin_date_time))*3600*24 into available
521: from ieu_sh_activities I1,
522: ieu_sh_sessions I2
523: where I1.session_id = I2.session_id
524: and I2.resource_id = v_agent_id
525: and I2.begin_date_time between l_date_low and l_date_high
526: and I2.application_id = 696

Line 550: ieu_sh_sessions I1

546: and J3.media_item_type = 'TELEPHONE';
547:
548: select sum(l_date_high-I2.deliver_date_time)*3600*24 into talk_now
549: from ieu_sh_activities I2,
550: ieu_sh_sessions I1
551: where I1.session_id = I2.session_id
552: and I1.resource_id = v_agent_id
553: and I1.application_id = 696
554: and I1.active_flag = 'T'

Line 569: from IEU_SH_SESSIONS I1,

565: wrap: wrap_now + wrap_past
566: --------------------------*/
567:
568: Select sum(l_date_high - C1.last_update_date)*24*3600 into wrap_now
569: from IEU_SH_SESSIONS I1,
570: IEU_SH_ACTIVITIES I2,
571: CCT_AGENT_RT_STATS C1
572: where I1.session_id = I2.session_id
573: and I1.application_id = 696

Line 705: from IEU_SH_SESSIONS I1,

701:
702: Cursor getAvailableAgentList is
703: Select
704: (l_date_high - I2.begin_date_time)*24*3600 duration
705: from IEU_SH_SESSIONS I1,
706: IEU_SH_ACTIVITIES I2
707: where I1.session_id = I2.session_id
708: and I1.application_id = 696
709: and I1.active_flag ='T'

Line 733: IEU_SH_SESSIONS I1,

729: Select
730: (l_date_high - C1.last_update_date)*24*3600 duration
731: from CCT_AGENT_RT_STATS C1,
732: /* CCT_MEDIA_ITEMS C2,*/
733: IEU_SH_SESSIONS I1,
734: IEU_SH_ACTIVITIES I2
735: where C1.has_call = 'F'
736: and C1.agent_id = v_resource_id
737: /*and C2.media_item_id = I2.media_id*/

Line 750: from IEU_SH_SESSIONS I1

746:
747: Cursor getLoggedinAgentList is /* for idle*/
748: Select
749: (l_date_high-I1.begin_date_time)*24*3600 duration
750: from IEU_SH_SESSIONS I1
751: where
752: I1.active_flag = 'T'
753: and I1.application_id = 696
754: and I1.end_date_time is NULL

Line 761: from IEU_SH_SESSIONS I1

757:
758: Cursor getLogoutList is
759: select
760: (l_date_high-I1.end_date_time)*24*3600 duration
761: from IEU_SH_SESSIONS I1
762: where (I1.active_flag is null or I1.active_flag = 'F')
763: /* I1.begin_date_time between l_date_low and l_date_high */
764: /* the agent logged not necessary in today */
765: and I1.resource_id = v_resource_id

Line 770: from IEU_SH_SESSIONS

766: and I1.application_id = 696
767: and I1.resource_id not in /* make sure no new sessoin logged in by this agent */
768: (
769: select distinct(resource_id)
770: from IEU_SH_SESSIONS
771: where end_date_time is null
772: );
773:
774: /* there should be only one current login for an agent */

Line 778: from IEU_SH_SESSIONS I1,

774: /* there should be only one current login for an agent */
775: /* today: does not make sense
776: Cursor getTodayLoginTime is
777: select l_date_high-I1.begin_date_time loginTime
778: from IEU_SH_SESSIONS I1,
779: IEU_SH_ACTIVITIES I2
780: where I1.session_id = I2.session_id
781: and I1.application_id = 696
782: and I1.begin_date_time between l_date_low and l_date_high

Line 789: from IEU_SH_SESSIONS I1,

785: */
786:
787: Cursor getLoginTime is
788: select min(l_date_high-I1.begin_date_time)*24*3600 loginTime
789: from IEU_SH_SESSIONS I1,
790: IEU_SH_ACTIVITIES I2
791: where I1.session_id = I2.session_id
792: and I1.application_id = 696
793: and I1.resource_id = v_resource_id

Line 801: from IEU_SH_SESSIONS I1

797: select
798: (I1.begin_date_time-l_date_low)*3600*24 loginTime,
799: (I1.end_date_time-l_date_low)*3600*24 logoutTime,
800: I1.end_reason_code reason
801: from IEU_SH_SESSIONS I1
802: where
803: I1.begin_date_time between l_date_low and l_date_high
804: and I1.resource_id = v_resource_id
805: and I1.application_id = 696

Line 908: from IEU_SH_SESSIONS I1,

904: l_string := bix_util_pkg.get_hrmiss_frmt(v_duration);
905: end if;
906:
907: select count(I2.media_id) into CallsHandled
908: from IEU_SH_SESSIONS I1,
909: IEU_SH_ACTIVITIES I2
910: where I1.session_id = I2.session_id
911: and I1.application_id = 696
912: and I1.begin_date_time between l_date_low and l_date_high

Line 1086: from IEU_SH_SESSIONS I1,

1082: J.resource_name agentName,
1083: (l_date_high - I2.begin_date_time)*24*3600 availTime,
1084: /* J1.group_name groupName,*/
1085: I1.extension extension
1086: from IEU_SH_SESSIONS I1,
1087: IEU_SH_ACTIVITIES I2,
1088: JTF_RS_RESOURCE_EXTNS_VL J,
1089: JTF_RS_GROUPS_VL J1,
1090: JTF_RS_GROUP_MEMBERS J2

Line 1121: IEU_SH_SESSIONS I1,

1117: CCT_MEDIA_ITEMS C2,
1118: JTF_RS_RESOURCE_EXTNS_VL J,
1119: JTF_RS_GROUPS_VL J3,
1120: JTF_RS_GROUP_MEMBERS J4,
1121: IEU_SH_SESSIONS I1,
1122: IEU_SH_ACTIVITIES I2
1123: where C1.has_call = 'T'
1124: and C1.agent_id = J.resource_id
1125: and C2.media_item_id = I2.media_id

Line 1147: IEU_SH_SESSIONS I1,

1143: from CCT_AGENT_RT_STATS C1,
1144: JTF_RS_RESOURCE_EXTNS_VL J,
1145: JTF_RS_GROUPS_VL J3,
1146: JTF_RS_GROUP_MEMBERS J4,
1147: IEU_SH_SESSIONS I1,
1148: IEU_SH_ACTIVITIES I2
1149: where C1.has_call = 'F'
1150: and C1.agent_id = J.resource_id
1151: /* and C2.media_item_id = I2.media_id */

Line 1172: from IEU_SH_SESSIONS I1,

1168: J5.resource_name agentName,
1169: (l_date_high-I1.begin_date_time)*24*3600 idleTime,
1170: /* J3.group_name groupName,*/
1171: I1.extension extension
1172: from IEU_SH_SESSIONS I1,
1173: JTF_RS_GROUP_MEMBERS J4,
1174: JTF_RS_RESOURCE_EXTNS_VL J5,
1175: JTF_RS_GROUPS_VL J3
1176: where I1.active_flag = 'T'

Line 1202: from IEU_SH_SESSIONS I1,

1198: (l_date_high-I1.end_date_time)*24*3600 loggedoutTime,
1199: /* J3.group_name groupName,*/
1200: I1.extension extension,
1201: I1.end_reason_code reasoncode
1202: from IEU_SH_SESSIONS I1,
1203: JTF_RS_GROUP_MEMBERS J4,
1204: JTF_RS_RESOURCE_EXTNS_VL J5,
1205: JTF_RS_GROUPS_VL J3
1206: /* , FND_LOOKUPS F */

Line 1218: from IEU_SH_SESSIONS

1214: and (J5.server_group_id = v_site_id or (v_site_id =-999 or v_site_id is null)) /* no classification assigned */
1215: and I1.resource_id not in /* make sure no new sessoin logged in by this agent */
1216: (
1217: select distinct(resource_id)
1218: from IEU_SH_SESSIONS
1219: where end_date_time is null
1220: )
1221: order by J5.resource_name;
1222: