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: LNS.LNS_RATE_SCHEDULES

Object Details

Object Name:	LNS_RATE_SCHEDULES
Object Type:	TABLE
Owner:	LNS
FND Design Data:	LNS.LNS_RATE_SCHEDULES
Subobject Name:
Status:	VALID

Loan Interest Rate Schedule Table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
LNS_RATE_SCHEDULES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RATE_ID
LNS_RATE_SCHEDULES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TERM_ID BEGIN_INSTALLMENT_NUMBER START_DATE_ACTIVE END_DATE_ACTIVE PHASE
LNS_RATE_SCHEDULES_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	TERM_ID END_INSTALLMENT_NUMBER START_DATE_ACTIVE END_DATE_ACTIVE PHASE

Columns

Name	Datatype	Length	Mandatory	Comments
RATE_ID	NUMBER	(15)	Yes	Rate identifier
TERM_ID	NUMBER	(15)	Yes	Term identifier (foreign key to LNS_TERMS.TERM_ID)
INDEX_RATE	NUMBER			Index rate percentage
SPREAD	NUMBER			Spread rate percentage
CURRENT_INTEREST_RATE	NUMBER			Current Interest Rate percentage
START_DATE_ACTIVE	DATE		Yes	Start Date Active
END_DATE_ACTIVE	DATE			End Date Active. This is the date upto which this rate is valid.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
OBJECT_VERSION_NUMBER	NUMBER		Yes	This column is used for locking purposes
INDEX_DATE	DATE			Index rate effective date
BEGIN_INSTALLMENT_NUMBER	NUMBER			Beginning installment number from which this rate is valid
END_INSTALLMENT_NUMBER	NUMBER			End installment number up to which this rate is valid
INTEREST_ONLY_FLAG	VARCHAR2	(1)		Specifies whether the installment is an interest only installment
PHASE	VARCHAR2	(30)		Phase interest applies to (OPEN, TERM)
FLOATING_FLAG	VARCHAR2	(1)		Flag to denote whether rate is floating or not

Query Text

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


SELECT RATE_ID
,      TERM_ID
,      INDEX_RATE
,      SPREAD
,      CURRENT_INTEREST_RATE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      INDEX_DATE
,      BEGIN_INSTALLMENT_NUMBER
,      END_INSTALLMENT_NUMBER
,      INTEREST_ONLY_FLAG
,      PHASE
,      FLOATING_FLAG
FROM LNS.LNS_RATE_SCHEDULES;

Dependencies

[top of page]

LNS.LNS_RATE_SCHEDULES does not reference any database object

LNS.LNS_RATE_SCHEDULES is referenced by following:

APPS: LNS_LOAN_DTLS_ALL_MV; LNS_RATE_SCHEDULES