APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_ORDER_SOURCES

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 755: FROM oe_headers_iface_all h, oe_order_sources os, --bug 4685432

751: AND h.org_id = a.org_id
752: AND operation_code <> 'BOOK_ORDER')
753: UNION
754: SELECT h.orig_sys_document_ref orig_sys_document_ref
755: FROM oe_headers_iface_all h, oe_order_sources os, --bug 4685432
756: oe_sys_parameters_all sys
757: WHERE request_id IS NULL
758: AND nvl(sys.org_id,l_default_org_id) = l_default_org_id --bug 4685432, 5209313
759: AND sys.org_id(+) = h.org_id

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'