Report in OM [message #408208] |
Mon, 15 June 2009 05:47 |
aiyaz_ma
Messages: 56 Registered: May 2009 Location: Hyderabad
|
Member |
|
|
Hello All,
I got an requirement for building a report with 4 columns customer name , product, last week , this week.......
So, how to get the customer name if i am not wrong we can get it from RA_CUSTOMERS.
and product ?may be from MTL_SYSTEM_ITEMS_B
and the last week and this week should come from request_date from the OE_ORDER_HEADERS_ALL table. It should be a number.
could you plese help me in this ?
and give me an idea how to complete this
thanks and regards
M.A.Aiyaz
|
|
|