VIEW: APPS.LNS_LOAN_PRODUCTS_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 FROM LNS_LOAN_PRODUCTS 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
FROM LNS_LOAN_PRODUCTS B
, LNS_LOAN_PRODUCTS_ALL_TL T
WHERE B.LOAN_PRODUCT_ID = T.LOAN_PRODUCT_ID
AND T.LANGUAGE = USERENV('LANG')