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