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

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  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