Sales order tables in oracle apps r12: 7 Important table of sale order

Sales order tables in oracle apps r12

In this post , we will share all the Oracle apps tables uses in the Sales order Module of the Oracle application. Oracle uses multiple tables to store the Sales order Information. Each table stores different form of Information and here below i will describe in detail all the sales order tables in oracle apps r12.

 

 

Here above is the Important sale order tables list in oracle apps r12.

 

OE_ORDER_HEADERS_ALL:-

 

When you enter the Sales Order Information in Oracle Application . then Sales Order Header Information stores in the oe_order_headers_all table.

When sale order is not booked then its FLOW_STATUS_CODE shows as ENTERED. When Order is booked then FLOW_STATUS_CODE shows as BOOKED.

 

 

OE_ORDER_LINES_ALL :-

 

This Table stores Sales Order Lines Information. All the order Items and its quantity and selling price information stores in this Table.

 

WSH_DELIVERY_DETAILS:-

 

This Table stores Sales Order Lines Shipment Information. When Order FLOW_STATUS_CODE shows as Booked then system creates the Records in this table as per the Sales Order Line of the Sales order Table. RELEASED_STATUS ‘R’ ready to release, LINE_ID comes as SOURCE_LINE_ID.

 

WSH_DELIVERY_ASSIGNMNETS:-

 

This table Stores Information about which delivery detail id of WSH_DELIVERY_DETAILS assigned to which delivery number.

 

MTL_DEMAND :-

 

This table stores Sales Order Items demand qty.

 

MTL_RESERVATIONS:-

 

This Table stores reservation information of the Sales order in oracle apps. When we booked the sale order in oracle then it creates the reservation of that sale order item in oracle inventory so that no other can use this Inventory Item Stock.