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_ITEM_LC_SEGS

Line 23: TYPE g_start_date_time_tab IS TABLE OF jtf_ih_media_item_lc_segs.start_date_time%TYPE;

19: TYPE g_email_account_id_tab IS TABLE OF jtf_ih_media_items.source_id%TYPE;
20: TYPE g_email_classification_id_tab IS TABLE OF iem_route_classifications.route_classification_id%TYPE;
21: TYPE g_resource_id_tab IS TABLE OF bix_email_details_f.agent_id%TYPE;
22: TYPE g_party_id_tab IS TABLE OF bix_email_details_f.party_id%TYPE;
23: TYPE g_start_date_time_tab IS TABLE OF jtf_ih_media_item_lc_segs.start_date_time%TYPE;
24: TYPE g_end_date_time_tab IS TABLE OF jtf_ih_media_item_lc_segs.end_date_time%TYPE;
25: TYPE g_media_start_date_time_tab IS TABLE OF jtf_ih_media_items.start_date_time%TYPE;
26: TYPE g_period_start_date_tab IS TABLE OF bix_email_details_f.period_start_date%TYPE;
27:

Line 24: TYPE g_end_date_time_tab IS TABLE OF jtf_ih_media_item_lc_segs.end_date_time%TYPE;

20: TYPE g_email_classification_id_tab IS TABLE OF iem_route_classifications.route_classification_id%TYPE;
21: TYPE g_resource_id_tab IS TABLE OF bix_email_details_f.agent_id%TYPE;
22: TYPE g_party_id_tab IS TABLE OF bix_email_details_f.party_id%TYPE;
23: TYPE g_start_date_time_tab IS TABLE OF jtf_ih_media_item_lc_segs.start_date_time%TYPE;
24: TYPE g_end_date_time_tab IS TABLE OF jtf_ih_media_item_lc_segs.end_date_time%TYPE;
25: TYPE g_media_start_date_time_tab IS TABLE OF jtf_ih_media_items.start_date_time%TYPE;
26: TYPE g_period_start_date_tab IS TABLE OF bix_email_details_f.period_start_date%TYPE;
27:
28: TYPE g_emails_open_tab IS TABLE OF bix_email_details_f.accumulated_open_emails%TYPE;

Line 195: jtf_ih_media_item_lc_segs mseg,

191: actv.interaction_id interaction_id,
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')

Line 221: jtf_ih_media_item_lc_segs mseg,

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: (
225: SELECT to_number(decode(instr(sys_connect_by_path(intr3.interact_interaction_idrelates, ':'), ':', 2), 0,

Line 710: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,

706: 'EMAIL_REQUEUED',1 )) EMAILS_REROUTED_IN_PERIOD,
707: 0 LEADS_CREATED_IN_PERIOD
708: FROM
709: JTF_IH_MEDIA_ITEMS mitm,
710: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,
711: (
712: SELECT /*+ use_hash(mseg1) use_hash(mtyp1) use_hash(mseg2) use_hash(mtyp2)
713: PARALLEL(mseg1) PARALLEL(mtyp1) PARALLEL(mseg2) PARALLEL(mtyp2) */
714: mseg1.media_id media_id,

Line 717: jtf_ih_media_item_lc_segs mseg1,

713: PARALLEL(mseg1) PARALLEL(mtyp1) PARALLEL(mseg2) PARALLEL(mtyp2) */
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

Line 719: jtf_ih_media_item_lc_segs mseg2,

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
723: AND mtyp1.milcs_code = 'EMAIL_REPLY'

Line 975: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,

971: AND actv.interaction_id = intr.interaction_id
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: --

Line 997: jtf_ih_media_item_lc_segs mseg1,

993: AND EXISTS (
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') )

Line 1125: JTF_IH_MEDIA_ITEM_LC_SEGS segs,

1121: 0 EMAILS_REROUTED_IN_PERIOD,
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: --

Line 1572: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,

1568: g_collect_end_date -- - (( 29 * 60 + 59 )/(24*60*60))
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: --

Line 1615: FROM JTF_IH_MEDIA_ITEM_LC_SEGS mseg1,

1611: AND NOT EXISTS
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

Line 1660: FROM JTF_IH_MEDIA_ITEM_LC_SEGS mseg3,

1656: SELECT /*+ use_hash(mseg3) use_hash(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',

Line 1690: JTF_IH_MEDIA_ITEM_LC_SEGS mseg2,

1686: jtf_ih_interactions intr
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: --

Line 2176: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,

2172: g_collect_end_date
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: --

Line 2219: FROM JTF_IH_MEDIA_ITEM_LC_SEGS mseg1,

2215: AND NOT EXISTS
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.

Line 2258: FROM JTF_IH_MEDIA_ITEM_LC_SEGS mseg1,

2254: SELECT /*+ use_hash(mseg1) use_hash(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')

Line 2286: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,

2282: jtf_ih_interactions intr
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: --