APPS.BIX_REAL_TIME_RPTS_PKG dependencies on JTF_RS_GROUPS_VL

Line 1089: JTF_RS_GROUPS_VL J1,

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
1093: and I1.active_flag ='T'

Line 1119: JTF_RS_GROUPS_VL J3,

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
1123: where C1.has_call = 'T'

Line 1145: JTF_RS_GROUPS_VL J3,

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
1149: where C1.has_call = 'F'

Line 1175: JTF_RS_GROUPS_VL J3

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
1179: and I1.begin_date_time between l_date_low and l_date_high

Line 1205: JTF_RS_GROUPS_VL J3

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

Line 1298: from JTF_RS_GROUPS_VL

1294: RETURN;
1295: END IF;
1296:
1297: Select group_name into l_groupName
1298: from JTF_RS_GROUPS_VL
1299: where group_id = v_group_id;
1300:
1301: if l_groupName is null
1302: then l_groupName:= l_unknown;