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_BULK_ORDER_IMPORT_PVT dependencies on OE_HEADERS_IFACE_ALL

Line 207: from oe_headers_iface_all

203:
204: delete from oe_actions_interface
205: where (order_source_id, orig_sys_document_ref) IN
206: (select order_source_id, orig_sys_document_ref
207: from oe_headers_iface_all
208: where batch_id = p_batch_id
209: and nvl(error_flag,'N') = 'N');
210:
211: --ER 9060917

Line 218: FROM oe_headers_iface_all a

214: DELETE FROM oe_price_adjs_interface
215: WHERE(order_source_id, orig_sys_document_ref) IN
216: (SELECT order_source_id,
217: orig_sys_document_ref
218: FROM oe_headers_iface_all a
219: WHERE batch_id = p_batch_id
220: AND nvl(error_flag,'N') = 'N'
221: AND EXISTS
222: (SELECT 1

Line 239: FROM oe_headers_iface_all b

235: WHERE nvl(a.error_flag, 'N') = 'N'
236: AND(a.order_source_id, a.orig_sys_document_ref) IN
237: (SELECT order_source_id,
238: orig_sys_document_ref
239: FROM oe_headers_iface_all b
240: WHERE nvl(a.error_flag, 'N') = 'N'
241: AND batch_id = p_batch_id));
242:
243:

Line 244: UPDATE oe_headers_iface_all a

240: WHERE nvl(a.error_flag, 'N') = 'N'
241: AND batch_id = p_batch_id));
242:
243:
244: UPDATE oe_headers_iface_all a
245: SET operation_code = 'UPDATE'
246: WHERE a.batch_id = p_batch_id
247: AND nvl(error_flag,'N') = 'N'
248: AND(order_source_id, orig_sys_document_ref) IN

Line 266: FROM oe_headers_iface_all

262:
263: DELETE FROM oe_lines_iface_all
264: WHERE(order_source_id, orig_sys_document_ref) IN
265: (SELECT order_source_id,orig_sys_document_ref
266: FROM oe_headers_iface_all
267: WHERE batch_id = p_batch_id
268: AND nvl(error_flag, 'N') = 'N')
269: AND nvl(error_flag, 'N') = 'N';
270:

Line 271: DELETE FROM oe_headers_iface_all a

267: WHERE batch_id = p_batch_id
268: AND nvl(error_flag, 'N') = 'N')
269: AND nvl(error_flag, 'N') = 'N';
270:
271: DELETE FROM oe_headers_iface_all a
272: WHERE batch_id = p_batch_id
273: AND nvl(error_flag, 'N') = 'N'
274: AND NOT EXISTS
275: (SELECT 1

Line 287: from oe_headers_iface_all

283: else
284: delete from oe_price_adjs_interface
285: where (order_source_id, orig_sys_document_ref) IN
286: (select order_source_id, orig_sys_document_ref
287: from oe_headers_iface_all
288: where batch_id = p_batch_id
289: and nvl(error_flag,'N') = 'N');
290:
291: delete from oe_lines_interface

Line 294: from oe_headers_iface_all

290:
291: delete from oe_lines_interface
292: where (order_source_id, orig_sys_document_ref) IN
293: (select order_source_id, orig_sys_document_ref
294: from oe_headers_iface_all
295: where batch_id = p_batch_id
296: and nvl(error_flag,'N') = 'N');
297:
298: delete from oe_headers_iface_all

Line 298: delete from oe_headers_iface_all

294: from oe_headers_iface_all
295: where batch_id = p_batch_id
296: and nvl(error_flag,'N') = 'N');
297:
298: delete from oe_headers_iface_all
299: where batch_id = p_batch_id
300: and nvl(error_flag,'N') = 'N';
301: end if;
302:

Line 385: FROM oe_headers_iface_all

381: -- Batches cursor
382: -----------------------------------------------------------
383: CURSOR l_batch_cursor IS
384: SELECT DISTINCT batch_id,org_id
385: FROM oe_headers_iface_all
386: WHERE request_id = l_request_id;
387:
388: --ER 9060917
389: ------------------------------------------------------------

Line 395: FROM oe_headers_iface_all a

