[Home] [Help]
347: , count(*) num_lines
348: , NULL request_id
349: , NULL batch_id
350: , h.org_id
351: FROM oe_headers_interface h, oe_lines_iface_all l, --bug 4685432
352: oe_sys_parameters_all sys
353: WHERE h.order_source_id = nvl(p_order_source_id,h.order_source_id)
354: AND h.orig_sys_document_ref = nvl(p_orig_sys_document_ref,h.orig_sys_document_ref)
355: AND h.org_id = l.org_id
424: , count(*) num_lines
425: , NULL request_id
426: , NULL batch_id
427: , h.org_id org_id
428: FROM oe_headers_interface h, oe_lines_iface_all l, --bug 4685432
429: oe_sys_parameters_all sys
430: WHERE h.order_source_id = nvl(p_order_source_id,h.order_source_id)
431: AND h.orig_sys_document_ref = nvl(p_orig_sys_document_ref,h.orig_sys_document_ref)
432: AND sys.org_id(+) = h.org_id --bug 4685432, 5209313
477: , count(*) num_lines
478: , NULL request_id
479: , NULL batch_id
480: , l_default_org_id org_id
481: FROM oe_headers_iface_all h, oe_lines_iface_all l, --bug 4685432
482: oe_sys_parameters_all sys
483: WHERE h.order_source_id = nvl(p_order_source_id,h.order_source_id)
484: AND h.orig_sys_document_ref = nvl(p_orig_sys_document_ref,h.orig_sys_document_ref)
485: AND nvl(sys.org_id,l_default_org_id) = l_default_org_id --bug 4685432, 5209313
717: AND nvl(h.closed_flag ,'N') = 'N'
718: AND h.org_id = nvl(p_operating_unit,h.org_id)
719: AND NOT EXISTS
720: ( SELECT orig_sys_line_ref
721: FROM oe_lines_iface_all l
722: WHERE h.orig_sys_document_ref = l.orig_sys_document_ref
723: AND h.order_source_id = l.order_source_id
724: AND (nvl(l.source_type_code,'INTERNAL') = 'EXTERNAL'
725: OR l.arrival_set_name IS NOT NULL
1134: AND orig_sys_document_ref = c.orig_sys_document_ref
1135: AND nvl(org_id,-99) = nvl(c.org_id,-99)
1136: AND request_id = c.request_id; -- Changed for MOAC
1137:
1138: UPDATE oe_lines_iface_all
1139: SET line_id = oe_order_lines_s.nextval,
1140: request_id = l_instance_tbl(l_index).request_id,
1141: org_id = c.org_id
1142: WHERE order_source_id = c.order_source_id