Search Results reference_description




Overview
Explore in AI Chat

Overview

LNS_LOAN_SUMMARY_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the LNS (Loans) product family. Its documented purpose is to present consolidated loan summary information in a single, denormalized result set. Rather than requiring report authors and integrators to join the loan header table to multiple lookup, currency, resource, and party tables, the view encapsulates those joins and exposes a flat structure of loan attributes alongside their decoded meanings.

The view is defined with status VALID and is available in both EBS 12.1.1 and 12.2.2. Because it draws on standard LNS base objects such as LNS_LOAN_HEADERS and LNS_LOAN_TYPES, it is a convenient entry point for operational and analytical reporting on the loan portfolio without direct dependency on the underlying normalized schema. The view is read-only by nature.

Underlying Base Objects

The documented base objects referenced by the view are LNS_LOAN_HEADERS (synonym), LNS_LOAN_TYPES (synonym), LNS_LOOKUPS (view), FND_CURRENCIES_VL (view), JTF_RS_RESOURCE_EXTNS (synonym), HZ_PARTIES (synonym), and the packages LNS_FIN_UTILS and FND_GLOBAL.

LNS_LOAN_HEADERS_ALL supplies the primary loan driving table, contributing identifiers, amounts, dates, status codes, reference data, and the ATTRIBUTE1 through ATTRIBUTE20 descriptive flexfield columns. LNS_LOAN_TYPES is outer-joined to resolve LOAN_TYPE_NAME. LNS_LOOKUPS is referenced multiple times to decode status, loan class, loan subtype, loan purpose, and both the standard and amortized period meanings. FND_CURRENCIES_VL provides the currency name. JTF_RS_RESOURCE_EXTNS is joined on LOAN_ASSIGNED_TO to return the assigned employee's name components, filtered to RESOURCE category 'EMPLOYEE'. HZ_PARTIES supplies the contact party name. LNS_FIN_UTILS.GETACTIVERATE derives the active interest rate, and FND_GLOBAL is used for session context such as ORG_ID. A record is returned only when the header is unclosed (END_DATE is null) or the current date is within the record's effective window.

Key Columns

Common Use Cases and Queries

Typical uses include loan portfolio listings, exposure and maturity analysis, loan-type breakdowns, and feed extracts. Because the view already decodes statuses and types, it is efficient for ad hoc queries and Discoverer or BI Publisher reports.

  • Filtering by loan type: SELECT loan_number, loan_type_name, requested_amount FROM lns_loan_summary_v WHERE loan_type_name = :p_type;
  • Grouping by type and currency: SELECT loan_type_name, loan_currency, SUM(funded_amount) FROM lns_loan_summary_v GROUP BY loan_type_name, loan_currency;
  • Maturity window analysis: SELECT loan_number, loan_maturity_date, funded_amount FROM lns_loan_summary_v WHERE loan_maturity_date BETWEEN :from_date AND :to_date;
  • Assigned-to detail: SELECT loan_number, source_name, status FROM lns_loan_summary_v WHERE loan_assigned_to = :resource_id;

Queries should generally constrain by ORG_ID for multi-org environments, and callers should be aware that the active-rate column is positional and unnamed in the view definition.