General Oracle Question:

Create Sale order >

in the Header Level - enter customer name whos should be having both Bill to and Sit to Address> enter Payment Terms> enter the pricing > enter the transaction Type of that sale, then go to Line item and pick the invenotiable ( or ono inventoribale item) items from item master from the Sub Inventroy Orginsation, then attch this line to a particular sales man or collection agent.

Save the data, ( Line statius is 'Entered') then book the order ( shows the line status as " line is awating shippment" ( order status will be 'booked' > release the sales order > ( Line status will be " Picked") and ship the Materail which eventually show the line status as 'closed'.

this shows the inventroy is credited with inventory Cost and COGS is Debited

The next face is interfacing to AR ( Autoinvoicing Rule) - Customer is Debited and Sales is Credited.

enter the order:
---------------
oe-order-headers-all
oe-order-lines-all(flow_status_code = entered)
book the order:
--------------
oe_order_headers_all
oe_order_lines_all(flow_status_code = booked)
wsh_new_deliveries(status_code =open)
wsh_delivery_details(releases_status = R 'ready to release)
pick release:
---------------
which items on sales order we need to take out from inventory.
normally pick release SRS program run from backend once this over.
oe_order_lines_all(flow_status_code=picked)
wsh_delivery_detalis(release_status = S 'submitted for release)

pick confirm:
-------------
items are transfered from salable to staging sub inventory.
mtl_material_transaction
mtl_transaction_accounts
wsh_delivery_details(released_status = Y 'released')
wsh_delivery_assignments

ship confirm:
-------------
here ship confirm program run from backend and data removed from wsh_new_deliveries.
oe_order_lines_all ( flow_status_code =shipped)
wsh_delivery_details (released_status = shipped)
mtl_transaction_interface
mtl_material_transactions (linked through source_header_id)
data deleted from mtl_demand & mtl_reservations
item deducted from mtl_onhand_quantities.

Enter invoice:
--------------
this is also called recivables interface,that mean information moved to accounting area for invoicing
details.
invoicing workflow activity transfers shipped item info to recevables.
ra_interface_lines_all
then auto-invoice program imports data from this.
then effected tables : ra_customer_trx_all (trx_number is the invoice number)
ra_customer_trx_lines_all (line_attribute 1 & 6 ) linked to header_id
and lined_id for orders....

complete line:
-------------
order line level table get updated with flow status & open flag.
oe_ordr_lines_all ( flow_status_code = shipped & open flag = N)

close order:
------------
once we close the order oe_order_lines_all table get updated with flow_status_code as closed.