APPS.BIX_EMAILS_LOAD_PKG dependencies on IEM_ROUTE_CLASSIFICATIONS

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

16: G_TIME_DIM_MISSING EXCEPTION;
17:
18: TYPE g_media_id_tab IS TABLE OF jtf_ih_media_items.media_id%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;

Line 180: from iem_route_classifications im

176: --Changes for R12
177: --
178: (
179: select /*+ full(im) +*/ name, max(route_classification_id) route_classification_id
180: from iem_route_classifications im
181: group by name
182: ) irc,
183: (
184: select

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

279: TYPE agent_id_tab IS TABLE OF jtf_ih_interactions.resource_id%TYPE;
280: TYPE party_id_tab IS TABLE OF jtf_ih_interactions.party_id%TYPE;
281: TYPE start_date_time_tab IS TABLE OF jtf_ih_interactions.start_date_time%TYPE;
282: TYPE source_id_tab IS TABLE OF jtf_ih_media_items.source_id%TYPE;
283: TYPE route_classification_id_tab IS TABLE OF iem_route_classifications.route_classification_id%TYPE;
284: TYPE one_done_rsln_tab IS TABLE OF bix_email_details_f.one_rsln_in_period%TYPE;
285: TYPE two_done_rsln_tab IS TABLE OF bix_email_details_f.two_rsln_in_period%TYPE;
286: TYPE three_done_rsln_tab IS TABLE OF bix_email_details_f.three_rsln_in_period%TYPE;
287: TYPE four_done_rsln_tab IS TABLE OF bix_email_details_f.four_rsln_in_period%TYPE;

Line 746: from iem_route_classifications

742: --Changes for R12
743: --
744: (
745: select name, max(route_classification_id) route_classification_id
746: from iem_route_classifications
747: group by name
748: ) irc
749: WHERE mitm.media_item_type = 'EMAIL'
750: AND mitm.direction = 'INBOUND'

Line 823: from iem_route_classifications

819: --Changes for R12
820: --
821: (
822: select name, max(route_classification_id) route_classification_id
823: from iem_route_classifications
824: group by name
825: ) irc
826: WHERE mitm.MEDIA_ITEM_TYPE = 'EMAIL'
827: AND mitm.DIRECTION = 'INBOUND'

Line 901: from iem_route_classifications

897: --Changes for R12
898: --
899: (
900: select name, max(route_classification_id) route_classification_id
901: from iem_route_classifications
902: group by name
903: ) irc
904: WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
905: AND ( ( actv.action_id = 13 AND actv.action_item_id = 17 ) OR

Line 982: from iem_route_classifications

978: --Changes for R12
979: --
980: (
981: select name, max(route_classification_id) route_classification_id
982: from iem_route_classifications
983: group by name
984: ) irc
985: WHERE mitm.MEDIA_ITEM_TYPE = 'EMAIL'
986: AND mitm.DIRECTION = 'INBOUND'

Line 1061: from iem_route_classifications

1057: --Changes for R12
1058: --
1059: (
1060: select name, max(route_classification_id) route_classification_id
1061: from iem_route_classifications
1062: group by name
1063: ) irc
1064: WHERE mitm.MEDIA_ITEM_TYPE = 'EMAIL'
1065: AND mitm.direction = 'INBOUND'

Line 1134: from iem_route_classifications

1130: --Changes for R12
1131: --
1132: (
1133: select name, max(route_classification_id) route_classification_id
1134: from iem_route_classifications
1135: group by name
1136: ) irc
1137: WHERE mitm.MEDIA_ITEM_TYPE = 'EMAIL'
1138: AND mitm.direction = 'OUTBOUND'

Line 1579: from iem_route_classifications

1575: --Changes for R12
1576: --
1577: (
1578: select name, max(route_classification_id) route_classification_id
1579: from iem_route_classifications
1580: group by name
1581: ) cls,
1582: (
1583: --????Changed for party_id

Line 1697: from iem_route_classifications

1693: --Changes for R12
1694: --
1695: (
1696: select name, max(route_classification_id) route_classification_id
1697: from iem_route_classifications
1698: group by name
1699: ) cls2
1700: WHERE mitm2.MEDIA_ITEM_TYPE = 'EMAIL'
1701: AND mitm2.DIRECTION = 'INBOUND'

Line 2183: from iem_route_classifications

2179: --Changes for R12
2180: --
2181: (
2182: select name, max(route_classification_id) route_classification_id
2183: from iem_route_classifications
2184: group by name
2185: ) cls,
2186: (
2187: --???Changed for party

Line 2293: from iem_route_classifications

2289: --Changes for R12
2290: --
2291: (
2292: select name, max(route_classification_id) route_classification_id
2293: from iem_route_classifications
2294: group by name
2295: ) cls
2296: WHERE mitm.media_id = inv2.media_id
2297: AND inv2.media_id = mseg.media_id