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
In case you need sql Queries , please feel free to contact me.
Good Work! Can you provide me queries?
ReplyDeleter-chopra@hotmail.com
Good Work!
ReplyDeleteCan you provide me queries?
r-chopra@hotmail.com
Hi Rajeev
ReplyDeleteEverything is very much there is the diagram. I listef all the columns that you can use for the JOIN condition. you just need to select the columns you want to print.
Sample query with few tables is
select l.* from oe_order_lines_all l ,
oe_order_headers_all h ,
wsh_delivery_details wdd ,
wsh_new_deliveries wnd,
wsh_delivery_assignments wda,
wsh_delivery_legs wl
where l.header_id = h.header_id
and l.line_id = wdd.source_line_id
and wdd.delivery_detail_id = wda.delivery_detail_id
and wda.delivery_id = wnd.delivery_id
and wl.delivery_id = wnd.delivery_id
Good Work
ReplyDeleteYou can also add the table OE_PRICE_ADJUSTMENTS as well- for the modifiers which get applied to the Order or Order Line
ReplyDeletegood work
ReplyDeletecan u send queries.
findarif99@gmail.com
search for "Query" in the search bar , and you will get some queries , if not all .
ReplyDeleteIn case you need some specific query , do let me know ( not sure I will provide , but will for sure try to write)
Good work , it really save me lot of time..
ReplyDeleteGood article..it helps a lot..
ReplyDeleteOne image cleared all my doubts....
ReplyDeleteHey can you post mapping images for all OMr12 tables
Really a very fine way to express and looking a very pleasant article with full of healthy information. I am definitely going to tell in my class about this platform and the information shared here. Very well written.Oracle R12 Financials Training in Bangalore
ReplyDeleteThe enormous information record can't be effortlessly handle by the individual who isn't additional conventional in the overseeing of information by following the correct system for dealing with the information everybody can without much of a stretch manage it yet this procedure just knows by those individuals who are the information researcher, so on the off chance that you need to get the information researcher for tackling up your information issue than go to this web-site activewizards.com/ .
ReplyDeleteThanks for sharing valuable information. Your blogs were helpful to tableau learners. I
ReplyDeleterequest to update the blog through step-by-step. Also, find the tableau news at
Tableau Online Training Blog.
The meaning of 'preparing' is expansive. It covers any activity completed on the data and incorporates, acquiring or recording data, the recovery, interview or utilization of data, the revelation or generally making accessible of data.
ReplyDeletepengeluaran hk