FND Design Data [Home] [Help]

View: XTR_MASTER_CURRENCIES_V

Product: XTR - Treasury
Description:
Implementation/DBA Data: ViewAPPS.XTR_MASTER_CURRENCIES_V
View Text

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

Columns

Name
CURRENCY
NAME
AUTHORISED
DIVIDE_OR_MULTIPLY
YEAR_BASIS
ROUNDING_FACTOR
CREATED_BY
CREATED_ON
UPDATED_BY
UPDATED_ON
MINIMUM_BAND
MAXIMUM_BAND
IR_SEQ_NO
FX_SEQ_NO
NET_FX_EXPOSURE
MAX_DAYS_CONTRACT
AUDIT_INDICATOR
CALCULATE_HOLS_YEARS
LAST_TRANSACTION_CHANGED
CURRENT_SPOT_RATE
HCE_RATE
USD_QUOTED_SPOT
SPOT_DATE
USD_BASE_CURR_BID_RATE
USD_BASE_CURR_OFFER_RATE
RATE_DATE
UTILISED_AMOUNT
IG_YEAR_BASIS
GL_CALENDAR_NAME
GL_NO_UPLOAD