APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on JTF_IH_MEDIA_ITM_LC_SEG_TYS

Line 1058: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps

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
1062: msegs.resource_id is not null

Line 1274: JTF_IH_MEDIA_ITM_LC_SEG_TYS ih_milcs_ty

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 ;
1278:

Line 1343: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps

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
1347: mtyps.milcs_code = 'WITH_AGENT'