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_RATE_SETS

Object Details

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

XTR_RATE_SETS contains information about interest rates for retail term money deals. Each row corresponds to the deal subtype, product type, amount, term, and effective date to which you want to apply the rate.
This table corresponds to Product Rates window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_RATE_SETS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEAL_TYPE DEAL_SUBTYPE PRODUCT_TYPE EFFECTIVE_FROM CURRENCY LOW_RANGE HIGH_RANGE CLIENT_GROUPING FIXED_FLOATING TERM

Columns

Name	Datatype	Length	Mandatory	Comments
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
CLIENT_GROUPING	VARCHAR2	(7)		Client group code
CURRENCY	VARCHAR2	(15)	Yes	Currency code
DEAL_SUBTYPE	VARCHAR2	(7)	Yes	Code for deal executions permissible within a deal type
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
EFFECTIVE_FROM	DATE		Yes	Date the rate becomes effective
FIXED_FLOATING	VARCHAR2	(5)		Indicates if interest rate is fixed or floating
HIGH_RANGE	NUMBER		Yes	Maximum amount the rate is applicable
INTEREST_PERIOD	VARCHAR2	(7)		Interest period
LOW_RANGE	NUMBER		Yes	Minimum amount the rate is applicable
MARGIN	NUMBER			Rate marked up or down amount
NO_OF_DAYS	NUMBER			Number of days used to calculate interest
PI_CONSTANT	VARCHAR2	(1)		Flag to indicate if principal and interest amount is kept constant (Y) or not (N)
POSTED	DATE			Not currently used
PRODUCT_TYPE	VARCHAR2	(10)	Yes	Code for products used in a deal type
RATE	NUMBER			Interest rate
RATE_EFFECTIVE_CREATED	DATE		Yes	Date the rate is created
RESET_BASIS	VARCHAR2	(15)		Not currently used
TERM	VARCHAR2	(3)		Term length in which a rate is applicable
UNIQUE_REF_NUM	NUMBER		Yes	Unique reference number for each rate set
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
UPDATE_EXISTING_DEALS	VARCHAR2	(1)		Flag to indicate if existing deals is updated (Y), or not (Null)
CREATED_BY	VARCHAR2	(30)	Yes	User who created this record
CREATED_ON	DATE		Yes	Date this record was created
CONCURRENT_REQUEST	VARCHAR2	(1)		Flag to indicate concurrent request (Y), or not (N)

Query Text

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


SELECT AUDIT_INDICATOR
,      CLIENT_GROUPING
,      CURRENCY
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      EFFECTIVE_FROM
,      FIXED_FLOATING
,      HIGH_RANGE
,      INTEREST_PERIOD
,      LOW_RANGE
,      MARGIN
,      NO_OF_DAYS
,      PI_CONSTANT
,      POSTED
,      PRODUCT_TYPE
,      RATE
,      RATE_EFFECTIVE_CREATED
,      RESET_BASIS
,      TERM
,      UNIQUE_REF_NUM
,      UPDATED_BY
,      UPDATED_ON
,      UPDATE_EXISTING_DEALS
,      CREATED_BY
,      CREATED_ON
,      CONCURRENT_REQUEST
FROM XTR.XTR_RATE_SETS;

Dependencies

[top of page]

XTR.XTR_RATE_SETS does not reference any database object

XTR.XTR_RATE_SETS is referenced by following:

XTR: XTR_RATE_SETS#