391: ------------------------------------------------------------
392:
393: CURSOR l_partial_orders IS
394: SELECT orig_sys_document_ref
395: FROM oe_headers_iface_all a
396: WHERE request_id = l_request_id
397: AND nvl(error_flag, 'N') = 'N'
398: AND EXISTS
399: (SELECT orig_sys_line_ref

Line 575: FROM oe_headers_iface_all h, oe_lines_iface_all l, --bug 4685432

571: , count(*) num_lines
572: , NULL request_id
573: , NULL batch_id
574: , l_default_org_id org_id
575: FROM oe_headers_iface_all h, oe_lines_iface_all l, --bug 4685432
576: oe_sys_parameters_all sys
577: WHERE h.order_source_id = nvl(p_order_source_id,h.order_source_id)
578: AND h.orig_sys_document_ref = nvl(p_orig_sys_document_ref,h.orig_sys_document_ref)
579: AND nvl(sys.org_id,l_default_org_id) = l_default_org_id --bug 4685432, 5209313

Line 646: FROM oe_headers_iface_all

642: -- Headers Cursor
643: -----------------------------------------------------------
644: CURSOR c_headers(p_request_id NUMBER) IS
645: SELECT order_source_id, orig_sys_document_ref,org_id,request_id
646: FROM oe_headers_iface_all
647: WHERE request_id = p_request_id
648: ORDER BY order_source_id, orig_sys_document_ref, change_sequence;
649:
650: minimum number;

Line 850: FROM oe_headers_iface_all h, oe_order_sources os, --bug 4685432

846: AND h.org_id = a.org_id
847: AND operation_code <> 'BOOK_ORDER')
848: UNION
849: SELECT h.orig_sys_document_ref orig_sys_document_ref
850: FROM oe_headers_iface_all h, oe_order_sources os, --bug 4685432
851: oe_sys_parameters_all sys
852: WHERE request_id IS NULL
853: AND nvl(sys.org_id,l_default_org_id) = l_default_org_id --bug 4685432, 5209313
854: AND sys.org_id(+) = h.org_id

Line 1069: update oe_headers_iface_all

1065: -- number of child requests are spawned as this order will continue
1066: -- to exist with no request id assigned.
1067: l_order_rec.request_id(l_index) := l_request_id;
1068:
1069: update oe_headers_iface_all
1070: set error_flag='Y' --- did not update ineligible_for_hvop as per the TDD
1071: where order_source_id = l_order_rec.order_source_id(l_index)
1072: and orig_sys_document_ref = l_order_rec.orig_sys_document_ref(l_index)
1073: and nvl(org_id,-99) = nvl(l_order_rec.org_id(l_index),-99);

Line 1166: UPDATE oe_headers_iface_all

1162: --------------------------------------------------------------
1163:
1164: v_start := DBMS_UTILITY.GET_TIME;
1165: FORALL l_index IN 1..l_order_count
1166: UPDATE oe_headers_iface_all
1167: SET request_id = l_order_rec.request_id(l_index)
1168: , batch_id = l_order_rec.batch_id(l_index)
1169: , org_id = l_order_rec.org_id(l_index) -- added for MOAC
1170: WHERE order_source_id = l_order_rec.order_source_id(l_index)

Line 1226: UPDATE oe_headers_iface_all

1222: If p_debug_level > 0 Then
1223: oe_debug_pub.add('Updating Line_Ids for'||c.org_id);
1224: oe_debug_pub.add('Updating Line_Ids for'||c.orig_sys_document_ref);
1225: End If;
1226: UPDATE oe_headers_iface_all
1227: SET header_id = oe_order_headers_s.nextval
1228: WHERE order_source_id = c.order_source_id
1229: AND orig_sys_document_ref = c.orig_sys_document_ref
1230: AND nvl(org_id,-99) = nvl(c.org_id,-99)

Line 1273: FROM oe_headers_iface_all

1269: UPDATE oe_lines_interface
1270: SET request_id = l_request_id
1271: WHERE (order_source_id, orig_sys_document_ref) IN
1272: ( SELECT order_source_id, orig_sys_document_ref
1273: FROM oe_headers_iface_all
1274: WHERE request_id = l_request_id);
1275:
1276: COMMIT;
1277:

Line 1282: FROM oe_headers_iface_all

1278: UPDATE oe_price_adjs_interface
1279: SET request_id = l_request_id
1280: WHERE (order_source_id, orig_sys_document_ref) IN
1281: ( SELECT order_source_id, orig_sys_document_ref
1282: FROM oe_headers_iface_all
1283: WHERE request_id = l_request_id);
1284:
1285: COMMIT;
1286:

Line 1291: FROM oe_headers_iface_all

1287: UPDATE oe_actions_interface
1288: SET request_id = l_request_id
1289: WHERE (order_source_id, orig_sys_document_ref) IN
1290: ( SELECT order_source_id, orig_sys_document_ref
1291: FROM oe_headers_iface_all
1292: WHERE request_id = l_request_id);
1293:
1294: COMMIT;
1295: */

Line 1397: UPDATE oe_headers_iface_all

1393:
1394: -- Process_Batch will only return unexp error or success result
1395: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1396:
1397: UPDATE oe_headers_iface_all
1398: SET error_flag = 'Y'
1399: WHERE batch_id = l_batch_id;
1400:
1401: -- All orders in this batch would have failed as it is an unexp error.

Line 1410: FROM oe_headers_iface_all

1406: G_BOOKED_ORDERS := l_booked_orders;
1407:
1408: SELECT count(*)
1409: INTO l_batch_orders
1410: FROM oe_headers_iface_all
1411: WHERE batch_id = l_batch_id;
1412:
1413: G_ERROR_ORDERS := l_error_orders + l_batch_orders;
1414: