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
Oracle R12 Sales Order Status API
Who is online
Users browsing this forum: No registered users and 10 guests