132:
133: CURSOR SO_PROBLEM_CHECK IS
134: SELECT 'Open demand for this sales order'
135: FROM mtl_sales_orders mso, 136: mtl_demand md 137: WHERE mso.segment1 = p_order_number
138: AND mso.segment2 = p_order_type_name
139: AND mso.sales_order_id = md.demand_source_header_id
140: AND md.demand_source_type IN (2,8)