APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_ORDER_SOURCES

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

788: INTO l_row_count
789: FROM(
790: SELECT /* MOAC_SQL_CHANGE */
791: h.orig_sys_document_ref orig_sys_document_ref
792: FROM oe_headers_interface h, oe_order_sources os, --bug 4685432
793: oe_sys_parameters_all sys
794: WHERE request_id IS NULL
795: AND sys.org_id(+) = h.org_id --bug 4685432, 5209313
796: AND sys.parameter_code(+) = 'ENABLE_FULFILLMENT_ACCEPTANCE'

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

895: -- No need to select NULL org_id records.
896: oe_debug_pub.add('p_process_recs_with_no_org =N',1);
897: SELECT /* MOAC_SQL_CHANGE */ count(*)
898: INTO l_row_count
899: FROM oe_headers_interface h, oe_order_sources os, --bug 4685432
900: oe_sys_parameters_all sys
901: WHERE request_id IS NULL
902: AND sys.org_id(+) = h.org_id --bug 4685432, 5209313
903: AND sys.parameter_code(+) = 'ENABLE_FULFILLMENT_ACCEPTANCE'