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.

[Home] [Help]

VIEW: LNS.LNS_LOAN_PRODUCTS_ALL#

Source

View Text - Preformatted


select LOAN_PRODUCT_ID LOAN_PRODUCT_ID, LOAN_CLASS_CODE LOAN_CLASS_CODE, LOAN_TYPE_ID LOAN_TYPE_ID, LOAN_PRODUCT_NAME LOAN_PRODUCT_NAME, LOAN_PRODUCT_DESC LOAN_PRODUCT_DESC, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, STATUS STATUS, LOAN_TERM LOAN_TERM, LOAN_TERM_PERIOD LOAN_TERM_PERIOD, MAX_LOAN_TERM MAX_LOAN_TERM, MAX_LOAN_TERM_PERIOD MAX_LOAN_TERM_PERIOD, OPEN_LOAN_TERM OPEN_LOAN_TERM, OPEN_LOAN_TERM_PERIOD OPEN_LOAN_TERM_PERIOD, OPEN_MAX_LOAN_TERM OPEN_MAX_LOAN_TERM, OPEN_MAX_LOAN_TERM_PERIOD OPEN_MAX_LOAN_TERM_PERIOD, LOAN_CURRENCY LOAN_CURRENCY, REQUESTED_AMOUNT REQUESTED_AMOUNT, MAX_REQUESTED_AMOUNT MAX_REQUESTED_AMOUNT, INDEX_RATE_ID INDEX_RATE_ID, RATE_TYPE RATE_TYPE, SPREAD SPREAD, OPEN_SPREAD OPEN_SPREAD, FLOOR_RATE FLOOR_RATE, CEILING_RATE CEILING_RATE, OPEN_FLOOR_RATE OPEN_FLOOR_RATE, OPEN_CEILING_RATE OPEN_CEILING_RATE, INTEREST_COMPOUNDING_FREQ INTEREST_COMPOUNDING_FREQ, LOAN_PAYMENT_FREQUENCY LOAN_PAYMENT_FREQUENCY, AMORTIZATION_FREQUENCY AMORTIZATION_FREQUENCY, LOAN_SUBTYPE LOAN_SUBTYPE, COLLATERAL_PERCENT COLLATERAL_PERCENT, ALLOW_INTEREST_ONLY_FLAG ALLOW_INTEREST_ONLY_FLAG, REAMORTIZE_OVER_PAYMENT REAMORTIZE_OVER_PAYMENT, REAMORTIZE_UNDER_PAYMENT REAMORTIZE_UNDER_PAYMENT, ORG_ID ORG_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, RATE_CHANGE_FREQUENCY RATE_CHANGE_FREQUENCY, BDGT_REQ_FOR_APPR_FLAG BDGT_REQ_FOR_APPR_FLAG, LOAN_APPR_REQ_FLAG LOAN_APPR_REQ_FLAG, APPR_REQ_FOR_CNCL_FLAG APPR_REQ_FOR_CNCL_FLAG, PERCENT_INCREASE PERCENT_INCREASE, PERCENT_INCREASE_LIFE PERCENT_INCREASE_LIFE, FIRST_PERCENT_INCREASE FIRST_PERCENT_INCREASE, OPEN_PERCENT_INCREASE OPEN_PERCENT_INCREASE, OPEN_PERCENT_INCREASE_LIFE OPEN_PERCENT_INCREASE_LIFE, OPEN_FIRST_PERCENT_INCREASE OPEN_FIRST_PERCENT_INCREASE, CREDIT_REVIEW_TYPE CREDIT_REVIEW_TYPE, GUARANTOR_REVIEW_TYPE GUARANTOR_REVIEW_TYPE, PARTY_TYPE PARTY_TYPE, INTEREST_CALCULATION_METHOD INTEREST_CALCULATION_METHOD, DAY_COUNT_METHOD DAY_COUNT_METHOD, FORGIVENESS_FLAG FORGIVENESS_FLAG, FORGIVENESS_PERCENT FORGIVENESS_PERCENT, PAYMENT_CALC_METHOD PAYMENT_CALC_METHOD, PENAL_INT_RATE PENAL_INT_RATE, PENAL_INT_GRACE_DAYS PENAL_INT_GRACE_DAYS, CALC_ADD_INT_UNPAID_PRIN CALC_ADD_INT_UNPAID_PRIN, CALC_ADD_INT_UNPAID_INT CALC_ADD_INT_UNPAID_INT, PRINCIPAL_PAYMENT_FREQUENCY PRINCIPAL_PAYMENT_FREQUENCY, REAMORTIZE_ON_FUNDING REAMORTIZE_ON_FUNDING, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, CUSTOM_SCHED_DATA CUSTOM_SCHED_DATA, CUSTOM_CALC_METHOD CUSTOM_CALC_METHOD, CAPITALIZE_INT CAPITALIZE_INT, BILL_ON_APPR_AMOUNT_FLAG BILL_ON_APPR_AMOUNT_FLAG, CALC_EARLY_PAY_CR CALC_EARLY_PAY_CR, FLUCTUATE_EQ_PAY_AMOUNT FLUCTUATE_EQ_PAY_AMOUNT from "LNS"."LNS_LOAN_PRODUCTS_ALL"

View Text - HTML Formatted

