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]

VIEW: LNS.LNS_TERMS#

Object Details

Object Name:	LNS_TERMS#
Object Type:	VIEW
Owner:	LNS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
TERM_ID	NUMBER	(15)	Yes
LOAN_ID	NUMBER	(15)	Yes
DAY_COUNT_METHOD	VARCHAR2	(50)	Yes
BASED_ON_BALANCE	VARCHAR2	(30)	Yes
FIRST_RATE_CHANGE_DATE	DATE
NEXT_RATE_CHANGE_DATE	DATE
PERCENT_INCREASE	NUMBER
PERCENT_INCREASE_TERM	VARCHAR2	(30)
PERCENT_INCREASE_LIFE	NUMBER
FIRST_PERCENT_INCREASE	NUMBER
OPEN_PERCENT_INCREASE	NUMBER
OPEN_PERCENT_INCREASE_LIFE	NUMBER
OPEN_FIRST_PERCENT_INCREASE	NUMBER
PAYMENT_APPLICATION_ORDER	VARCHAR2	(30)
PMT_APPL_ORDER_SCOPE	VARCHAR2	(30)
PREPAY_PENALTY_FLAG	VARCHAR2	(1)
PREPAY_PENALTY_DATE	DATE
DELINQUENCY_THRESHOLD_NUMBER	NUMBER
DELINQUENCY_THRESHOLD_AMOUNT	NUMBER
CALCULATION_METHOD	VARCHAR2	(30)	Yes
REAMORTIZE_OVER_PAYMENT	VARCHAR2	(1)
REAMORTIZE_UNDER_PAYMENT	VARCHAR2	(1)
REAMORTIZE_WITH_INTEREST	VARCHAR2	(1)
INTEREST_COMPOUNDING_FREQ	VARCHAR2	(30)	Yes
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER		Yes
AMORTIZATION_FREQUENCY	VARCHAR2	(30)	Yes
NUMBER_GRACE_DAYS	NUMBER
RATE_TYPE	VARCHAR2	(30)
CEILING_RATE	NUMBER
FLOOR_RATE	NUMBER
OPEN_CEILING_RATE	NUMBER
OPEN_FLOOR_RATE	NUMBER
INDEX_RATE_ID	NUMBER	(15)
INDEX_NAME	VARCHAR2	(50)
LOAN_PAYMENT_FREQUENCY	VARCHAR2	(30)
ADJUSTMENT_FREQUENCY	NUMBER
ADJUSTMENT_FREQUENCY_TYPE	VARCHAR2	(30)
FIXED_RATE_PERIOD	NUMBER
FIXED_RATE_PERIOD_TYPE	VARCHAR2	(30)
FIRST_PAYMENT_DATE	DATE
NEXT_PAYMENT_DUE_DATE	DATE
OPEN_FIRST_PAYMENT_DATE	DATE
OPEN_PAYMENT_FREQUENCY	VARCHAR2	(30)
OPEN_NEXT_PAYMENT_DATE	DATE
LOCK_IN_DATE	DATE
LOCK_TO_DATE	DATE
RATE_CHANGE_FREQUENCY	VARCHAR2	(30)
OPEN_INDEX_DATE	DATE
TERM_INDEX_DATE	DATE
OPEN_PROJECTED_RATE	NUMBER
TERM_PROJECTED_RATE	NUMBER
PAYMENT_CALC_METHOD	VARCHAR2	(30)
ORIG_PAY_CALC_METHOD	VARCHAR2	(30)
CUSTOM_CALC_METHOD	VARCHAR2	(30)
PRIN_FIRST_PAY_DATE	DATE
PRIN_PAYMENT_FREQUENCY	VARCHAR2	(30)
PENAL_INT_RATE	NUMBER
PENAL_INT_GRACE_DAYS	NUMBER
CALC_ADD_INT_UNPAID_PRIN	VARCHAR2	(1)
CALC_ADD_INT_UNPAID_INT	VARCHAR2	(1)
REAMORTIZE_ON_FUNDING	VARCHAR2	(30)
DEFAULT_THRESHOLD_AMOUNT	NUMBER
CUSTOM_SCHED_DESC	VARCHAR2	(100)
CAPITALIZE_INT	VARCHAR2	(1)
CALC_EARLY_PAY_CR	VARCHAR2	(1)
FLUCTUATE_EQ_PAY_AMOUNT	VARCHAR2	(1)

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
,      CALC_ADD_INT_UNPAID_PRIN
,      CALC_ADD_INT_UNPAID_INT
,      REAMORTIZE_ON_FUNDING
,      DEFAULT_THRESHOLD_AMOUNT
,      CUSTOM_SCHED_DESC
,      CAPITALIZE_INT
,      CALC_EARLY_PAY_CR
,      FLUCTUATE_EQ_PAY_AMOUNT
FROM LNS.LNS_TERMS#;

Dependencies

[top of page]

LNS.LNS_TERMS# references the following:

LNS: LNS_TERMS

LNS.LNS_TERMS# is referenced by following:

APPS: LNS_TERMS