APPS.BIX_DM_REAL_QUEUE_SUMMARY_PKG dependencies on JTF_IH_MEDIA_ITEM_LC_SEGS

Line 89: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,

85: p_period_start_time VARCHAR2,
86: p_period_start_date_time DATE) IS
87: SELECT SUM(NVL(msegs.duration,0)) ABANDON_TIME
88: FROM jtf_ih_media_items ih_mitem,
89: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,
90: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps
91: where ih_mitem.server_group_id = p_server_group_id
92: and ih_mitem.classification = p_classification
93: and TRUNC(ih_mitem.start_date_time) = p_period_start_date

Line 111: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,

107: p_period_start_time VARCHAR2,
108: p_period_start_date_time DATE) IS
109: SELECT count(distinct msegs.media_id) CALLS_ANSWRD_WITHIN_X_TIME
110: FROM jtf_ih_media_items ih_mitem,
111: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,
112: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps
113: where ih_mitem.server_group_id = p_server_group_id
114: and ih_mitem.classification = p_classification
115: and TRUNC(ih_mitem.start_date_time) = p_period_start_date

Line 134: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,

130: p_period_start_date_time DATE) IS
131: SELECT SUM(NVL(msegs.duration,0)) queue_time_answered,
132: count(distinct(ih_mitem.media_id)) calls_answered
133: FROM jtf_ih_media_items ih_mitem,
134: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,
135: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps
136: where ih_mitem.server_group_id = p_server_group_id
137: and ih_mitem.classification = p_classification
138: and ih_mitem.active = 'N'

Line 157: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,

153: p_period_start_date_time DATE) IS
154: SELECT SUM(NVL(msegs.duration,0)) talk_time,
155: count(distinct(msegs.media_id)) calls_handled
156: FROM jtf_ih_media_items ih_mitem,
157: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,
158: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps
159: where ih_mitem.server_group_id = p_server_group_id
160: and ih_mitem.classification = p_classification
161: and ih_mitem.active = 'N'