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.OE_ELECMSGS_PVT dependencies on OE_EM_INFORMATION

Line 36: from oe_em_information x

32: min(x.creation_date),
33: max(x.last_update_date),
34: 'x',
35: x.org_id
36: from oe_em_information x
37: where x.order_source_id = p_order_source_id
38: and (x.orig_sys_document_ref = p_orig_sys_document_ref or p_orig_sys_document_ref IS NULL)
39: and x.sold_to_org_id = p_sold_to_org_id
40: and (x.em_transaction_type_code = p_transaction_type or p_transaction_type IS NULL)

Line 57: from oe_em_information x

53: min(x.creation_date),
54: max(x.last_update_date),
55: 'x',
56: x.org_id
57: from oe_em_information x
58: where x.order_source_id = p_order_source_id
59: and (x.orig_sys_document_ref = p_orig_sys_document_ref or p_orig_sys_document_ref IS NULL)
60: and (x.sold_to_org_id = p_sold_to_org_id or p_sold_to_org_id IS NULL)
61: and (x.em_transaction_type_code = p_transaction_type or p_transaction_type IS NULL)

Line 78: from oe_em_information x

74: min(x.creation_date),
75: max(x.last_update_date),
76: 'x',
77: x.org_id
78: from oe_em_information x
79: where x.order_source_id between l_min_order_source_id and l_max_order_source_id
80: and (x.orig_sys_document_ref = p_orig_sys_document_ref or p_orig_sys_document_ref IS NULL)
81: and x.sold_to_org_id = p_sold_to_org_id
82: and (x.em_transaction_type_code = p_transaction_type or p_transaction_type IS NULL)

Line 99: from oe_em_information x

95: min(x.creation_date),
96: max(x.last_update_date),
97: 'x',
98: x.org_id
99: from oe_em_information x
100: where x.order_source_id between l_min_order_source_id and l_max_order_source_id
101: and (x.orig_sys_document_ref = p_orig_sys_document_ref or p_orig_sys_document_ref IS NULL)
102: and (x.sold_to_org_id = p_sold_to_org_id or p_sold_to_org_id IS NULL)
103: and (x.em_transaction_type_code = p_transaction_type or p_transaction_type IS NULL)

Line 120: from oe_em_information x

116: min(x.creation_date),
117: max(x.last_update_date),
118: 'x',
119: x.org_id
120: from oe_em_information x
121: where x.order_source_id = p_order_source_id
122: and (x.orig_sys_document_ref = p_orig_sys_document_ref or p_orig_sys_document_ref IS NULL)
123: and x.sold_to_org_id = p_sold_to_org_id
124: and (x.em_transaction_type_code = p_transaction_type or p_transaction_type IS NULL)

Line 147: from oe_em_information x

143: min(x.creation_date),
144: max(x.last_update_date),
145: 'x',
146: x.org_id
147: from oe_em_information x
148: where x.order_source_id = p_order_source_id
149: and (x.orig_sys_document_ref = p_orig_sys_document_ref or p_orig_sys_document_ref IS NULL)
150: and (x.sold_to_org_id = p_sold_to_org_id or p_sold_to_org_id IS NULL)
151: and (x.em_transaction_type_code = p_transaction_type or p_transaction_type IS NULL)

Line 173: from oe_em_information x

169: min(x.creation_date),
170: max(x.last_update_date),
171: 'x',
172: x.org_id
173: from oe_em_information x
174: where x.order_source_id between l_min_order_source_id and l_max_order_source_id
175: and (x.orig_sys_document_ref = p_orig_sys_document_ref or p_orig_sys_document_ref IS NULL)
176: and x.sold_to_org_id = p_sold_to_org_id
177: and (x.em_transaction_type_code = p_transaction_type or p_transaction_type IS NULL)

Line 199: from oe_em_information x

195: min(x.creation_date),
196: max(x.last_update_date),
197: 'x',
198: x.org_id
199: from oe_em_information x
200: where x.order_source_id between l_min_order_source_id and l_max_order_source_id
201: and (x.orig_sys_document_ref = p_orig_sys_document_ref or p_orig_sys_document_ref IS NULL)
202: and (x.sold_to_org_id = p_sold_to_org_id or p_sold_to_org_id IS NULL)
203: and (x.em_transaction_type_code = p_transaction_type or p_transaction_type IS NULL)

Line 221: FROM oe_em_information

217:
218: l_results_rec Elec_Msgs_Summary_Type;
219: cursor results_Cursor2 is
220: SELECT em_transaction_type_code, message_text, document_status
221: FROM oe_em_information
222: WHERE order_source_id = p_elec_msgs_tbl(j).order_source_id
223: AND orig_sys_document_ref = p_elec_msgs_tbl(j).orig_sys_document_ref
224: AND sold_to_org_id = p_elec_msgs_tbl(j).sold_to_org_id
225: AND org_id = p_elec_msgs_tbl(j).org_id

Line 430: FROM oe_em_information

426: LOOP
427: EXIT WHEN n = idx;
428: SELECT decode(nvl(max(order_number), 0), 0, NULL, max(order_number)),max (order_type_id), count(*), min(creation_Date), max(last_update_Date)
429: INTO p_elec_msgs_tbl(n).order_number,p_elec_msgs_tbl(n).order_type_id, p_elec_msgs_tbl(n).num_msgs, p_elec_msgs_tbl(n).creation_date, p_elec_msgs_tbl(n).last_update_date
430: FROM oe_em_information
431: WHERE order_source_id = p_elec_msgs_tbl(n).order_source_id
432: AND orig_sys_document_ref = p_elec_msgs_tbl(n).orig_sys_document_ref
433: AND sold_to_org_id = p_elec_msgs_tbl(n).sold_to_org_id
434: AND org_id = p_elec_msgs_tbl(n).org_id;

