VIEW: APPS.LNS_LOAN_PRODUCTS_ALL_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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