Entered
|
|
oe_order_headers_all
|
1 record created in header table
|
oe_order_lines_all
|
Lines for particular records
|
oe_price_adjustments
|
When discount gets applied
|
oe_order_price_attribs
|
If line has price attributes then populated
|
oe_order_holds_all
|
If any hold applied for order like credit check etc.
|
|
|
Booked
|
|
oe_order_headers_all
|
Booked_flag=Y Order booked.
|
wsh_delivery_details
|
Released_status Ready to release
|
|
|
PickReleased
|
|
wsh_delivery_details
|
Released_status=Y Released to Warehouse (Line has been released
to Inventory for processing)
|
wsh_picking_batches
|
After batch is created for pick release.
|
mtl_reservations
|
This is only soft reservations. No physical movement of stock
|
|
|
FullTransaction
|
|
mtl_material_transactions
|
No records in mtl_material_transactions
|
mtl_txn_request_headers
|
|
mtl_txn_request_lines
|
|
wsh_delivery_details
|
Released to warehouse.
|
wsh_new_deliveries
|
if Auto-Create is Yes then data populated.
|
wsh_delivery_assignments
|
deliveries get assigned
|
|
|
PickConfirmed
|
|
wsh_delivery_details
|
Released_status=Y Hard Reservations. Picked the stock. Physical
movement of stock
|
|
|
ShipConfirmed
|
|
wsh_delivery_details
|
Released_status=C Y To C:Shipped ;Delivery Note get printed
Delivery assigned to trip stopquantity will be decreased from staged
|
mtl_material_transactions
|
On the ship confirm form, check Ship all box
|
wsh_new_deliveries
|
If Defer Interface is checked I.e its deferred then OM &
inventory not updated. If Defer Interface is not checked.: Shipped
|
oe_order_lines_all
|
Shipped_quantity get populated.
|
wsh_delivery_legs
|
1 leg is called as 1 trip.1 Pickup & drop up stop for each
trip.
|
oe_order_headers_all
|
If all the lines get shipped then only flag N
|
|
|
Autoinvoice
|
|
wsh_delivery_details
|
Released_status=I Need to run workflow background process.
|
ra_interface_lines_all
|
Data will be populated after wkfw process.
|
ra_customer_trx_all
|
After running Autoinvoice Master Program for
|
ra_customer_trx_lines_all
|
specific batch transaction tables get populated
|
Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Thursday, December 24, 2015
Effected Tables in Order Management in Different Stages
Subscribe to:
Post Comments (Atom)
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
No comments:
Post a Comment