APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on JTF_IH_MEDIA_ITEM_LC_SEGS

Line 745: FROM jtf_ih_media_item_lc_segs

741: BEGIN
742:
743: SELECT min(start_date_time)
744: INTO l_talk_start_time
745: FROM jtf_ih_media_item_lc_segs
746: WHERE media_id = p_media_id
747: AND resource_id = p_resource_id;
748:
749: SELECT min(start_date_time), max(end_date_time)

Line 1057: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,

1053: msegs.duration DURATION,
1054: msegs.start_date_time START_DATE_TIME,
1055: msegs.end_date_time END_DATE_TIME
1056: from
1057: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,
1058: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps
1059: where
1060: msegs.media_id = p_media_id and
1061: msegs.MILCS_TYPE_ID = mtyps.MILCS_TYPE_ID and

Line 1273: JTF_IH_MEDIA_ITEM_LC_SEGS ih_milcs,

1269: v_abandon_time ,
1270: l_with_agent_segs,
1271: l_number_of_rerouts
1272: from
1273: JTF_IH_MEDIA_ITEM_LC_SEGS ih_milcs,
1274: JTF_IH_MEDIA_ITM_LC_SEG_TYS ih_milcs_ty
1275: where
1276: ih_milcs.media_id = call.media_id and
1277: ih_milcs.MILCS_TYPE_ID = ih_milcs_ty.MILCS_TYPE_ID ;

Line 1336: from JTF_IH_MEDIA_ITEM_LC_SEGS

1332: -- get agent info only if there are agent segments:
1333: if l_with_agent_segs > 0 then
1334:
1335: select min(resource_id) into l_call_answered_by_r_id
1336: from JTF_IH_MEDIA_ITEM_LC_SEGS
1337: where JTF_IH_MEDIA_ITEM_LC_SEGS.media_id =
1338: call.media_id
1339: and resource_id is not null
1340: and start_date_time =

Line 1337: where JTF_IH_MEDIA_ITEM_LC_SEGS.media_id =

1333: if l_with_agent_segs > 0 then
1334:
1335: select min(resource_id) into l_call_answered_by_r_id
1336: from JTF_IH_MEDIA_ITEM_LC_SEGS
1337: where JTF_IH_MEDIA_ITEM_LC_SEGS.media_id =
1338: call.media_id
1339: and resource_id is not null
1340: and start_date_time =
1341: (select min(msegs.start_date_time) from

Line 1342: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,

1338: call.media_id
1339: and resource_id is not null
1340: and start_date_time =
1341: (select min(msegs.start_date_time) from
1342: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,
1343: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps
1344: where
1345: msegs.media_id = call.media_id and
1346: msegs.MILCS_TYPE_ID = mtyps.MILCS_TYPE_ID and