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 JTF_RS_GROUP_MEMBERS

Line 217: JTF_RS_GROUP_MEMBERS J4,

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
219: where I1.session_id = I2.session_id
220: and I1.application_id = 696
221: and I1.active_flag ='T'

Line 244: JTF_RS_GROUP_MEMBERS J4

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
245: where I1.session_id = I2.session_id
246: and I1.application_id = 696
247: and I2.active_flag ='T'
248: and I2.activity_type_code = 'MEDIA'

Line 372: JTF_RS_GROUP_MEMBERS gp

368: INTO avgTalkTime
369: FROM jtf_ih_media_items ih_mitem,
370: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,
371: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps,
372: JTF_RS_GROUP_MEMBERS gp
373: where ih_mitem.start_date_time BETWEEN l_date_low and l_date_high
374: and ih_mitem.media_id = msegs.media_id
375: and mtyps.milcs_type_id = msegs.milcs_type_id
376: and ih_mitem.active = 'N'

Line 390: JTF_RS_GROUP_MEMBERS gp

386: JTF_IH_MEDIA_ITEM_LC_SEGS msegs1,
387: JTF_IH_MEDIA_ITEM_LC_SEGS msegs2,
388: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps1,
389: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps2,
390: JTF_RS_GROUP_MEMBERS gp
391: where ih_mitem.start_date_time BETWEEN l_date_low and l_date_high
392: and ih_mitem.media_id = msegs1.media_id
393: and ih_mitem.media_id = msegs2.media_id
394: and mtyps1.milcs_type_id = msegs1.milcs_type_id

Line 1090: JTF_RS_GROUP_MEMBERS J2

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
1091: where I1.session_id = I2.session_id
1092: and I1.application_id = 696
1093: and I1.active_flag ='T'
1094: and I1.end_date_time is NULL

Line 1120: JTF_RS_GROUP_MEMBERS J4,

1116: from CCT_AGENT_RT_STATS C1,
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

Line 1146: JTF_RS_GROUP_MEMBERS J4,

1142: I1.extension extension
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

Line 1173: JTF_RS_GROUP_MEMBERS J4,

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'
1177: and I1.application_id = 696

Line 1203: JTF_RS_GROUP_MEMBERS J4,

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 */
1207: where

Line 1228: from JTF_RS_GROUP_MEMBERS J4,

1224: Cursor getNoneStatusAgentList is
1225: select
1226: J5.resource_name agentName,
1227: J4.resource_id agentID
1228: from JTF_RS_GROUP_MEMBERS J4,
1229: JTF_RS_RESOURCE_EXTNS_VL J5
1230: where J4.group_id = v_group_id
1231: and J5.resource_id = J4.resource_id
1232: and J5.resource_id not in