SELECT LOAN_PRODUCT_ID LOAN_PRODUCT_ID
, LOAN_CLASS_CODE LOAN_CLASS_CODE
, LOAN_TYPE_ID LOAN_TYPE_ID
, LOAN_PRODUCT_NAME LOAN_PRODUCT_NAME
, LOAN_PRODUCT_DESC LOAN_PRODUCT_DESC
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, STATUS STATUS
, LOAN_TERM LOAN_TERM
, LOAN_TERM_PERIOD LOAN_TERM_PERIOD
, MAX_LOAN_TERM MAX_LOAN_TERM
, MAX_LOAN_TERM_PERIOD MAX_LOAN_TERM_PERIOD
, OPEN_LOAN_TERM OPEN_LOAN_TERM
, OPEN_LOAN_TERM_PERIOD OPEN_LOAN_TERM_PERIOD
, OPEN_MAX_LOAN_TERM OPEN_MAX_LOAN_TERM
, OPEN_MAX_LOAN_TERM_PERIOD OPEN_MAX_LOAN_TERM_PERIOD
, LOAN_CURRENCY LOAN_CURRENCY
, REQUESTED_AMOUNT REQUESTED_AMOUNT
, MAX_REQUESTED_AMOUNT MAX_REQUESTED_AMOUNT
, INDEX_RATE_ID INDEX_RATE_ID
, RATE_TYPE RATE_TYPE
, SPREAD SPREAD
, OPEN_SPREAD OPEN_SPREAD
, FLOOR_RATE FLOOR_RATE
, CEILING_RATE CEILING_RATE
, OPEN_FLOOR_RATE OPEN_FLOOR_RATE
, OPEN_CEILING_RATE OPEN_CEILING_RATE
, INTEREST_COMPOUNDING_FREQ INTEREST_COMPOUNDING_FREQ
, LOAN_PAYMENT_FREQUENCY LOAN_PAYMENT_FREQUENCY
, AMORTIZATION_FREQUENCY AMORTIZATION_FREQUENCY
, LOAN_SUBTYPE LOAN_SUBTYPE
, COLLATERAL_PERCENT COLLATERAL_PERCENT
, ALLOW_INTEREST_ONLY_FLAG ALLOW_INTEREST_ONLY_FLAG
, REAMORTIZE_OVER_PAYMENT REAMORTIZE_OVER_PAYMENT
, REAMORTIZE_UNDER_PAYMENT REAMORTIZE_UNDER_PAYMENT
, ORG_ID ORG_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, RATE_CHANGE_FREQUENCY RATE_CHANGE_FREQUENCY
, BDGT_REQ_FOR_APPR_FLAG BDGT_REQ_FOR_APPR_FLAG
, LOAN_APPR_REQ_FLAG LOAN_APPR_REQ_FLAG
, APPR_REQ_FOR_CNCL_FLAG APPR_REQ_FOR_CNCL_FLAG
, PERCENT_INCREASE PERCENT_INCREASE
, PERCENT_INCREASE_LIFE PERCENT_INCREASE_LIFE
, FIRST_PERCENT_INCREASE FIRST_PERCENT_INCREASE
, OPEN_PERCENT_INCREASE OPEN_PERCENT_INCREASE
, OPEN_PERCENT_INCREASE_LIFE OPEN_PERCENT_INCREASE_LIFE
, OPEN_FIRST_PERCENT_INCREASE OPEN_FIRST_PERCENT_INCREASE
, CREDIT_REVIEW_TYPE CREDIT_REVIEW_TYPE
, GUARANTOR_REVIEW_TYPE GUARANTOR_REVIEW_TYPE
, PARTY_TYPE PARTY_TYPE
, INTEREST_CALCULATION_METHOD INTEREST_CALCULATION_METHOD
, DAY_COUNT_METHOD DAY_COUNT_METHOD
, FORGIVENESS_FLAG FORGIVENESS_FLAG
, FORGIVENESS_PERCENT FORGIVENESS_PERCENT
, PAYMENT_CALC_METHOD PAYMENT_CALC_METHOD
, PENAL_INT_RATE PENAL_INT_RATE
, PENAL_INT_GRACE_DAYS PENAL_INT_GRACE_DAYS
, CALC_ADD_INT_UNPAID_PRIN CALC_ADD_INT_UNPAID_PRIN
, CALC_ADD_INT_UNPAID_INT CALC_ADD_INT_UNPAID_INT
, PRINCIPAL_PAYMENT_FREQUENCY PRINCIPAL_PAYMENT_FREQUENCY
, REAMORTIZE_ON_FUNDING REAMORTIZE_ON_FUNDING
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, CUSTOM_SCHED_DATA CUSTOM_SCHED_DATA
, CUSTOM_CALC_METHOD CUSTOM_CALC_METHOD
, CAPITALIZE_INT CAPITALIZE_INT
, BILL_ON_APPR_AMOUNT_FLAG BILL_ON_APPR_AMOUNT_FLAG
, CALC_EARLY_PAY_CR CALC_EARLY_PAY_CR
, FLUCTUATE_EQ_PAY_AMOUNT FLUCTUATE_EQ_PAY_AMOUNT
FROM "LNS"."LNS_LOAN_PRODUCTS_ALL"