Oracle SALES ORDER DOCUMENTATION

Sales order first go to the sales order responsibility and in that go to sales order,
and here you can create a sales order by giving customer infromation and go to the line items
Tab and giving items related information here just save it and press tab bookorder . once this is
done than the status will be from entered state to booked state.

Once the order is in Bookedstate then we must do pickrealse... this we can do in the Shiping
--Release Sales orders .. here try to give proper values and excute the order then in the back
ground pick release concurrent program will be executed ... then Pick Release is done .

After the pick release we must do pick confirm the sales order, to do this we must go to
the inventory module ....here go to move order-->Transact move order --->pickwave here
give the salesordernumber or pickreleasenumber and we can also change the quantity ie
we can reduce the quantity and can have back order quatity and accordingly we can also
have the cycle count reservations etc. once the changes are done then press the Transact
button .. once this is done we are done with the pick confirm....

now we must do Ship confirm ...to do this we must go the OM responsibility and go
to the Shipping--->Transactions --->here give salesorder number and find and then go to deliver
tab , details now here you press the tab Ship Confirm.Now after ship confirm the
sales order will be in closed state.

The main base tables affected during this process of creation of sales order is

below tables will be populated while sales order is entered .( status will be in entetred state)

1)oe_order_headers_all
2)oe_order_lines_all

Once the order is booked then the following tables get affected

1)wsh_delivery_details
2)wsh_delivery_assignments

once the order is pick release then

1)wsh_new_deliveries

after pick release and before pick confirm all the records will be in

1)mtl_material_transactions_temp
2)mtl_txn_request_lines

Once pick confirm is done then the records will be gone from the above tables.

Mtl_material_transactions will be populated.

Belolw tables are used for Lot Control items and serial control items related information

1)mtl_transactions_lots_temp
2)mtl_serial_numbers_temp

SELECT * FROM fnd_lookup_values
where lookup_type='PICK_STATUS'

RESERVATION DETAILS WILL BE IN

MTL_RESERVATIONS TABLE......