Home » Applications » Oracle Fusion Apps & E-Business Suite » Line Status in Sales Order Flow
Line Status in Sales Order Flow [message #252952] Fri, 20 July 2007 21:37 Go to next message
phanimekala
Messages: 25
Registered: June 2006
Junior Member
Hello Guys,

Can any one explain the line status in Sales Order flow in
Order Management and the stages in the flow and at the same time
the line status in Dropshipment flow.

help will be appreciated.

Thanks!
Re: Line Status in Sales Order Flow [message #288254 is a reply to message #252952] Sun, 16 December 2007 10:58 Go to previous message
dhrubajyoti_nth
Messages: 18
Registered: October 2007
Location: Renukoot
Junior Member

At the time of Order entry Two tables are used

1)OE_ORDER_HEADERS_ALL

2)OE_ORDER_LINES_ALL

At the time of booking the sales order :

1)OE_ORDER_HEADERS_ALL - flow_status_code 'BOOKED'

2)OE_ORDER_LINES_ALL - flow_status_code 'AWATING SHIPPING'

At the time of allocation the sales order :

OE_ORDER_LINES_ALL - flow_status_code 'AWATING SHIPPING'

After Material allocated transacted for the sales order :

OE_ORDER_LINES_ALL - flow_status_code 'PICKED'or 'PICKED PARTIAL'

After Ship confirmatiom of the sales order :

OE_ORDER_LINES_ALL - flow_status_code 'CLOSED'

Hope this will help

Regards,

D J Nath



Previous Topic: How to configure Item KFF with 3 segments
Next Topic: Oracle E-Business Suite Fresh Start
Goto Forum:
  


Current Time: Fri Jun 28 23:19:14 CDT 2024