APPS.BIX_REAL_TIME_RPTS_PKG dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 1088: JTF_RS_RESOURCE_EXTNS_VL J,

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
1091: where I1.session_id = I2.session_id
1092: and I1.application_id = 696

Line 1118: JTF_RS_RESOURCE_EXTNS_VL J,

1114: I1.extension extension,
1115: C2.classification class
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

Line 1144: JTF_RS_RESOURCE_EXTNS_VL J,

1140: (l_date_high - C1.last_update_date)*24*3600 wrapTime,
1141: /* J3.group_name groupName,*/
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

Line 1174: JTF_RS_RESOURCE_EXTNS_VL J5,

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
1178: and I1.end_date_time is NULL

Line 1204: JTF_RS_RESOURCE_EXTNS_VL J5,

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
1208: (I1.active_flag is null or I1.active_flag='F') /* 'N' */

Line 1229: JTF_RS_RESOURCE_EXTNS_VL J5

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
1233: (select col3