eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIX_DM_EMAIL_SUMMARY_PKG dependencies on JTF_IH_MEDIA_ITM_LC_SEG_TYS

Line 271: jtf_ih_media_itm_lc_seg_tys b,

267: --
268: SELECT a.media_id media_id,
269: MAX(c.start_date_time) start_date_time
270: FROM jtf_ih_media_item_lc_segs a,
271: jtf_ih_media_itm_lc_seg_tys b,
272: jtf_ih_media_item_lc_segs c,
273: jtf_ih_media_itm_lc_seg_tys d
274: WHERE a.start_date_time BETWEEN g_rounded_collect_start_date AND g_rounded_collect_end_date
275: AND a.milcs_type_id = b.milcs_type_id

Line 273: jtf_ih_media_itm_lc_seg_tys d

269: MAX(c.start_date_time) start_date_time
270: FROM jtf_ih_media_item_lc_segs a,
271: jtf_ih_media_itm_lc_seg_tys b,
272: jtf_ih_media_item_lc_segs c,
273: jtf_ih_media_itm_lc_seg_tys d
274: WHERE a.start_date_time BETWEEN g_rounded_collect_start_date AND g_rounded_collect_end_date
275: AND a.milcs_type_id = b.milcs_type_id
276: AND b.milcs_code = 'EMAIL_REPLY'
277: AND a.media_id = c.media_id

Line 282: JTF_IH_MEDIA_ITM_LC_SEG_TYS ih_lc_seg_typs,

278: AND c.milcs_type_id = d.milcs_type_id
279: AND d.milcs_code IN ('EMAIL_FETCH','EMAIL_TRANSFER')
280: GROUP BY a.media_id
281: ) email_fetch_time,
282: JTF_IH_MEDIA_ITM_LC_SEG_TYS ih_lc_seg_typs,
283: --iem_route_classifications iem_r_c,
284: --
285: --Changes for R12
286: --

Line 563: JTF_IH_MEDIA_ITM_LC_SEG_TYS ih_lc_seg_typs,

559: ih_lc_segs_fetch.START_DATE_TIME start_date_time,
560: g_rounded_collect_end_date end_date_time
561: FROM JTF_IH_MEDIA_ITEMS ih_mitem,
562: JTF_IH_MEDIA_ITEM_LC_SEGS ih_lc_segs_fetch,
563: JTF_IH_MEDIA_ITM_LC_SEG_TYS ih_lc_seg_typs,
564: --IEM_ROUTE_CLASSIFICATIONS iem_r_c
565: --
566: --Changes for R12
567: --

Line 584: JTF_IH_MEDIA_ITM_LC_SEG_TYS C

