APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_HEADERS_INTERFACE

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

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

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

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

Line 697: FROM oe_headers_interface h, oe_order_sources os, --bug 4685432

693: INTO l_row_count
694: FROM(
695: SELECT /* MOAC_SQL_CHANGE */
696: h.orig_sys_document_ref orig_sys_document_ref
697: FROM oe_headers_interface h, oe_order_sources os, --bug 4685432
698: oe_sys_parameters_all sys
699: WHERE request_id IS NULL
700: AND sys.org_id(+) = h.org_id --bug 4685432, 5209313
701: AND sys.parameter_code(+) = 'ENABLE_FULFILLMENT_ACCEPTANCE'

Line 804: FROM oe_headers_interface h, oe_order_sources os, --bug 4685432

800: -- No need to select NULL org_id records.
801: oe_debug_pub.add('p_process_recs_with_no_org =N',1);
802: SELECT /* MOAC_SQL_CHANGE */ count(*)
803: INTO l_row_count
804: FROM oe_headers_interface h, oe_order_sources os, --bug 4685432
805: oe_sys_parameters_all sys
806: WHERE request_id IS NULL
807: AND sys.org_id(+) = h.org_id --bug 4685432, 5209313
808: AND sys.parameter_code(+) = 'ENABLE_FULFILLMENT_ACCEPTANCE'