[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| 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
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| LNS_LOAN_PRODUCTS_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 LOAN_PRODUCT_ID
|
| SYS_IL0000406354C00089$$ | LOB | UNIQUE |
APPS_TS_TX_DATA
|
| 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 | ||
| 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 |
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
, 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 LNS.LNS_LOAN_PRODUCTS_ALL;
LNS.LNS_LOAN_PRODUCTS_ALL does not reference any database object
LNS.LNS_LOAN_PRODUCTS_ALL is referenced by following:
LNS
LNS_LOAN_PRODUCTS_ALL#
|
|
|
|