Table level Data flow for Order to Cash Flow

In this blog I have highlight some of the KEY tables involved in Order to Cash table. There are lot of database table involves in this flow , but I have highlighted the key table and link between these tables.It help the consultant while desiging the reports &queries.

These tables are

1. OE_ORDER_HEADERS_ALL

2. OE_ORDER_LINES_ALL

3. WSH_DELIVERY_DETAILS

4. WSH_DELIVERY_ASSIGNMENTS

5. WSH_NEW-DELIVERIES

6. WSH_DELIVERY_LEGS

7. WSH_TRIP_STOPS

8. WSH_TRIPS

9. M TL_TRX_REQUEST_LINES

10. MTL_MATERIAL_TRANSACTION_TEMP

11. OE_SETS

12. OE_LINE_SETS

13. O_LINES_ALL

14. MTL_RESERVATIONS

15. MTL_MATERIAL_TRANSACTIONS_ALL