eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: XTR_A_MASTER_CURRENCIES_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.XTR_A_MASTER_CURRENCIES_V

View Text

SELECT 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
, 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
, AUDIT_INDICATOR
, AUDIT_DATE_STORED
FROM XTR_A_MASTER_CURRENCIES

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
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
AUDIT_INDICATOR
AUDIT_DATE_STORED