GL Daily Rates
Description
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 |
|
LOV | |
To Currency |
|
LOV | |
Conversion Type |
|
LOV | |
Conversion Date From |
|
Date | |
Conversion Date To |
|
Date |