Open Sales Order STATUS  Query

SELECT order_number,

--  oe_line_status_pub.get_line_status(ool.line_id,ool.flow_status_code) line_status,

ool.flow_status_code,

  line_number

  ||'.'

  ||Shipment_number line_number,

  ool.creation_date,

  ool.ORIG_SYS_DOCUMENT_REF,

  ool.ordered_item,

  ool.ordered_quantity

FROM oe_order_headers_all ooh,

  oe_order_lines_all ool

WHERE ooh.order_type_id      IN (1331, 1615)

AND ooh.flow_status_code NOT IN ('CLOSED','CANCELLED')

AND ooh.header_id             =ool.header_id;