Search Results lns_lookups




Overview
Explore in AI Chat

Overview

LNS_LOOKUPS is an APPS-owned database view within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environment. It resides in the LNS (Loans) product module and is documented as VALID in the ETRM repository. The view exposes lookup value information associated with the Loans application, providing a pre-filtered, language-aware, and security-group-filtered projection of Oracle Application Object Library (FND) lookup data. Rather than querying the underlying FND_LOOKUP_VALUES table directly and reapplying the Loans-specific filters on every invocation, developers, concurrent programs, and reporting tools can reference LNS_LOOKUPS to obtain Loan-related lookup codes and their translated meanings consistently.

The view plays a conventional EBS integration and reporting role: it abstracts the standardized flexfield/lookup value framework into a flat, denormalized rowset that can be consumed by BI Publisher reports, Oracle Reports, OAF pages, PL/SQL packages, and inbound/outbound interfaces that must resolve Loans lookup codes to their display meanings.

Underlying Base Objects

The documented base objects referenced by LNS_LOOKUPS are FND_LOOKUP_VALUES (SYNONYM) and the FND_GLOBAL package. The view text confirms this dependency: it selects directly from FND_LOOKUP_VALUES (aliased FNDLKPV) and invokes FND_GLOBAL.LOOKUP_SECURITY_GROUP and USERENV('LANG') within its WHERE clause.

  • FND_LOOKUP_VALUES — the central EBS lookup value repository holding lookup types, codes, translated meanings, enabled flags, effective dates, and 15 descriptive attributes. LNS_LOOKUPS renames this source column-by-column without transformation, so every column retains the semantics of its FND counterpart.
  • FND_GLOBAL — the standard EBS session/context package. It is used here to enforce lookup security group filtering via LOOKUP_SECURITY_GROUP, ensuring only lookup values belonging to the caller's security group are visible.

The view filters on three predicates: LANGUAGE = USERENV('LANG') to return only rows in the session's current language; VIEW_APPLICATION_ID = 206, which is the application identifier reserved for the Loans (LNS) product; and the security group check. Because the view is defined over the FND lookup table rather than an LNS-specific base table, it effectively carves a Loans-scoped slice from the shared lookup infrastructure.

Key Columns

LNS_LOOKUPS exposes the complete FND_LOOKUP_VALUES column set, renamed for clarity. The principal columns include:

  • LOOKUP_TYPE — the lookup type to which the value belongs; distinguishes, for example, different Loans lookup categories.
  • LOOKUP_CODE — the stored internal code used by application logic and interfaces.
  • MEANING — the translated user-facing display value shown in forms, reports, and LOVs.
  • DESCRIPTION — long description associated with the lookup value.
  • ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE — availability and effective-dating controls that determine whether the value is currently active.
  • TAG — optional tag value supported by the lookup framework.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield style attributes that may carry Loans-specific extension data.
  • Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN for change tracking.

Common Use Cases and Queries

Typical scenarios involve resolving a stored lookup code to its display meaning, driving LOVs, or validating inbound data against enabled Loans lookups. A base query of the form SELECT LOOKUP_CODE, MEANING FROM LNS_LOOKUPS WHERE LOOKUP_TYPE = :type AND NVL(ENABLED_FLAG,'N') = 'Y' and a date check between START_DATE_ACTIVE and END_DATE_ACTIVE returns active values. Joining LNS_LOOKUPS to Loans business tables on LOOKUP_CODE and LOOKUP_TYPE enriches those tables with descriptive text. Because the LANGUAGE and security predicates are embedded, callers automatically receive localized, security-compliant results, eliminating the need to reimplement those filters.