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: APPS.LNS_LOAN_PRODUCTS_ALL_VL

Object Details

Object Name:	LNS_LOAN_PRODUCTS_ALL_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	LNS.LNS_LOAN_PRODUCTS_ALL_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

Loan Products Translation View for table LNS_LOAN_PRODUCTS_ALL

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row id of the table
LOAN_PRODUCT_ID	NUMBER	(15)	Yes	Identifies the Loan Product
LOAN_CLASS_CODE	VARCHAR2	(30)		Loan class code. Lookup type is LOAN_CLASS
LOAN_TYPE_ID	NUMBER	(15)	Yes	FK to LNS_LOAN_TYPES
LOAN_PRODUCT_NAME	VARCHAR2	(80)	Yes	Loan product name
LOAN_PRODUCT_DESC	VARCHAR2	(250)		Description of the loan product
START_DATE_ACTIVE	DATE			Start date of loan product
END_DATE_ACTIVE	DATE			End date of loan product
STATUS	VARCHAR2	(30)		Loan product setup status code. Lookup type is LNS_SETUP_STATUS
LOAN_TERM	NUMBER			Loan term range from. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM
LOAN_TERM_PERIOD	VARCHAR2	(30)		Period of loan term range from. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM_PERIOD
MAX_LOAN_TERM	NUMBER			Loan term range to. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM
MAX_LOAN_TERM_PERIOD	VARCHAR2	(30)		Period of loan term range to. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TERM_PERIOD
OPEN_LOAN_TERM	NUMBER			Open Loan Term
OPEN_LOAN_TERM_PERIOD	VARCHAR2	(30)		Open Loan Term Period
OPEN_MAX_LOAN_TERM	NUMBER			Open Max Loan Term
OPEN_MAX_LOAN_TERM_PERIOD	VARCHAR2	(30)		Open Max Loan Term Period
LOAN_CURRENCY	VARCHAR2	(30)		Loan currency code (foreign key to FND_CURRENCIES.CURRENCY_CODE). This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_CURRENCY
REQUESTED_AMOUNT	NUMBER			Requested amount range from. This column defaults the value for LNS_LOAN_HEADERS_ALL.REQUESTED_AMOUNT
MAX_REQUESTED_AMOUNT	NUMBER			Requested amount range to. This column defaults the value for LNS_LOAN_HEADERS_ALL.REQUESTED_AMOUNT
INDEX_RATE_ID	NUMBER	(15)		Interest rate index (foreign key to LNS_INT_RATE_HEADERS.INTEREST_RATE_ID). This column defaults the value for is LNS_TERMS.INDEX_RATE_ID
RATE_TYPE	VARCHAR2	(30)		Loan rate type code. Lookup type is RATE_TYPE. This column defaults the value for LNS_TERMS.RATE_TYPE
SPREAD	NUMBER			Spread percentage rate. This column defaults the value for LNS_RATE_SCHEDULES.SPREAD
OPEN_SPREAD	NUMBER			Spread during open phase of loan product
FLOOR_RATE	NUMBER			Floor percentage rate. This column defaults the value for LNS_TERMS.FLOOR_RATE
CEILING_RATE	NUMBER			Ceiling percentage rate. This column defaults the value for LNS_TERMS.CEILING_RATE
OPEN_FLOOR_RATE	NUMBER			Open Phase Floor Rate
OPEN_CEILING_RATE	NUMBER			Open Phase Ceiling Rate
INTEREST_COMPOUNDING_FREQ	VARCHAR2	(30)		Interest accrual frequency code. Lookup type is XXXXXXXX. This column defaults the value for LNS_TERMS.INTEREST_COMPOUNDING_FREQ
LOAN_PAYMENT_FREQUENCY	VARCHAR2	(30)		Loan payment frequency code. Lookup type is FREQUENCY. This column defaults the value for LNS_TERMS.LOAN_PAYMENT_FREQUENCY
AMORTIZATION_FREQUENCY	VARCHAR2	(30)		Amortization Frequency
LOAN_SUBTYPE	VARCHAR2	(30)		Loan subtype code. Lookup type is LOAN_SUBTYPE. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_SUBTYPE
COLLATERAL_PERCENT	NUMBER			Loan to value ratio. This column defaults the value for LNS_LOAN_HEADERS_ALL.COLLATERAL_PERCENT
ALLOW_INTEREST_ONLY_FLAG	VARCHAR2	(1)		Flag to indicate if interest only payments are allowed. This column defaults the value for LNS_RATE_SCHEDULES.INTEREST_ONLY_FLAG
REAMORTIZE_OVER_PAYMENT	VARCHAR2	(1)		Flag to indicate if reamortize on overpayments. This column defaults the value for is LNS_TERMS.REAMORTIZE_OVER_PAYMENT
REAMORTIZE_UNDER_PAYMENT	VARCHAR2	(30)		Reamortize on underpayment
ORG_ID	NUMBER	(15)	Yes	Organization identifier (foreign key to HR_OPERATING_UNITS.ORGANIZATION_ID). This column defaults the value for LNS_LOAN_HEADERS_ALL.ORG_ID
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
OBJECT_VERSION_NUMBER	NUMBER		Yes	This column is used for locking purposes
LEGAL_ENTITY_ID	NUMBER	(15)		Legal Entity ID
RATE_CHANGE_FREQUENCY	VARCHAR2	(30)		Rate Change Frequency
BDGT_REQ_FOR_APPR_FLAG	VARCHAR2	(1)		Budget Required for Loan Approval
LOAN_APPR_REQ_FLAG	VARCHAR2	(1)		Loan Approval Required
APPR_REQ_FOR_CNCL_FLAG	VARCHAR2	(1)		Approval Required for Cancellation
PERCENT_INCREASE	NUMBER			Maximum Rate Percentage Increase
PERCENT_INCREASE_LIFE	NUMBER			Maximum Rate Percentage Increase life
FIRST_PERCENT_INCREASE	NUMBER			First Percentage Increase Max/Min
OPEN_PERCENT_INCREASE	NUMBER			Percentage Increase Max/Min
OPEN_PERCENT_INCREASE_LIFE	NUMBER			Open Percentage Increase Max/Min Life
OPEN_FIRST_PERCENT_INCREASE	NUMBER			Open First Percentage Increase Max/Min
CREDIT_REVIEW_TYPE	VARCHAR2	(30)		AR_CMGT_CHECK_LISTS.REVIEW_TYPE
GUARANTOR_REVIEW_TYPE	VARCHAR2	(30)		AR_CMGT_CHECK_LISTS.REVIEW_TYPE
PARTY_TYPE	VARCHAR2	(30)		This column will store either ORGANIZATION or PERSON and denotes whether its a Business or Consumer product.
INTEREST_CALCULATION_METHOD	VARCHAR2	(30)		Loan interest calculation method code. Lookup type is INTEREST_CALCULATION_METHOD. This column defaults the value for LNS_TERMS.CALCULATION_METHODD
DAY_COUNT_METHOD	VARCHAR2	(30)		Loan days formula code. Lookup type is DAY_COUNT_METHOD. This column defaults the value for LNS_TERMS.DAY_COUNT_METHOD
FORGIVENESS_FLAG	VARCHAR2	(1)		Identifies whether the loan is enabled for forgiveness
FORGIVENESS_PERCENT	NUMBER			This column defines the required forgiveness loanEMIPrincipal-to-value ratio for forgiveness enabled loan as a percentage of the loanEMI Principal
PAYMENT_CALC_METHOD	VARCHAR2	(30)		Payment calculation method
PENAL_INT_RATE	NUMBER			Penal Interest rate
PENAL_INT_GRACE_DAYS	NUMBER			Penal interest grace days
CALC_ADD_INT_UNPAID_PRIN	VARCHAR2	(1)		Calculate additional interest on unpaid principal
CALC_ADD_INT_UNPAID_INT	VARCHAR2	(1)		Calculate additional interest on unpaid interest
PRINCIPAL_PAYMENT_FREQUENCY	VARCHAR2	(30)		Principal payment frequency
REAMORTIZE_ON_FUNDING	VARCHAR2	(30)		Reamortize On Funding
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield segment
CUSTOM_SCHED_DATA	CLOB	(4000)		Custom Schedule Data
CUSTOM_CALC_METHOD	VARCHAR2	(30)		Custom Calculation Method
CAPITALIZE_INT	VARCHAR2	(1)		Capitalize Interest
BILL_ON_APPR_AMOUNT_FLAG	VARCHAR2	(1)		Activate and Bill Based On Approved Amounts
CALC_EARLY_PAY_CR	VARCHAR2	(1)		Issue Interest Credit On Early Payments
FLUCTUATE_EQ_PAY_AMOUNT	VARCHAR2	(1)		Fluctuate Payment Due to Additional Interest

