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_LOAN_PRODUCTS_ALL

Object Details

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

Loan Product Setup Table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
LNS_LOAN_PRODUCTS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOAN_PRODUCT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LOAN_PRODUCT_ID	NUMBER	(15)	Yes	Loan product identifier. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_PRODUCT_ID
LOAN_CLASS_CODE	VARCHAR2	(30)		Loan class code. Lookup type is LOAN_CLASS. This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE
LOAN_TYPE_ID	NUMBER	(15)	Yes	Loan type id (foreign key to LNS_LOAN_TYPES.LOAN_TYPE_ID). This column defaults the value for LNS_LOAN_HEADERS_ALL.LOAN_TYPE_ID
LOAN_PRODUCT_NAME	VARCHAR2	(80)		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 XXXXXXXX
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)		This column stores the Interest Calculation Method of the loan.
DAY_COUNT_METHOD	VARCHAR2	(30)		This column stores the Day Count Method
FORGIVENESS_FLAG	VARCHAR2	(1)		Identifies whether the loan is enabled for forgiveness
FORGIVENESS_PERCENT	NUMBER			This column defines the required forgiveness loanEMI-to-value ratio for forgiveness enabled loan as a percentage of the loanEMI

Query Text

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


SELECT 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 LNS.LNS_LOAN_PRODUCTS_ALL;

Dependencies

[top of page]

LNS.LNS_LOAN_PRODUCTS_ALL does not reference any database object

LNS.LNS_LOAN_PRODUCTS_ALL is referenced by following:

APPS: LNS_LOAN_DTLS_ALL_MV; LNS_LOAN_PRODUCTS; LNS_LOAN_PRODUCTS_ALL