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_SUMMARY_PKG dependencies on IEM_ROUTE_CLASSIFICATIONS

Line 28: TYPE g_email_classification_id_tab IS TABLE OF iem_route_classifications.route_classification_id%TYPE;

24: g_worker WorkerList;
25:
26: TYPE g_media_id_tab IS TABLE OF jtf_ih_media_items.media_id%TYPE;
27: TYPE g_email_account_id_tab IS TABLE OF jtf_ih_media_items.source_id%TYPE;
28: TYPE g_email_classification_id_tab IS TABLE OF iem_route_classifications.route_classification_id%TYPE;
29: TYPE g_resource_id_tab IS TABLE OF bix_email_details_f.agent_id%TYPE;
30: TYPE g_start_date_time_tab IS TABLE OF jtf_ih_media_item_lc_segs.start_date_time%TYPE;
31: TYPE g_end_date_time_tab IS TABLE OF jtf_ih_media_item_lc_segs.end_date_time%TYPE;
32: TYPE g_media_start_date_time_tab IS TABLE OF jtf_ih_media_items.start_date_time%TYPE;

Line 516: TYPE route_classification_id_tab IS TABLE OF iem_route_classifications.route_classification_id%TYPE;

512: TYPE agent_id_tab IS TABLE OF jtf_ih_interactions.resource_id%TYPE;
513: TYPE party_id_tab IS TABLE OF jtf_ih_interactions.party_id%TYPE;
514: TYPE start_date_time_tab IS TABLE OF jtf_ih_interactions.start_date_time%TYPE;
515: TYPE source_id_tab IS TABLE OF jtf_ih_media_items.source_id%TYPE;
516: TYPE route_classification_id_tab IS TABLE OF iem_route_classifications.route_classification_id%TYPE;
517: TYPE one_done_rsln_tab IS TABLE OF bix_email_details_f.one_rsln_in_period%TYPE;
518: TYPE two_done_rsln_tab IS TABLE OF bix_email_details_f.two_rsln_in_period%TYPE;
519: TYPE three_done_rsln_tab IS TABLE OF bix_email_details_f.three_rsln_in_period%TYPE;
520: TYPE four_done_rsln_tab IS TABLE OF bix_email_details_f.four_rsln_in_period%TYPE;

Line 640: from iem_route_classifications

636: --Changes for R12
637: --
638: (
639: select name, max(route_classification_id) route_classification_id
640: from iem_route_classifications
641: group by name
642: ) irc
643: WHERE intr.interaction_id = l_root_interaction_id(i)
644: AND actv.interaction_id = intr.interaction_id

Line 1259: from iem_route_classifications

1255: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,
1256: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyp,
1257: (
1258: select name, max(route_classification_id) route_classification_id
1259: from iem_route_classifications
1260: group by name
1261: ) irc
1262: WHERE mitm.MEDIA_ITEM_TYPE = 'EMAIL'
1263: AND mitm.classification = irc.name(+)

Line 1593: from iem_route_classifications

1589: FROM
1590: JTF_IH_MEDIA_ITEMS mitm,
1591: (
1592: select name, max(route_classification_id) route_classification_id
1593: from iem_route_classifications
1594: group by name
1595: ) irc
1596: WHERE mitm.MEDIA_ITEM_TYPE = 'EMAIL'
1597: AND mitm.DIRECTION = 'INBOUND'

Line 1962: from iem_route_classifications

1958: --Changes for R12
1959: --
1960: (
1961: select name, max(route_classification_id) route_classification_id
1962: from iem_route_classifications
1963: group by name
1964: ) irc
1965: WHERE
1966: actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date

Line 2329: from iem_route_classifications

2325: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,
2326: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyp,
2327: (
2328: select name, max(route_classification_id) route_classification_id
2329: from iem_route_classifications
2330: group by name
2331: ) irc
2332: WHERE mitm.MEDIA_ITEM_TYPE = 'EMAIL'
2333: AND mitm.DIRECTION = 'INBOUND'

Line 2706: from iem_route_classifications

2702: JTF_IH_ACTIVITIES actv,
2703: JTF_IH_INTERACTIONS intr,
2704: (
2705: select name, max(route_classification_id) route_classification_id
2706: from iem_route_classifications
2707: group by name
2708: ) irc
2709: WHERE mitm.MEDIA_ITEM_TYPE = 'EMAIL'
2710: AND mitm.direction = 'INBOUND'

Line 3063: from iem_route_classifications

3059: --Changes for R12
3060: --
3061: (
3062: select name, max(route_classification_id) route_classification_id
3063: from iem_route_classifications
3064: group by name
3065: ) irc
3066: WHERE mitm.MEDIA_ITEM_TYPE = 'EMAIL'
3067: AND mitm.direction = 'OUTBOUND'

Line 3460: from iem_route_classifications

3456: JTF_IH_ACTIVITIES act,
3457: JTF_IH_INTERACTIONS int,
3458: (
3459: select name, max(route_classification_id) route_classification_id
3460: from iem_route_classifications
3461: group by name
3462: ) cls
3463: WHERE 1=1
3464: --mitm.media_item_type = 'EMAIL'

Line 3527: from iem_route_classifications

3523: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,
3524: JTF_IH_MEDIA_ITEMS mitm,
3525: (
3526: select name, max(route_classification_id) route_classification_id
3527: from iem_route_classifications
3528: group by name
3529: ) cls ,
3530: (
3531: SELECT /*+ INDEX(MSEG1 JTF_IH_MEDIA_ITEM_LC_SEGS_N3) */

Line 3947: from iem_route_classifications

3943: JTF_IH_ACTIVITIES act,
3944: JTF_IH_INTERACTIONS int,
3945: (
3946: select name, max(route_classification_id) route_classification_id
3947: from iem_route_classifications
3948: group by name
3949: ) cls
3950: WHERE
3951: --mitm.MEDIA_ITEM_TYPE = 'EMAIL' /* Is this necessary? Without it the unique filter is getting used*/

Line 3990: from iem_route_classifications

3986: JTF_IH_MEDIA_ITEM_LC_SEGS mseg2,
3987: JTF_IH_MEDIA_ITEMS mitm2,
3988: (
3989: select name, max(route_classification_id) route_classification_id
3990: from iem_route_classifications
3991: group by name
3992: ) cls2,
3993: (
3994: SELECT /*+ index(mseg3 JTF_IH_MEDIA_ITEM_LC_SEGS_N3) */