Query Text

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


SELECT ROW_ID
,      LOAN_PRODUCT_ID
,      LOAN_CLASS_CODE
,      LOAN_TYPE_ID
,      LOAN_PRODUCT_NAME
,      LOAN_PRODUCT_DESC
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      LOAN_TERM
,      LOAN_TERM_PERIOD
,      MAX_LOAN_TERM
,      MAX_LOAN_TERM_PERIOD
,      OPEN_LOAN_TERM
,      OPEN_LOAN_TERM_PERIOD
,      OPEN_MAX_LOAN_TERM
,      OPEN_MAX_LOAN_TERM_PERIOD
,      LOAN_CURRENCY
,      REQUESTED_AMOUNT
,      MAX_REQUESTED_AMOUNT
,      INDEX_RATE_ID
,      RATE_TYPE
,      SPREAD
,      OPEN_SPREAD
,      FLOOR_RATE
,      CEILING_RATE
,      OPEN_FLOOR_RATE
,      OPEN_CEILING_RATE
,      INTEREST_COMPOUNDING_FREQ
,      LOAN_PAYMENT_FREQUENCY
,      AMORTIZATION_FREQUENCY
,      LOAN_SUBTYPE
,      COLLATERAL_PERCENT
,      ALLOW_INTEREST_ONLY_FLAG
,      REAMORTIZE_OVER_PAYMENT
,      REAMORTIZE_UNDER_PAYMENT
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      LEGAL_ENTITY_ID
,      RATE_CHANGE_FREQUENCY
,      BDGT_REQ_FOR_APPR_FLAG
,      LOAN_APPR_REQ_FLAG
,      APPR_REQ_FOR_CNCL_FLAG
,      PERCENT_INCREASE
,      PERCENT_INCREASE_LIFE
,      FIRST_PERCENT_INCREASE
,      OPEN_PERCENT_INCREASE
,      OPEN_PERCENT_INCREASE_LIFE
,      OPEN_FIRST_PERCENT_INCREASE
,      CREDIT_REVIEW_TYPE
,      GUARANTOR_REVIEW_TYPE
,      PARTY_TYPE
,      INTEREST_CALCULATION_METHOD
,      DAY_COUNT_METHOD
,      FORGIVENESS_FLAG
,      FORGIVENESS_PERCENT
,      PAYMENT_CALC_METHOD
,      PENAL_INT_RATE
,      PENAL_INT_GRACE_DAYS
,      CALC_ADD_INT_UNPAID_PRIN
,      CALC_ADD_INT_UNPAID_INT
,      PRINCIPAL_PAYMENT_FREQUENCY
,      REAMORTIZE_ON_FUNDING
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CUSTOM_SCHED_DATA
,      CUSTOM_CALC_METHOD
,      CAPITALIZE_INT
,      BILL_ON_APPR_AMOUNT_FLAG
,      CALC_EARLY_PAY_CR
,      FLUCTUATE_EQ_PAY_AMOUNT
FROM APPS.LNS_LOAN_PRODUCTS_ALL_VL;

Dependencies

[top of page]

APPS.LNS_LOAN_PRODUCTS_ALL_VL references the following:

APPS: LNS_LOAN_PRODUCTS_ALL; LNS_LOAN_PRODUCTS_ALL_TL

APPS.LNS_LOAN_PRODUCTS_ALL_VL is referenced by following:

APPS: LNS_LOAN_LINE_PUB - show dependent code; LNS_REP_UTILS - show dependent code; LNS_WORK_FLOW - show dependent code