[Home] [Help] [Dependency Information]
Object Name: | LNS_LOAN_PRODUCTS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | LNS.LNS_LOAN_PRODUCTS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
Loan Products Translation View for table LNS_LOAN_PRODUCTS
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 |
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_VL;
|
|
|