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_EMAILS_LOAD_PKG dependencies on JTF_IH_MEDIA_ITM_LC_SEG_TYS

Line 196: jtf_ih_media_itm_lc_seg_tys mtys

192: 1 depth
193: FROM jtf_ih_activities actv,
194: /* jtf_ih_media_items imtm,*/
195: jtf_ih_media_item_lc_segs mseg,
196: jtf_ih_media_itm_lc_seg_tys mtys
197: WHERE actv.media_id = mseg.media_id
198: AND mtys.milcs_type_id = mseg.milcs_type_id
199: AND mtys.milcs_code IN ('EMAIL_AUTO_REPLY','EMAIL_REPLY')
200: GROUP BY actv.interaction_id

Line 220: jtf_ih_media_itm_lc_seg_tys mtys,

216: /* Added */
217: --,
218: --first_value(milcs_code) over (partition by mseg.media_id order by mseg.start_Date_time desc) milcs_code
219: FROM
220: jtf_ih_media_itm_lc_seg_tys mtys,
221: jtf_ih_media_item_lc_segs mseg,
222: jtf_ih_media_items mitm,
223: jtf_ih_activities actv ,
224: (

Line 718: jtf_ih_media_itm_lc_seg_tys mtyp1,

714: mseg1.media_id media_id,
715: MAX(mseg2.start_date_time) start_date_time
716: FROM
717: jtf_ih_media_item_lc_segs mseg1,
718: jtf_ih_media_itm_lc_seg_tys mtyp1,
719: jtf_ih_media_item_lc_segs mseg2,
720: jtf_ih_media_itm_lc_seg_tys mtyp2
721: WHERE mseg1.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
722: AND mseg1.milcs_type_id = mtyp1.milcs_type_id

Line 720: jtf_ih_media_itm_lc_seg_tys mtyp2

716: FROM
717: jtf_ih_media_item_lc_segs mseg1,
718: jtf_ih_media_itm_lc_seg_tys mtyp1,
719: jtf_ih_media_item_lc_segs mseg2,
720: jtf_ih_media_itm_lc_seg_tys mtyp2
721: WHERE mseg1.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
722: AND mseg1.milcs_type_id = mtyp1.milcs_type_id
723: AND mtyp1.milcs_code = 'EMAIL_REPLY'
724: AND mseg1.media_id = mseg2.media_id

Line 740: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyp,

736: WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
737: AND actv.interaction_id = intr.interaction_id
738: GROUP BY actv.media_id
739: ) inv1,
740: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyp,
741: --
742: --Changes for R12
743: --
744: (

Line 976: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyp,

972: GROUP BY actv.media_id
973: ) inv2,
974: JTF_IH_MEDIA_ITEMS mitm,
975: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,
976: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyp,
977: --
978: --Changes for R12
979: --
980: (

Line 998: jtf_ih_media_itm_lc_seg_tys mtys1

994: SELECT /*+ use_hash(mseg1) use_hash(mtys1) PARALLEL(mseg1) PARALLEL(mtys1) */
995: 1
996: FROM
997: jtf_ih_media_item_lc_segs mseg1,
998: jtf_ih_media_itm_lc_seg_tys mtys1
999: WHERE mseg1.media_id = mitm.media_id
1000: AND mtys1.milcs_type_id = mseg1.milcs_type_id
1001: AND mtys1.milcs_code IN ( 'EMAIL_TRANSFERRED','EMAIL_ESCALATED') )
1002: GROUP BY

Line 1126: JTF_IH_MEDIA_ITM_LC_SEG_TYS seg_type,

1122: 0 LEADS_CREATED_IN_PERIOD
1123: FROM
1124: JTF_IH_MEDIA_ITEMS mitm,
1125: JTF_IH_MEDIA_ITEM_LC_SEGS segs,
1126: JTF_IH_MEDIA_ITM_LC_SEG_TYS seg_type,
1127: JTF_IH_ACTIVITIES actv,
1128: JTF_IH_INTERACTIONS intr,
1129: --
1130: --Changes for R12

