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_VL

Object Details

Object Name:	LNS_LOAN_PRODUCTS_VL
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

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

Loan Products Setup Translation View for a MultiOrg Context OrgId

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
LOAN_PRODUCT_ID	NUMBER	(15)	Yes	Identifies the Loan Product
LOAN_CLASS_CODE	VARCHAR2	(30)
LOAN_TYPE_ID	NUMBER	(15)	Yes
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_METHOD
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)
FORGIVENESS_PERCENT	NUMBER

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
FROM APPS.LNS_LOAN_PRODUCTS_VL;

Dependencies

[top of page]

APPS.LNS_LOAN_PRODUCTS_VL references the following:

APPS: LNS_LOAN_PRODUCTS; LNS_LOAN_PRODUCTS_ALL_TL

APPS.LNS_LOAN_PRODUCTS_VL is referenced by following:

APPS: LNS_APPL_ENGINE_PUB - show dependent code