Search Results lns_loan_headers_ext_v




Overview
Explore in AI Chat

Overview

APPS.LNS_LOAN_HEADERS_EXT_V is a reporting and integration view within the Oracle E-Business Suite Loans (LNS) module. Its documented purpose is "Loans Accounting Header Extract," positioning it as the principal read-only interface through which loan accounting header information is surfaced for downstream extract, reconciliation, and analytical activity. The view is valid in both Oracle EBS 12.1.1 and 12.2.2 and carries the standard APPS schema ownership used throughout EBS for multi-organization, security-enabled reporting objects.

Functionally, the view joins loan master data from the Loans header tables to the Subledger Accounting event model, thereby exposing the accounting event (EVENT_ID) and ledger (LEDGER_ID) context alongside the loan attributes required to interpret each event. This makes it suitable for reconciliation between loan origination data and its corresponding subledger accounting entries, as well as for feeding external reporting, data warehousing, or third-party lending systems. Because the request context referenced a specific attribute, REFERENCE_AMOUNT, this view is the recommended access point when retrieving the reference amount together with its associated loan, borrower, and accounting event.

Underlying Base Objects

The view is defined over the following documented base objects:

As a view rather than a stored object, LNS_LOAN_HEADERS_EXT_V introduces no independent storage; it depends entirely on the freshness and integrity of the underlying tables. Access is inherited from the base objects, so data visibility is constrained by the operating unit and subledger accounting security applied to those sources.

Key Columns

Common Use Cases and Queries

Typical scenarios include loan-to-subledger reconciliation, exposure reporting, and extract feeds. Because ORG_ID governs multi-organization access, queries should filter by operating unit where appropriate.

  • Retrieve loans with their reference amount and borrower:

    SELECT loan_number, party_name, reference_amount, requested_amount, funded_amount, loan_currency
FROM   apps.lns_loan_headers_ext_v
WHERE  org_id = :p_org_id;

  • Reconcile accounting events to loans:

    SELECT event_id, ledger_id, loan_id, loan_number, reference_amount, gl_date
FROM   apps.lns_loan_headers_ext_v
WHERE  event_id IS NOT NULL
ORDER  BY gl_date;

  • Aggregate reference amounts by loan type:

    SELECT loan_type_name, COUNT(*) loan_cnt, SUM(reference_amount) tot_reference
FROM   apps.lns_loan_headers_ext_v
GROUP  BY loan_type_name;

All queries should be executed with APPS credentials or a responsibility granted select privilege on the view, and results are subject to the security of the underlying loans and subledger accounting data.