APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on JTF_IH_MEDIA_ITEMS

Line 1037: FROM JTF_IH_MEDIA_ITEMS ih_mitem

1033: DECODE(UPPER(ih_mitem.direction),'INBOUND',DECODE(UPPER(ih_mitem.media_abandon_flag),'Y',1,0),0) CALLS_ABANDONED ,
1034: ih_mitem.media_abandon_flag MEDIA_ABANDON_FLAG ,
1035: ih_mitem.source_item_id SOURCE_ITEM_ID,
1036: ih_mitem.start_date_time CALL_START_TIME
1037: FROM JTF_IH_MEDIA_ITEMS ih_mitem
1038: WHERE ih_mitem.start_date_time BETWEEN g_min_call_begin_date AND g_max_call_begin_date
1039: AND
1040: (
1041: ih_mitem.media_item_type = 'TELE_INB' or

Line 1190: FROM jtf_ih_media_items

1186: --
1187:
1188: SELECT MIN(start_date_time),MAX(start_date_time)
1189: INTO g_min_call_begin_date,g_max_call_begin_date
1190: FROM jtf_ih_media_items
1191: WHERE last_update_date BETWEEN g_collect_start_date AND g_collect_end_date
1192: AND
1193: (
1194: media_item_type = 'TELE_INB' or