Home » Developer & Programmer » Reports & Discoverer » Report in OM (report6i)
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
Previous Topic: LOV in Parameter From
Next Topic: discoverer
Goto Forum:
  


Current Time: Fri Apr 19 11:29:02 CDT 2024