Product: | XTR - Treasury |
---|---|
Description: | |
Implementation/DBA Data: |
![]() |
SELECT MC.CURRENCY
, MC.NAME
, MC.AUTHORISED
, MC.DIVIDE_OR_MULTIPLY
, MC.YEAR_BASIS
, FC.PRECISION
, MC.CREATED_BY
, MC.CREATED_ON
, MC.UPDATED_BY
, MC.UPDATED_ON
, MC.MINIMUM_BAND
, MC.MAXIMUM_BAND
, MC.IR_SEQ_NO
, MC.FX_SEQ_NO
, MC.NET_FX_EXPOSURE
, MC.MAX_DAYS_CONTRACT
, MC.AUDIT_INDICATOR
, MC.CALCULATE_HOLS_YEARS
, MC.LAST_TRANSACTION_CHANGED
, MC.CURRENT_SPOT_RATE
, MC.HCE_RATE
, MC.USD_QUOTED_SPOT
, MC.SPOT_DATE
, MC.USD_BASE_CURR_BID_RATE
, MC.USD_BASE_CURR_OFFER_RATE
, MC.RATE_DATE
, MC.UTILISED_AMOUNT
, MC.IG_YEAR_BASIS
, MC.GL_CALENDAR_NAME
, MC.GL_NO_UPLOAD
FROM XTR_MASTER_CURRENCIES MC
, FND_CURRENCIES FC
WHERE MC.CURRENCY = FC.CURRENCY_CODE