EBS : Oracle Apps GL Important Query

 Oracle APPS GL Query

• Query to get GL Daily rates

select * from apps.gl_daily_rates

where trunc(conversion_date) ='22-MAR-2023'

and from_currency='EUR' and TO_CURRENCY ='USD'

and conversion_type ='1002'

order by 3 desc;