OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Need to get logic to get unit price * quantity * rate

Home » Applications » Oracle Fusion Apps & E-Business Suite » Need to get logic to get unit price * quantity * rate (11.5.02)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need to get logic to get unit price * quantity * rate [message #506893]

Wed, 11 May 2011 11:35

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

Report message to a moderator

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

vishalk
Messages: 33
Registered: October 2010

Member

i did't get what u want and where u get error.
can u discribe more.

Report message to a moderator

Previous Topic:	Sales Order Interface
Next Topic:	unable to get request id

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 05:07:37 CST 2024