Exchange rate query in oracle apps

Exchange rate query in oracle apps

In this post , We will be discuss about Exchange rate query in oracle apps. This query helps to find the Exchange rate of the currencies between each other for the period of time. This query helps to provide the Source currency to Destination currency Exchange rate maintained in the Oracle apps r12. Here below is the complete Exchange rate query in oracle apps.

 

 

 

Tables List uses for exchange rate query in oracle apps

 1.GL_DAILY_RATES.

2.GL_DAILY_CONVERSION_TYPES.

 

 Exchange rate query in oracle apps

 

SELECT RATE_SOURCE_CODE,
 CONVERSION_DATE,
typ.user_conversion_type "User Conversion Type"
,      rat.from_currency        "From Currency"
,      rat.to_currency          "To Currency"
,     CONVERSION_RATE "Exchange Rate"
FROM   gl_daily_conversion_types typ
,      gl_daily_rates            rat
WHERE  rat.conversion_type = typ.conversion_type
AND    rat.from_currency   < rat.to_currency