APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_LINES_IFACE_ALL

Line 223: FROM oe_lines_iface_all b

219: WHERE batch_id = p_batch_id
220: AND nvl(error_flag,'N') = 'N'
221: AND EXISTS
222: (SELECT 1
223: FROM oe_lines_iface_all b
224: WHERE b.orig_sys_document_ref = a.orig_sys_document_ref
225: AND b.order_source_id = a.order_source_id
226: AND batch_id = p_batch_id
227: AND nvl(error_flag, 'N') = 'N'));

Line 234: FROM oe_lines_iface_all a

230: WHERE(order_source_id, orig_sys_line_ref, orig_sys_document_ref) IN
231: (SELECT a.order_source_id,
232: a.orig_sys_line_ref,
233: a.orig_sys_document_ref
234: FROM oe_lines_iface_all a
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

Line 251: FROM oe_lines_iface_all b

247: AND nvl(error_flag,'N') = 'N'
248: AND(order_source_id, orig_sys_document_ref) IN
249: (SELECT b.order_source_id,
250: b.orig_sys_document_ref
251: FROM oe_lines_iface_all b
252: WHERE a.orig_sys_document_ref = b.orig_sys_document_ref
253: AND a.order_source_id = b.order_source_id
254: AND nvl(error_flag, 'N') = 'Y'
255: AND EXISTS

Line 257: FROM oe_lines_iface_all c

253: AND a.order_source_id = b.order_source_id
254: AND nvl(error_flag, 'N') = 'Y'
255: AND EXISTS
256: (SELECT 'X'
257: FROM oe_lines_iface_all c
258: WHERE c.orig_sys_document_ref = a.orig_sys_document_ref
259: AND c.order_source_id = a.order_source_id
260: AND nvl(error_flag, 'N') = 'N'));
261:

Line 263: DELETE FROM oe_lines_iface_all

259: AND c.order_source_id = a.order_source_id
260: AND nvl(error_flag, 'N') = 'N'));
261:
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

Line 276: FROM oe_lines_iface_all b

272: WHERE batch_id = p_batch_id
273: AND nvl(error_flag, 'N') = 'N'
274: AND NOT EXISTS
275: (SELECT 1
276: FROM oe_lines_iface_all b
277: WHERE b.orig_sys_document_ref = a.orig_sys_document_ref
278: AND b.order_source_id = a.order_source_id
279: AND nvl(error_flag, 'N') = 'Y');
280:

Line 400: FROM oe_lines_iface_all b

396: WHERE request_id = l_request_id
397: AND nvl(error_flag, 'N') = 'N'
398: AND EXISTS
399: (SELECT orig_sys_line_ref
400: FROM oe_lines_iface_all b
401: WHERE b.orig_sys_document_ref = a.orig_sys_document_ref
402: AND b.order_source_id = a.order_source_id
403: AND nvl(error_flag, 'N') = 'Y')
404: ORDER BY a.order_source_id, a.orig_sys_document_ref ;

Line 445: FROM oe_headers_interface h, oe_lines_iface_all l, --bug 4685432

441: , count(*) num_lines
442: , NULL request_id
443: , NULL batch_id
444: , h.org_id
445: FROM oe_headers_interface h, oe_lines_iface_all l, --bug 4685432
446: oe_sys_parameters_all sys
447: WHERE h.order_source_id = nvl(p_order_source_id,h.order_source_id)
448: AND h.orig_sys_document_ref = nvl(p_orig_sys_document_ref,h.orig_sys_document_ref)
449: AND h.org_id = l.org_id

Line 522: FROM oe_headers_interface h, oe_lines_iface_all l, --bug 4685432

518: , count(*) num_lines
519: , NULL request_id
520: , NULL batch_id
521: , h.org_id org_id
522: FROM oe_headers_interface h, oe_lines_iface_all l, --bug 4685432
523: oe_sys_parameters_all sys
524: WHERE h.order_source_id = nvl(p_order_source_id,h.order_source_id)
525: AND h.orig_sys_document_ref = nvl(p_orig_sys_document_ref,h.orig_sys_document_ref)
526: AND sys.org_id(+) = h.org_id --bug 4685432, 5209313

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 816: FROM oe_lines_iface_all l

812: AND nvl(h.closed_flag ,'N') = 'N'
813: AND h.org_id = nvl(p_operating_unit,h.org_id)
814: AND NOT EXISTS
815: ( SELECT orig_sys_line_ref
816: FROM oe_lines_iface_all l
817: WHERE h.orig_sys_document_ref = l.orig_sys_document_ref
818: AND h.order_source_id = l.order_source_id
819: AND (nvl(l.source_type_code,'INTERNAL') = 'EXTERNAL'
820: OR l.arrival_set_name IS NOT NULL

Line 1233: UPDATE oe_lines_iface_all

1229: AND orig_sys_document_ref = c.orig_sys_document_ref
1230: AND nvl(org_id,-99) = nvl(c.org_id,-99)
1231: AND request_id = c.request_id; -- Changed for MOAC
1232:
1233: UPDATE oe_lines_iface_all
1234: SET line_id = oe_order_lines_s.nextval,
1235: request_id = l_instance_tbl(l_index).request_id,
1236: org_id = c.org_id
1237: WHERE order_source_id = c.order_source_id