Oracle R12 Sales Order Status API

Here post Oracle Order Management related topics.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Oracle R12 Sales Order Status API

Post by admin »

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
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests