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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: XTR.XTR_INTEREST_RATE_BANDS

Object Details

Object Name:	XTR_INTEREST_RATE_BANDS
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_INTEREST_RATE_BANDS
Subobject Name:
Status:	VALID

XTR_INTEREST_RATE_BANDS contains the detailed time frame associated with the interest rate policies defined in the XTR_INTEREST_RATE_POLICY table. Each row includes the currency, the period band reference, the time frame, and the percentage of total maturities that are associated with the time frame. After selecting the currency and the invest/fund type, you can establish the percentage of maturities which you want to occur during certain time frames.
The period band reference in this table is a concatenation of an investment types of either FUND, INVEST, or FX, and a currency. If the period band reference in a row of this table matches up with the period band reference of a row in the XTR_INTREST_RATE_POLICY table, then that interest rate band is part of that interest rate policy.
This table corresponds to the Band Details region of the Interest Rate Policies window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CURRENCY	VARCHAR2	(15)		Currency code
FX_PERCENT_MAX	NUMBER			Maximum percentage for foreign exchange type policy band
FX_PERCENT_MIN	NUMBER			Minumum percentage for foreign exchange type policy band
PERCENT_MAX_MATURING	NUMBER			Maximum percentage band for the certain period
PERIOD_BAND_REFERENCE	VARCHAR2	(20)	Yes	Concatenation of an investment category (INVEST, FUND, or FX) and currency code
PERIOD_DESC	VARCHAR2	(20)		Description for the period
PERIOD_FROM	NUMBER			Period that the interest rate band begins to apply
PERIOD_TO	NUMBER			Period that the interest rate band no longer applies
TYPE_PERIOD_FROM_MONTH_YEAR	VARCHAR2	(1)		Type of from peiord (Month or Year)
TYPE_PERIOD_TO_MONTH_YEAR	VARCHAR2	(1)		Type of to period (Month or Year)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CURRENCY
,      FX_PERCENT_MAX
,      FX_PERCENT_MIN
,      PERCENT_MAX_MATURING
,      PERIOD_BAND_REFERENCE
,      PERIOD_DESC
,      PERIOD_FROM
,      PERIOD_TO
,      TYPE_PERIOD_FROM_MONTH_YEAR
,      TYPE_PERIOD_TO_MONTH_YEAR
FROM XTR.XTR_INTEREST_RATE_BANDS;

Dependencies

[top of page]

XTR.XTR_INTEREST_RATE_BANDS does not reference any database object

XTR.XTR_INTEREST_RATE_BANDS is referenced by following:

APPS: XTR_INTEREST_RATE_BANDS