Line 500: INSERT INTO Oe_Em_Information (

496: END IF;
497: --oe_debug_pub.add('before insert');
498:
499: /* Insertion -- what should the behaviour be if org_id is null */
500: INSERT INTO Oe_Em_Information (
501: order_source_id,
502: orig_sys_document_ref,
503: sold_to_org_id,
504: em_transaction_type_code,

Line 601: UPDATE Oe_Em_Information Set

597: return;
598: END IF;
599:
600: /* Insertion -- what should the behaviour be if org_id is null */
601: UPDATE Oe_Em_Information Set
602: item_type = nvl(p_itemtype, item_type),
603: item_key = nvl(p_itemkey, item_key),
604: change_sequence = nvl(p_change_sequence, change_sequence),
605: order_number = nvl(p_order_number, order_number),

Line 658: FROM oe_em_information

654: BEGIN
655:
656: SELECT order_source_id, last_update_itemkey, em_conc_request_id
657: INTO l_dummy, l_last_itemkey, l_last_request_id
658: FROM oe_em_information
659: WHERE order_source_id = p_order_source_id
660: AND orig_sys_document_ref = p_orig_sys_document_ref
661: AND sold_to_org_id = p_sold_to_org_id
662: AND em_transaction_type_code = p_transaction_type

Line 695: FROM oe_em_information

691: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
692: BEGIN
693: /* SELECT document_id
694: INTO l_document_id
695: FROM oe_em_information
696: WHERE order_source_id = p_order_source_id
697: AND orig_sys_document_ref = p_orig_sys_document_ref
698: AND sold_to_org_id = p_sold_to_org_id
699: AND em_transaction_type_code = 'CSO'

Line 705: FROM oe_em_information

701: ORDER BY 1 DESC;
702: */
703: SELECT max(document_id)
704: INTO l_document_id
705: FROM oe_em_information
706: WHERE order_source_id = p_order_source_id
707: AND orig_sys_document_ref = p_orig_sys_document_ref
708: AND sold_to_org_id = p_sold_to_org_id
709: AND em_transaction_type_code = 'CSO'

Line 1301: IF p_view_name IN ('OE_EM_INFORMATION') THEN

1297: END IF;
1298: IF p_view_name IN ('OE_LINE_ACKS') THEN
1299: l_line_acks := TRUE;
1300: END IF;
1301: IF p_view_name IN ('OE_EM_INFORMATION') THEN
1302: l_elecmsgs := TRUE;
1303: END IF;
1304:
1305: /* to use the index on tracking and interface tables we gather the max and min order source id

Line 1308: IF p_view_name IN ('OE_HEADERS_INTERFACE', 'OE_LINES_INTERFACE','OE_EM_INFORMATION') THEN

1304:
1305: /* to use the index on tracking and interface tables we gather the max and min order source id
1306: in appropriate cases */
1307: IF p_order_source_id IS NULL THEN
1308: IF p_view_name IN ('OE_HEADERS_INTERFACE', 'OE_LINES_INTERFACE','OE_EM_INFORMATION') THEN
1309:
1310: SELECT max(order_source_id), min(order_source_id)
1311: INTO l_max_order_source_id, l_min_order_source_id
1312: FROM OE_Order_Sources;

Line 3017: oe_debug_pub.add('Deleting records from OE_EM_INFORMATION');

3013: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Line Acknowledgments: '|| l_count);
3014: END IF;
3015: IF l_elecmsgs THEN
3016: IF l_debug_level > 0 THEN
3017: oe_debug_pub.add('Deleting records from OE_EM_INFORMATION');
3018: END IF;
3019: l_count := 0;
3020:
3021: IF p_order_source_id IS NOT NULL AND l_sold_to_org_id IS NOT NULL THEN

Line 3023: FROM OE_EM_Information

3019: l_count := 0;
3020:
3021: IF p_order_source_id IS NOT NULL AND l_sold_to_org_id IS NOT NULL THEN
3022: DELETE
3023: FROM OE_EM_Information
3024: WHERE order_source_id = p_order_source_id
3025: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
3026: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
3027: AND sold_to_org_id = l_sold_to_org_id;

Line 3030: FROM OE_EM_Information

3026: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
3027: AND sold_to_org_id = l_sold_to_org_id;
3028: ELSIF p_order_source_id IS NOT NULL THEN
3029: DELETE
3030: FROM OE_EM_Information
3031: WHERE order_source_id = p_order_source_id
3032: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
3033: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
3034: AND sold_to_org_id = nvl(l_sold_to_org_id,sold_to_org_id);

Line 3037: FROM OE_EM_Information

3033: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
3034: AND sold_to_org_id = nvl(l_sold_to_org_id,sold_to_org_id);
3035: ELSIF l_sold_to_org_id IS NOT NULL THEN
3036: DELETE
3037: FROM OE_EM_Information
3038: WHERE order_source_id BETWEEN l_min_order_source_id AND l_max_order_source_id
3039: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
3040: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
3041: AND sold_to_org_id = l_sold_to_org_id;

Line 3044: FROM OE_EM_Information

3040: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
3041: AND sold_to_org_id = l_sold_to_org_id;
3042: ELSE
3043: DELETE
3044: FROM OE_EM_Information
3045: WHERE order_source_id BETWEEN l_min_order_source_id AND l_max_order_source_id
3046: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
3047: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
3048: AND sold_to_org_id = nvl(l_sold_to_org_id,sold_to_org_id);