APPS.BIX_REAL_TIME_BINS_PKG dependencies on CCT_MEDIA_ITEMS

Line 26: from CCT_MEDIA_ITEMS C1

22: Select count(C1.MEDIA_ITEM_ID) calls_waiting,
23: nvl(sum(sysdate - C1.last_update_date)*24*3600/decode(count(C1.MEDIA_ITEM_ID),0,1,null,1,count(C1.media_item_id)),0)
24: avg_queue_time,
25: C1.classification classification
26: from CCT_MEDIA_ITEMS C1
27: where C1.status = 1
28: and media_type = 0
29: and C1.creation_date between l_date_low and l_date_high
30: group by classification;