[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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) |
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;
XTR.XTR_INTEREST_RATE_BANDS does not reference any database object
XTR.XTR_INTEREST_RATE_BANDS is referenced by following:
|
|
|