APPS.BIX_CCI_COLLECT dependencies on JTF_IH_MEDIA_ITEMS

Line 22: FROM jtf_ih_media_items

18: end_date_time,
19: source_id,
20: DECODE(media_abandon_flag,'Y','ABANDON',
21: DECODE(media_transferred_flag,'Y','TRANSFER',NULL)) interaction_subtype
22: FROM jtf_ih_media_items
23: WHERE start_date_time between p_start_date and p_end_date
24: and active = 'N';
25:
26: CURSOR c_milcs (cv_ih_mi_id NUMBER) IS

Line 34: JTF_IH_MEDIA_ITEMS ih_mitem,

30: ih_milcs.HANDLER_ID,
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