VIEW: APPS.XTR_MASTER_CURRENCIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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