APPS.BIX_CCI_COLLECT dependencies on JTF_IH_MEDIA_ITEM_LC_SEGS

Line 35: JTF_IH_MEDIA_ITEM_LC_SEGS ih_milcs,

31: ih_milcs.RESOURCE_ID,
32: DECODE(ih_milcs_ty.MILCS_CODE,'IN_QUEUE',1,'WITH_AGENT',2) segment_order
33: FROM
34: JTF_IH_MEDIA_ITEMS ih_mitem,
35: JTF_IH_MEDIA_ITEM_LC_SEGS ih_milcs,
36: JTF_IH_MEDIA_ITM_LC_SEG_TYS ih_milcs_ty
37: WHERE
38: (ih_mitem.MEDIA_ID = cv_ih_mi_id) and
39: (ih_mitem.MEDIA_ID = ih_milcs.MEDIA_ID) and

Line 53: FROM jtf_ih_interactions int, jtf_ih_media_item_lc_segs seg, jtf_ih_media_itm_lc_seg_tys tys

49: */
50:
51: CURSOR get_wrap_time(p_media_id NUMBER,p_resource_id NUMBER) IS
52: SELECT sum((int.end_date_time - seg.end_date_time) * 24 * 3600) wrap_time
53: FROM jtf_ih_interactions int, jtf_ih_media_item_lc_segs seg, jtf_ih_media_itm_lc_seg_tys tys
54: WHERE int.productive_time_amount = p_media_id
55: AND int.resource_id = p_resource_id
56: AND seg.media_id = p_media_id
57: AND seg.resource_id = p_resource_id