O2C Cycle

***********************************************************************

A very good presentation at:

https://govoracleapps.wordpress.com/category/order-to-casho2c/

***********************************************************************
Profile options for Order Management

MO: Default Operating Unit

***********************************************************************

- Order Creation

Tables:

1- OE_order_headers_all
select * from oe_order_headers_all where order_number=1020000003;

2- OE_order_lines_all Linking field is header_id
select * from oe_order_lines_all where header_id = (select header_id from oe_order_headers_all where order_number=1020000003);


- Book an Order

Tables:

1- wsh_delivery_details

select * from wsh_delivery_details where source_header_Id = (select header_id from oe_order_headers_all where order_number=1020000003);


2- wsh_delivery_assignments  (column  links to wsh_delivery_details is delivery_detail_id)

select * from wsh_delivery_assignments where delivery_detail_Id =
               (select delivery_detail_id from wsh_delivery_details where source_header_id = (select header_id from oe_order_headers_all where order_number=1020000003));

======= IN PROGRESS ===========