Product: | LNS - Loans |
---|---|
Description: | |
Implementation/DBA Data: | APPS.LNS_LOAN_PRODUCTS_ALL_VL |
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
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')