Exchange rate table in oracle apps

Exchange rate table in oracle apps

In this post , We will discuss about Exchange rate table in oracle apps. Exchange rate table stores Currencies Exchange rates as respect to the other currencies. We can also say these tables stores Currencies Conversion rates in oracle apps r12. We will get the Exchange rate of one currency from Another currency in the Exchange rate table in oracle apps.Here below is the complete list of the Exchange rate table in oracle apps.

 

 

Detail List of the Exchange rate table in oracle apps.

 

1. gl_daily_conversion_types

2. gl_daily_rates

 

 

SQL query using Exchange rate table in oracle apps

SELECT typ.user_conversion_type "Conversion Type"

,      rat.from_currency        "From Currency"

,      rat.to_currency          "To Currency"

,rat.CONVERSION_RATE

,      MIN(conversion_date)     "Earliest Date"

,      MAX(conversion_date)     "Latest Date"

FROM   gl_daily_conversion_types typ

,      gl_daily_rates            rat

WHERE  rat.conversion_type = typ.conversion_type

AND    rat.from_currency   < rat.to_currency

GROUP BY typ.user_conversion_type

,        rat.from_currency  

,        rat.to_currency

,rat.CONVERSION_RATE

ORDER BY typ.user_conversion_type, rat.from_currency, rat.to_currency