Line 1573: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys,

1569: PERIOD_END_DATE_TIME
1570: FROM
1571: JTF_IH_MEDIA_ITEMS mitm,
1572: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,
1573: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys,
1574: --
1575: --Changes for R12
1576: --
1577: (

Line 1616: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys1

1612: (
1613: SELECT /*+ use_hash(mseg1) use_hash(mtys1) */
1614: 1
1615: FROM JTF_IH_MEDIA_ITEM_LC_SEGS mseg1,
1616: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys1
1617: WHERE mseg.MEDIA_ID = mseg1.MEDIA_ID
1618: AND mseg1.MILCS_TYPE_ID = mtys1.MILCS_TYPE_ID
1619: AND mtys1.MILCS_CODE IN
1620: ('EMAIL_FETCH', 'EMAIL_RESOLVED', 'EMAIL_AUTO_REDIRECTED', 'EMAIL_AUTO_DELETED',

Line 1661: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys3

1657: mseg3.media_id,
1658: mseg3.resource_id,
1659: mseg3.start_date_time
1660: FROM JTF_IH_MEDIA_ITEM_LC_SEGS mseg3,
1661: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys3
1662: WHERE mseg3.MILCS_TYPE_ID = mtys3.MILCS_TYPE_ID
1663: AND mtys3.MILCS_CODE IN
1664: ('EMAIL_FETCH', 'EMAIL_RESOLVED', 'EMAIL_AUTO_REDIRECTED', 'EMAIL_AUTO_DELETED',
1665: 'EMAIL_AUTO_REPLY', 'EMAIL_OPEN', 'EMAIL_AUTO_ROUTED', 'EMAIL_AUTO_UPDATED_SR',

Line 1691: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys2,

1687: WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
1688: AND actv.interaction_id = intr.interaction_id
1689: ) inv1,
1690: JTF_IH_MEDIA_ITEM_LC_SEGS mseg2,
1691: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys2,
1692: --
1693: --Changes for R12
1694: --
1695: (

Line 2177: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys,

2173: PERIOD_END_DATE_TIME
2174: FROM
2175: JTF_IH_MEDIA_ITEMS mitm,
2176: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,
2177: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys,
2178: --
2179: --Changes for R12
2180: --
2181: (

Line 2220: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys1

2216: (
2217: SELECT /*+ use_hash(mseg1) use_hash(mtys1) */
2218: 1
2219: FROM JTF_IH_MEDIA_ITEM_LC_SEGS mseg1,
2220: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys1
2221: WHERE mseg.media_id = mseg1.media_id
2222: -- AND mseg.resource_id = mseg1.resource_id
2223: /* Commenting this join out because the supervisor can perform some of the operations below.
2224: Irrespective of which user did it, the email is not open any more */

Line 2259: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys1

2255: mseg1.media_id MEDIA_ID,
2256: mseg1.resource_id RESOURCE_ID,
2257: mseg1.start_date_time START_DATE_TIME
2258: FROM JTF_IH_MEDIA_ITEM_LC_SEGS mseg1,
2259: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys1
2260: WHERE mseg1.MILCS_TYPE_ID = mtys1.MILCS_TYPE_ID
2261: AND mtys1.MILCS_CODE IN ('EMAIL_REPLY','EMAIL_DELETED','EMAIL_TRANSFERRED', 'EMAIL_ESCALATED',
2262: 'EMAIL_ASSIGNED','EMAIL_REQUEUED', 'EMAIL_REROUTED_DIFF_ACCT', 'EMAIL_REROUTED_DIFF_CLASS')
2263: AND mseg1.START_DATE_TIME BETWEEN g_collect_start_date AND g_collect_end_date

Line 2287: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys,

2283: WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
2284: AND actv.interaction_id = intr.interaction_id
2285: ) inv1,
2286: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,
2287: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtys,
2288: --
2289: --Changes for R12
2290: --
2291: (