Home » Applications » Oracle Fusion Apps & E-Business Suite » Need to get logic to get unit price * quantity * rate (11.5.02)
Need to get logic to get unit price * quantity * rate [message #506893] Wed, 11 May 2011 11:35 Go to next message
pallavigs
Messages: 37
Registered: March 2006
Location: India
Member
Hi All,

We are trying to make a report which has a cummulatative amount which is drived from below

select sum(pla.unit_price*pla.quanity)"Cummat'
from po_lines_all


This gives me correct cumm amt with this summing but in one more column we need for specific vendor we need
unit price*quantity*rate


The rate is derived from po headers all.

I need to get the value for new column X which would have all the data of quantity*unitprice*rate

*Rate INR rate/USD rate/ JPY rate.

Hope i have made my question clear.

Thanks,Pal
Re: Need to get logic to get unit price * quantity * rate [message #512685 is a reply to message #506893] Tue, 21 June 2011 08:44 Go to previous message
vishalk
Messages: 33
Registered: October 2010
Member

i did't get what u want and where u get error.
can u discribe more.
Previous Topic: Sales Order Interface
Next Topic: unable to get request id
Goto Forum:
  


Current Time: Thu Aug 05 19:47:20 CDT 2021