SELECT CURR.ISO_CURRENCY_CD ISO_CURRENCY_CD, CURRMLS.CURRENCY_NAME CURRENCY_NAME, CURR.USER_DEF_FLG USER_DEF_FLG, CURR.CURRENCY_STATUS_CD CURRENCY_STATUS_CD, CURR.REPORTING_FLG REPORTING_FLG, CURR.REFERENCE_IRC REFERENCE_IRC FROM CURRENCIES CURR, CURRENCY_MLS CURRMLS