GL Daily Rates

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Daily currency conversion rates

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 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
JE Spanish B2G Electronic Invoices XML File Output CAC Item List Price vs. Item Cost AR Unapplied Receipts Register EOS GL Account Analysis with Tax AP Trial Balance CAC PO Price vs. Costing Method Comparison Mrugesh: GL Balance GL Balance by Account Hierarchy CAC Internal Order Shipment Margin GL Currency - Daily Conversion Rates Listing
Blitz Report™

Blitz Report™ provides multiple benefits: