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_TERMS

Object Details

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

Loans Terms Table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
LNS_TERMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TERM_ID
LNS_TERMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOAN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TERM_ID	NUMBER	(15)	Yes	Term identifier
LOAN_ID	NUMBER	(15)	Yes	Loan identifier (foreign key to LNS_LOAN_HEADERS_ALL.LOAN_ID)
DAY_COUNT_METHOD	VARCHAR2	(50)	Yes	Day Count Method. Lookup type is DAY_COUNT_METHOD
BASED_ON_BALANCE	VARCHAR2	(30)	Yes	Based on Balance. Lookup type is BASED_ON_BALANCE
FIRST_RATE_CHANGE_DATE	DATE			First Rate Change Date
NEXT_RATE_CHANGE_DATE	DATE			Next Rate Change Date
PERCENT_INCREASE	NUMBER			Maximum Rate Increase Percentage Term
PERCENT_INCREASE_TERM	VARCHAR2	(30)		Maximum Rate Increase Percentage Term Period. Lookup type is FREQUENCY
PERCENT_INCREASE_LIFE	NUMBER			Max / Min Percent Increase Life
FIRST_PERCENT_INCREASE	NUMBER			First Max / Min Percent Increase
OPEN_PERCENT_INCREASE	NUMBER			Open Max / Min Percent Increase
OPEN_PERCENT_INCREASE_LIFE	NUMBER			Open Max / Min Percent Increase Life
OPEN_FIRST_PERCENT_INCREASE	NUMBER			First Open Max / Min Percent Increase
PAYMENT_APPLICATION_ORDER	VARCHAR2	(30)		Payment Application Order. This column stores the concatenation of the lookup codes from the lookup type PAYMENT_APPLICATION_TYPE . For example, if the payment application order is Interest first, then Principal and then Fees, this column will have the value INT_PRIN_FEE
PMT_APPL_ORDER_SCOPE	VARCHAR2	(30)		Payment Application Order Scope
PREPAY_PENALTY_FLAG	VARCHAR2	(1)		Prepayment Penalty Flag
PREPAY_PENALTY_DATE	DATE			Prepayment Penalty Date
DELINQUENCY_THRESHOLD_NUMBER	NUMBER			Delinquency Threshold Number. Denotes the limit on the Number of Consecutive Missed Payments before delinquency.
DELINQUENCY_THRESHOLD_AMOUNT	NUMBER			Delinquency Threshold Amount. Denotes the limit on the Amount Past Due before delinquency.
CALCULATION_METHOD	VARCHAR2	(30)	Yes	Interest Calculation Method Code. Denotes Simple or Compound interest. Lookup type is INTEREST_CALCULATION_METHOD
REAMORTIZE_OVER_PAYMENT	VARCHAR2	(1)		Flag to denote if overpayments result in reamortization of the loan
REAMORTIZE_UNDER_PAYMENT	VARCHAR2	(1)		Flag to denote if underpayments result in reamortization of the loan
REAMORTIZE_WITH_INTEREST	VARCHAR2	(1)		Flag to indicate if interest is included in reamortization
INTEREST_COMPOUNDING_FREQ	VARCHAR2	(30)	Yes	Interest Compunding Frequency. Lookup type is FREQUENCY
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
AMORTIZATION_FREQUENCY	VARCHAR2	(30)	Yes	Amortization Frequency
NUMBER_GRACE_DAYS	NUMBER			Number of Grace Days
RATE_TYPE	VARCHAR2	(30)		Rate Type code. Denotes if Fixed or Variable. Lookup type is RATE_TYPE
CEILING_RATE	NUMBER			Ceiling rate percentage
FLOOR_RATE	NUMBER			Floor rate percentage
OPEN_CEILING_RATE	NUMBER			Open Phase Ceiling Rate
OPEN_FLOOR_RATE	NUMBER			Open Phase Floor Rate
INDEX_RATE_ID	NUMBER	(15)		FK to LNS_INT_RATE_HEADERS.INDEX_RATE_ID
INDEX_NAME	VARCHAR2	(50)		Index Name code. Lookup type is INDEX_TYPE
LOAN_PAYMENT_FREQUENCY	VARCHAR2	(30)		Loan Payment Frequency. Lookup type is FREQUENCY
ADJUSTMENT_FREQUENCY	NUMBER			Adjustment Frequency.
ADJUSTMENT_FREQUENCY_TYPE	VARCHAR2	(30)		Adjustment Frequency Period type code. Lookup type is PERIOD
FIXED_RATE_PERIOD	NUMBER			Fixed Rate Period
FIXED_RATE_PERIOD_TYPE	VARCHAR2	(30)		Fixed Rate Period type code. Lookup type is PERIOD
FIRST_PAYMENT_DATE	DATE			First Payment Date
NEXT_PAYMENT_DUE_DATE	DATE			Next Payment Due Date
OPEN_FIRST_PAYMENT_DATE	DATE			First Payment Date of the open phase of the loan
OPEN_PAYMENT_FREQUENCY	VARCHAR2	(30)		Payment Frequency of the open phase
OPEN_NEXT_PAYMENT_DATE	DATE			Next payment date of the open phase
LOCK_IN_DATE	DATE			Rate Lock In Date
LOCK_TO_DATE	DATE			Rate Lock to Date
RATE_CHANGE_FREQUENCY	VARCHAR2	(30)		Rate Change Frequency
OPEN_INDEX_DATE	DATE			Open Phase Rate Index Date
TERM_INDEX_DATE	DATE			Term Phase Rate Index Date
OPEN_PROJECTED_RATE	NUMBER			Rate percentage used to calculate future interest for the Open phase of the loan
TERM_PROJECTED_RATE	NUMBER			Rate percentage used to calculate future interest for the Term phase of the loan
PAYMENT_CALC_METHOD	VARCHAR2	(30)		Payment Calculation Method used in calculation of the Amortization schedule
ORIG_PAY_CALC_METHOD	VARCHAR2	(30)		This Calc method implies the last used paymentCalculationMethod for that loan before customized.
CUSTOM_CALC_METHOD	VARCHAR2	(30)		This method is used to calculate the customized loans.
PRIN_FIRST_PAY_DATE	DATE			For a Separate Schedule loan, this column holds the first Principal payment date.
PRIN_PAYMENT_FREQUENCY	VARCHAR2	(30)		For a Separate schedule loan, this field holds the Principal payment frequency.
PENAL_INT_RATE	NUMBER			Penal Interest Rate
PENAL_INT_GRACE_DAYS	NUMBER			Penal Interest Grace Days

Query Text

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


SELECT TERM_ID
,      LOAN_ID
,      DAY_COUNT_METHOD
,      BASED_ON_BALANCE
,      FIRST_RATE_CHANGE_DATE
,      NEXT_RATE_CHANGE_DATE
,      PERCENT_INCREASE
,      PERCENT_INCREASE_TERM
,      PERCENT_INCREASE_LIFE
,      FIRST_PERCENT_INCREASE
,      OPEN_PERCENT_INCREASE
,      OPEN_PERCENT_INCREASE_LIFE
,      OPEN_FIRST_PERCENT_INCREASE
,      PAYMENT_APPLICATION_ORDER
,      PMT_APPL_ORDER_SCOPE
,      PREPAY_PENALTY_FLAG
,      PREPAY_PENALTY_DATE
,      DELINQUENCY_THRESHOLD_NUMBER
,      DELINQUENCY_THRESHOLD_AMOUNT
,      CALCULATION_METHOD
,      REAMORTIZE_OVER_PAYMENT
,      REAMORTIZE_UNDER_PAYMENT
,      REAMORTIZE_WITH_INTEREST
,      INTEREST_COMPOUNDING_FREQ
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      AMORTIZATION_FREQUENCY
,      NUMBER_GRACE_DAYS
,      RATE_TYPE
,      CEILING_RATE
,      FLOOR_RATE
,      OPEN_CEILING_RATE
,      OPEN_FLOOR_RATE
,      INDEX_RATE_ID
,      INDEX_NAME
,      LOAN_PAYMENT_FREQUENCY
,      ADJUSTMENT_FREQUENCY
,      ADJUSTMENT_FREQUENCY_TYPE
,      FIXED_RATE_PERIOD
,      FIXED_RATE_PERIOD_TYPE
,      FIRST_PAYMENT_DATE
,      NEXT_PAYMENT_DUE_DATE
,      OPEN_FIRST_PAYMENT_DATE
,      OPEN_PAYMENT_FREQUENCY
,      OPEN_NEXT_PAYMENT_DATE
,      LOCK_IN_DATE
,      LOCK_TO_DATE
,      RATE_CHANGE_FREQUENCY
,      OPEN_INDEX_DATE
,      TERM_INDEX_DATE
,      OPEN_PROJECTED_RATE
,      TERM_PROJECTED_RATE
,      PAYMENT_CALC_METHOD
,      ORIG_PAY_CALC_METHOD
,      CUSTOM_CALC_METHOD
,      PRIN_FIRST_PAY_DATE
,      PRIN_PAYMENT_FREQUENCY
,      PENAL_INT_RATE
,      PENAL_INT_GRACE_DAYS
FROM LNS.LNS_TERMS;

Dependencies

[top of page]

LNS.LNS_TERMS does not reference any database object

LNS.LNS_TERMS is referenced by following:

APPS: LNS_LOAN_DTLS_ALL_MV; LNS_TERMS