ERPstuff - Oracle EBS Community

This is how you can get order status in Order management,

SELECT oh.order_number, line_number, ordered_item, OE_LINE_STATUS_PUB.GET_LINE_STATUS(OL.LINE_ID, OL.FLOW_STATUS_CODE)
FROM OE_ORDER_LINES_ALL OL, oe_order_headers_all oh
WHERE ol.header_id= oh.header_id