GL Daily Rates

Description
Categories: Enginatics
Repository: Github
Daily currency conversion rates
Run GL Daily Rates and other Oracle EBS reports with Blitz Report™ on our demo environment
select
gdct.user_conversion_type conversion_type, 
gdr.from_currency,
gdr.to_currency,
gdr.conversion_date,
gdr.conversion_rate,
xxen_util.user_name(gdr.created_by) created_by,
xxen_util.client_time(gdr.creation_date) creation_date,
xxen_util.user_name(gdr.last_updated_by) last_updated_by,
xxen_util.client_time(gdr.last_update_date) last_update_date
from
gl_daily_conversion_types gdct,
gl_daily_rates gdr
where
1=1 and
gdct.conversion_type=gdr.conversion_type
order by
gdct.user_conversion_type,
gdr.from_currency,
gdr.to_currency,
gdr.conversion_date desc
Parameter Name SQL text Validation
From Currency
gdr.from_currency=:from_currency
LOV
To Currency
gdr.to_currency=:to_currency
LOV
Conversion Date From
gdr.conversion_date>=:conversion_date_from
Date