GL Daily Rates

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Daily currency conversion rates
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 NameSQL textValidation
From Currency
gdr.from_currency=:from_currency
LOV
To Currency
gdr.to_currency=:to_currency
LOV
Conversion Type
gdct.user_conversion_type=:conversion_type
LOV
Conversion Date From
gdr.conversion_date>=:conversion_date_from
Date
Conversion Date To
gdr.conversion_date<:conversion_date_to+1
Date
Download
Related Blitz Reports
GL Account Analysis 11i CAC PO Price vs. Costing Method Comparison COPY OF: AP Accounted Invoice Aging GL Journals (Drilldown) Mrugesh: GL Balance TB GL Account Analysis (Drilldown)v2 GL Balance by Account Hierarchy CAC Internal Order Shipment Margin GL Currency - Daily Conversion Rates Listing JE Spanish B2G Electronic Invoices XML File Output
Blitz Report™