BIP – Query to extract Currency Details
select fct.name
,fcb.currency_code
,fcb.symbol
,fct.description
,fcb.enabled_flag
,to_char(fcb.start_date_active,'DD-MON-RRRR') start_date_act
,to_char(fcb.end_date_active,'DD-MON-RRRR') end_date_act
,fcb.issuing_territory_code
,fcb.precision
,fcb.extended_precision
,fcb.iso_flag
,fcb.derive_effective
from fnd_currencies_b fcb
,fnd_currencies_tl fct
where fcb.currency_code =fct.currency_code