580: AND NOT EXISTS
581: (
582: SELECT 'DUMMY'
583: FROM JTF_IH_MEDIA_ITEM_LC_SEGS B,
584: JTF_IH_MEDIA_ITM_LC_SEG_TYS C
585: WHERE ih_lc_segs_fetch.MEDIA_ID = B.MEDIA_ID
586: AND B.MILCS_TYPE_ID = C.MILCS_TYPE_ID
587: AND C.MILCS_CODE IN
588: ('EMAIL_FETCH', 'EMAIL_RESOLVED', 'EMAIL_AUTO_REDIRECTED', 'EMAIL_AUTO_DELETED',

Line 606: JTF_IH_MEDIA_ITM_LC_SEG_TYS C

602: SELECT MEDIA_ID,
603: RESOURCE_ID,
604: START_DATE_TIME
605: FROM JTF_IH_MEDIA_ITEM_LC_SEGS B,
606: JTF_IH_MEDIA_ITM_LC_SEG_TYS C
607: WHERE B.MILCS_TYPE_ID = C.MILCS_TYPE_ID
608: AND C.MILCS_CODE IN
609: ('EMAIL_FETCH', 'EMAIL_RESOLVED', 'EMAIL_AUTO_REDIRECTED', 'EMAIL_AUTO_DELETED',
610: 'EMAIL_AUTO_REPLY', 'EMAIL_OPEN', 'EMAIL_AUTO_ROUTED', 'EMAIL_AUTO_UPDATED_SR',

Line 618: JTF_IH_MEDIA_ITM_LC_SEG_TYS Z,

614: --it should have been closed within the collection date range
615: --
616: ) X,
617: JTF_IH_MEDIA_ITEM_LC_SEGS Y,
618: JTF_IH_MEDIA_ITM_LC_SEG_TYS Z,
619: --IEM_ROUTE_CLASSIFICATIONS iem_r_c
620: --
621: --Changes for R12
622: --

Line 829: JTF_IH_MEDIA_ITM_LC_SEG_TYS ih_lc_seg_typs,

825: min(A.start_date_time) email_start_date_time --very first time that the email was open in ANY of the agents
826: FROM JTF_IH_MEDIA_ITEMS ih_mitem,
827: JTF_IH_MEDIA_ITEM_LC_SEGS ih_lc_segs_fetch,
828: jtf_ih_media_item_lc_segs A,
829: JTF_IH_MEDIA_ITM_LC_SEG_TYS ih_lc_seg_typs,
830: jtf_ih_media_itm_lc_seg_tys B,
831: --IEM_ROUTE_CLASSIFICATIONS iem_r_c
832: --
833: --Changes for R12

Line 830: jtf_ih_media_itm_lc_seg_tys B,

826: FROM JTF_IH_MEDIA_ITEMS ih_mitem,
827: JTF_IH_MEDIA_ITEM_LC_SEGS ih_lc_segs_fetch,
828: jtf_ih_media_item_lc_segs A,
829: JTF_IH_MEDIA_ITM_LC_SEG_TYS ih_lc_seg_typs,
830: jtf_ih_media_itm_lc_seg_tys B,
831: --IEM_ROUTE_CLASSIFICATIONS iem_r_c
832: --
833: --Changes for R12
834: --

Line 859: JTF_IH_MEDIA_ITM_LC_SEG_TYS C

855: AND NOT EXISTS
856: (
857: SELECT 'DUMMY'
858: FROM JTF_IH_MEDIA_ITEM_LC_SEGS B,
859: JTF_IH_MEDIA_ITM_LC_SEG_TYS C
860: WHERE ih_lc_segs_fetch.MEDIA_ID = B.MEDIA_ID
861: --AND ih_lc_segs_fetch.RESOURCE_ID = B.RESOURCE_ID -- comment out for 11.5.10 features
862: AND B.MILCS_TYPE_ID = C.MILCS_TYPE_ID
863: AND C.MILCS_CODE IN ('EMAIL_REPLY','EMAIL_DELETED','EMAIL_TRANSFERRED', 'EMAIL_ESCALATED', 'EMAIL_REQUEUED',

Line 890: JTF_IH_MEDIA_ITM_LC_SEG_TYS C

886: SELECT MEDIA_ID,
887: RESOURCE_ID,
888: START_DATE_TIME
889: FROM JTF_IH_MEDIA_ITEM_LC_SEGS B,
890: JTF_IH_MEDIA_ITM_LC_SEG_TYS C
891: WHERE B.MILCS_TYPE_ID = C.MILCS_TYPE_ID
892: AND C.MILCS_CODE IN ('EMAIL_REPLY','EMAIL_DELETED','EMAIL_TRANSFERRED', 'EMAIL_ESCALATED', 'EMAIL_REQUEUED',
893: 'EMAIL_ASSIGN','EMAIL_REROUTED_DIFF_ACCT', 'EMAIL_REROUTED_DIFF_CLASS')
894: AND B.START_DATE_TIME BETWEEN g_rounded_collect_start_date AND g_rounded_collect_end_date

Line 898: JTF_IH_MEDIA_ITM_LC_SEG_TYS Z,

894: AND B.START_DATE_TIME BETWEEN g_rounded_collect_start_date AND g_rounded_collect_end_date
895: ) X,
896: JTF_IH_MEDIA_ITEM_LC_SEGS Y,
897: jtf_ih_media_item_lc_segs Y1,
898: JTF_IH_MEDIA_ITM_LC_SEG_TYS Z,
899: JTF_IH_MEDIA_ITM_LC_SEG_TYS Z1,
900: --IEM_ROUTE_CLASSIFICATIONS iem_r_c
901: --
902: --Changes for R12

Line 899: JTF_IH_MEDIA_ITM_LC_SEG_TYS Z1,

895: ) X,
896: JTF_IH_MEDIA_ITEM_LC_SEGS Y,
897: jtf_ih_media_item_lc_segs Y1,
898: JTF_IH_MEDIA_ITM_LC_SEG_TYS Z,
899: JTF_IH_MEDIA_ITM_LC_SEG_TYS Z1,
900: --IEM_ROUTE_CLASSIFICATIONS iem_r_c
901: --
902: --Changes for R12
903: --

Line 990: jtf_ih_media_itm_lc_seg_tys lc_seg_typs

986: FROM
987: (
988: SELECT lc_segs.start_date_time start_date_time
989: FROM jtf_ih_media_item_lc_segs lc_segs,
990: jtf_ih_media_itm_lc_seg_tys lc_seg_typs
991: WHERE lc_segs.media_id = l_media_id
992: AND lc_segs.resource_id = l_resource_id
993: AND lc_segs.start_date_time > l_start_date
994: AND lc_segs.milcs_type_id = lc_seg_typs.milcs_type_id