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 you while desiging the reports &queries. These tables are
OE_ORDER_HEADERS_ALL OE_ORDER_LINES_ALL
WSH_DELIVERY_DETAILS WSH_DELIVERY_ASSIGNMENTS
WSH_NEW-DELIVERIES WSH_DELIVERY_LEGS
WSH_TRIP_STOPS WSH_TRIPS
M TL_TRX_REQUEST_LINES MTL_MATERIAL_TRANSACTION_TEMP
OE_SETS OE_LINE_SETS
PO_LINES_ALL MTL_RESERVATIONS
MTL_MATERIAL_TRANSACTIONS_ALL
Data Flow Diagram
OE_ORDER_HEADERS_ALL OE_ORDER_LINES_ALL
WSH_DELIVERY_DETAILS WSH_DELIVERY_ASSIGNMENTS
WSH_NEW-DELIVERIES WSH_DELIVERY_LEGS
WSH_TRIP_STOPS WSH_TRIPS
M TL_TRX_REQUEST_LINES MTL_MATERIAL_TRANSACTION_TEMP
OE_SETS OE_LINE_SETS
PO_LINES_ALL MTL_RESERVATIONS
MTL_MATERIAL_TRANSACTIONS_ALL
Data Flow Diagram
No comments:
Post a Comment