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_RANGES

Object Details

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

XTR_INTEREST_RATE_RANGES contains interest rate information for your bank accounts as well as global and specific interest rate information for intercompany funding deals. Each row corresponds to an amount range for which a interest rate applies for a given bank account and party or bank code. In the case of bank accounts, each row stores the bank code and bank account number. For counterparty settlement accounts, each row stores the counterparty code and settlement account number. For intercompany funding deals, each row stores the company and counterparty code for global and specific interest, respectively, and the account number of IG_PRO1075.
This table corresponds to the Bank Account Interest Rates window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_INTEREST_RATE_RANGES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EFFECTIVE_FROM_DATE PARTY_CODE CURRENCY REF_CODE MIN_AMT MAX_AMT

Columns

Name	Datatype	Length	Mandatory	Comments
CURRENCY	VARCHAR2	(15)	Yes	Currency code
EFFECTIVE_FROM_DATE	DATE			Effective date for the particular amount and interest rate
INTEREST_RATE	NUMBER			Interest rate at which a deal or transaction is executed
MAX_AMT	NUMBER			Maximum amount
MIN_AMT	NUMBER			Minimum amount
PARTY_CODE	VARCHAR2	(7)	Yes	Party code
REF_CODE	VARCHAR2	(20)	Yes	Reference account number code
BANK_ACCT_USE_ID	NUMBER	(15)		Reference account number ID

Query Text

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


SELECT CURRENCY
,      EFFECTIVE_FROM_DATE
,      INTEREST_RATE
,      MAX_AMT
,      MIN_AMT
,      PARTY_CODE
,      REF_CODE
,      BANK_ACCT_USE_ID
FROM XTR.XTR_INTEREST_RATE_RANGES;

Dependencies

[top of page]

XTR.XTR_INTEREST_RATE_RANGES does not reference any database object

XTR.XTR_INTEREST_RATE_RANGES is referenced by following:

XTR: XTR_INTEREST_RATE_RANGES#