Search Results reference_amount

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:

• LNS_LOAN_HEADERS_ALL_VL (VIEW) — the loan header master, supplying loan-level attributes; "ALL" denotes operating-unit (ORG_ID) partitioning.
• LNS_LOAN_TYPES_VL (VIEW) — provides LOAN_TYPE_NAME for the loan type code.
• XLA_EVENTS (SYNONYM) — the Subledger Accounting events table, supplying EVENT_ID.
• XLA_TRANSACTION_ENTITIES (SYNONYM) — links the accounting event to its source transaction entity.
• HZ_PARTIES (SYNONYM) — provides the borrower party name (PARTY_NAME) via the primary borrower identifier.

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

• EVENT_ID / LEDGER_ID — Subledger Accounting event and ledger identifiers, anchoring the row to the accounting model.
• LOAN_ID, LOAN_NUMBER, LOAN_DESCRIPTION — Primary loan identifiers and descriptive text.
• REFERENCE_AMOUNT — The reference amount associated with the loan header, one of several monetary fields accompanying REQUESTED_AMOUNT and FUNDED_AMOUNT.
• REFERENCE_NUMBER, REFERENCE_NAME, REFERENCE_TYPE, REFERENCE_TYPE_ID, REFERENCE_DESCRIPTION — Describe the external or internal reference against which the loan is tracked.
• INITIAL_LOAN_BALANCE, LAST_PAYMENT_AMOUNT — Principal and payment figures.
• LOAN_CURRENCY, EXCHANGE_RATE_TYPE, EXCHANGE_DATE, EXCHANGE_RATE — Currency and conversion context.
• CUST_ACCOUNT_ID, PRIMARY_BORROWER_ID, PARTY_NAME — Borrower identification.
• LOAN_STATUS, LOAN_APPROVAL_DATE, LOAN_CLOSING_DATE, LOAN_MATURITY_DATE, GL_DATE — Life-cycle and accounting date fields.
• ORG_ID, LEGAL_ENTITY_ID — Multi-organization and legal entity context.
• ATTRIBUTE1 through ATTRIBUTE20 — Descriptive flexfield columns.
• Standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_ID, REQUEST_ID, OBJECT_VERSION_NUMBER).

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.