Conversion Rate type table in oracle apps
In this post, We will be discuss about conversion
rate type table in oracle apps. Conversion rate type uses to create different
-different exchange rates for the same currencies but with different conversion
types. For Example, there are Two BU’s (A & B) in Oracle. One Work for
India and Second for Singapore and both refers different strategies to find the
currencies exchange rate so it might be the case both have different -2
exchange rates for the same currency on same date so for this kind of cases we
can create the Conversion Types Like Conversion for A and Conversion for B So
with this we can create two different exchange rates for the same currency on
same date with different conversion Types.
Conversion Rate type table Store this conversion type information’s and
with the help of this we further find Currencies exchange rates from the
system.
2 Important Conversion Rate type table in oracle apps
1.gl_daily_rates
2.gl_daily_conversion_types
SQL Query Using Conversion Rate type table in oracle apps
SELECT RATE_SOURCE_CODE,
typ.user_conversion_type "User
Conversion Type"
,
rat.from_currency
"From Currency"
,
rat.to_currency "To
Currency"
,
CONVERSION_RATE
,
CONVERSION_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
