Results for “open_loan_term”

45 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

LNS_LOAN_PRODUCTS_ALL_VL is a translation-enabled (VL) view owned by the APPS schema in Oracle E-Business Suite, belonging to the LNS – Loans product family (part of Oracle Treasury / ETRM). It presents loan product definitions — the configurable templates that govern term, interest, amortization, and approval behavior for loan instruments — in a form that supports multi-language display. Its "VL" designation indicates it joins the base (non-translated) entity table to its corresponding translation table, selecting the appropriate translated name and description based on the session language. The view is marked VALID and is the canonical read interface for loan product setup data, making it the primary object referenced by forms, concurrent programs, and downstream reporting or integration logic that must present product information in the user's current language.

Underlying Base Objects

The view is defined over two documented base objects, both accessed via synonyms:

The view joins these tables on LOAN_PRODUCT_ID and, in the typical EBS TL pattern, filters the translation table by the session language (LANGUAGE = USERENV('LANG')). All columns are prefixed from the base table B, with the exception of the two translated text columns sourced from T. The view also exposes B.ROWID as ROW_ID, which supports forms-based DML on the underlying base row.

Key Columns

The view exposes a comprehensive attribute set for each loan product. Core identifying and descriptive columns include LOAN_PRODUCT_ID, LOAN_CLASS_CODE, LOAN_TYPE_ID, LOAN_PRODUCT_NAME, LOAN_PRODUCT_DESC, and STATUS. Temporal and term attributes include START_DATE_ACTIVE, END_DATE_ACTIVE, LOAN_TERM and LOAN_TERM_PERIOD, MAX_LOAN_TERM, OPEN_LOAN_TERM, and their period qualifiers. Interest-related columns encompass INDEX_RATE_ID, RATE_TYPE, SPREAD, FLOOR_RATE, CEILING_RATE, INTEREST_COMPOUNDING_FREQ, RATE_CHANGE_FREQUENCY, INTEREST_CALCULATION_METHOD, DAY_COUNT_METHOD, and PENAL_INT_RATE with PENAL_INT_GRACE_DAYS. Repayment behavior is governed by LOAN_PAYMENT_FREQUENCY, PRINCIPAL_PAYMENT_FREQUENCY, AMORTIZATION_FREQUENCY, ALLOW_INTEREST_ONLY_FLAG, REMORTIZE flags (REAMORTIZE_OVER_PAYMENT, REAMORTIZE_UNDER_PAYMENT, REAMORTIZE_ON_FUNDING), and payment calculation columns. Governance and credit attributes include LOAN_APPR_REQ_FLAG, BDGT_REQ_FOR_APPR_FLAG, APPR_REQ_FOR_CNCL_FLAG, CREDIT_REVIEW_TYPE, GUARANTOR_REVIEW_TYPE, PARTY_TYPE, and FORGIVENESS_FLAG. Additional configuration is stored in ATTRIBUTE1 through ATTRIBUTE20, CUSTOM_SCHED_DATA, and CUSTOM_CALC_METH. Multi-org and audit columns ORG_ID, LEGAL_ENTITY_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER support security and concurrency control.

Common Use Cases and Queries

Typical applications include product setup inquiries, loan origination validation, reporting on active product offerings, and integration with external treasury or banking systems. The translated name columns make the view suitable for user-facing lists and LOVs. A representative query returns active products for an operating unit:

  • List active products: SELECT loan_product_id, loan_class_code, loan_product_name, status FROM lns_loan_products_all_vl WHERE status = 'ACTIVE' AND org_id = :p_org_id;
  • Interest configuration: SELECT loan_product_name, rate_type, spread, floor_rate, ceiling_rate FROM lns_loan_products_all_vl WHERE loan_type_id = :p_loan_type_id;
  • Approval requirements: SELECT loan_product_name, loan_appr_req_flag, bdgt_req_for_appr_flag FROM lns_loan_products_all_vl WHERE loan_appr_req_flag = 'Y';

Because the view is built on the TL architecture, queries automatically return the product name and description in the session language, eliminating the need for explicit translation joins in downstream SQL.