GL Currency - Daily Conversion Rates Listing
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Reports on daily conversion rates by period/currency.
Application: General Ledger
Source: Currency - Daily Conversion Rates Listing (XML)
Short Name: GLXRDRTS_XML
DB package: GL_GLXRDRTS_XMLP_PKG
Description: Reports on daily conversion rates by period/currency.
Application: General Ledger
Source: Currency - Daily Conversion Rates Listing (XML)
Short Name: GLXRDRTS_XML
DB package: GL_GLXRDRTS_XMLP_PKG
Run
GL Currency - Daily Conversion Rates Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT ct.user_conversion_type , r.conversion_date , r.conversion_rate, r2.conversion_rate inverse_conversion_rate FROM gl_daily_rates r, gl_daily_rates r2, gl_daily_conversion_types ct, gl_periods p WHERE r.from_currency = :P_FROM_CURRENCY AND r.to_currency = :P_TO_CURRENCY AND r.conversion_date BETWEEN p.start_date AND p.end_date AND r.conversion_type = ct.conversion_type AND r2.from_currency = r.to_currency AND r2.to_currency = r.from_currency AND r2.conversion_date = r.conversion_date AND r2.conversion_type = r.conversion_type AND p.period_set_name = :P_PERIOD_SET_NAME AND p.period_name = :P_PERIOD AND ct.conversion_type = nvl(:P_CONVERSION_TYPE, ct.conversion_type) AND decode(ct.security_flag, 'Y', decode(fnd_data_security.check_function(1.0, 'GL_DAS_RATE_TYPES_V', 'GL_DAS_RATE_TYPES', ct.conversion_type, null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') = 'Y' ORDER BY ct.user_conversion_type, r.conversion_date |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Period |
|
LOV Oracle | |
From Currency |
|
LOV Oracle | |
To Currency |
|
LOV Oracle | |
Conversion Rate Type |
|
LOV Oracle |