EBS :GL Query : Query to get Ledger details (Oracle)

 GL

-------Query to get GL Ledger details-------------

select name,currency_code,CHART_OF_ACCOUNTS_ID,

gl_flexfields_pkg.get_coa_name(CHART_OF_ACCOUNTS_ID) COA

from gl_ledgers where name in ('XXG18_500_USD');