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.

[Home] [Help]

APPS.BIX_DM_EMAIL_SUMMARY_PKG dependencies on IEM_ROUTE_CLASSIFICATIONS

Line 283: --iem_route_classifications iem_r_c,

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: --
287: (

Line 289: from iem_route_classifications

285: --Changes for R12
286: --
287: (
288: select name, max(route_classification_id) route_classification_id
289: from iem_route_classifications
290: group by name
291: ) iem_r_c,
292: ( SELECT * FROM bix_dm_goals_emc
293: WHERE end_date_active IS NULL) goals

Line 564: --IEM_ROUTE_CLASSIFICATIONS iem_r_c

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: --
568: (

Line 570: from iem_route_classifications

566: --Changes for R12
567: --
568: (
569: select name, max(route_classification_id) route_classification_id
570: from iem_route_classifications
571: group by name
572: ) iem_r_c
573: WHERE ih_mitem.MEDIA_ITEM_TYPE = 'EMAIL'
574: AND ih_mitem.DIRECTION = 'INBOUND'

Line 619: --IEM_ROUTE_CLASSIFICATIONS iem_r_c

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: --
623: (

Line 625: from iem_route_classifications

621: --Changes for R12
622: --
623: (
624: select name, max(route_classification_id) route_classification_id
625: from iem_route_classifications
626: group by name
627: ) iem_r_c
628: WHERE a.MEDIA_ITEM_TYPE = 'EMAIL'
629: AND a.DIRECTION = 'INBOUND'

Line 831: --IEM_ROUTE_CLASSIFICATIONS iem_r_c

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: --
835: (

Line 837: from iem_route_classifications

833: --Changes for R12
834: --
835: (
836: select name, max(route_classification_id) route_classification_id
837: from iem_route_classifications
838: group by name
839: ) iem_r_c
840: WHERE ih_mitem.MEDIA_ITEM_TYPE = 'EMAIL'
841: AND ih_mitem.DIRECTION = 'INBOUND'

Line 900: --IEM_ROUTE_CLASSIFICATIONS iem_r_c

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: --
904: (

Line 906: from iem_route_classifications

902: --Changes for R12
903: --
904: (
905: select name, max(route_classification_id) route_classification_id
906: from iem_route_classifications
907: group by name
908: ) iem_r_c
909: WHERE A.MEDIA_ID = X.MEDIA_ID
910: AND X.MEDIA_ID = Y.MEDIA_ID