You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

PO Custom report with Total Currency Converted Ordered Amount

Received Response
62
Views
1
Comments

Summary:



Content (required):

I am trying to write the custom query to get the PO total orderd amount , where I am using the" PO_BIP_HELPER.get_ordered_display (PHA.PO_HEADER_ID,'0','TXN','H',PHA.CURRENCY_CODE)" but When I do the Mutliplication with Currency Rate and When I run the data view I am getting an error saying "ORA-01722: invalid number" ,

Can any one help me

Thanks in Advance

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

PO_BIP_HELPER.get_ordered_display(PHA.PO_HEADER_ID,'0','TXN','H',PHA.CURRENCY_CODE)*PHA.RATE AS "PO_TOTAL"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!