[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 |
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 |
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;
LNS.LNS_LOAN_PRODUCTS_ALL does not reference any database object
LNS.LNS_LOAN_PRODUCTS_ALL is referenced by following:
|
|
|