Results for “trx_number_displayed”

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

Overview

The APPS.LNS_AEL_GL_V view is a reporting construct within the Oracle E-Business Suite Loans (LNS) module. Its documented purpose is to expose accounting general ledger information relating to loans invoices. It functions as a subledger accounting (SLA) reporting view, presenting loan-related accounting entries alongside the originating loan header attributes and the associated GL journal header and line details.

The view conforms to the structure of the Oracle Subledger Accounting Accounting Event Line (AEL) reporting model, projecting loans data into a generalized column layout that includes APPLICATION_ID, JE_HEADER_ID, JE_CATEGORY, SET_OF_BOOKS_ID, and the standard entered and accounted debit/credit amounts. Because the loans product generates accounting through the XLA engine, this view bridges three logical layers: the LNS operational tables (LNS_LOAN_HEADERS_ALL), the XLA subledger accounting engine (XLA_AE_HEADERS, XLA_AE_LINES, XLA_EVENTS, XLA_TRANSACTION_ENTITIES), and the final GL posting layer (GL_JE_HEADERS, GL_JE_LINES, GL_IMPORT_REFERENCES).

In EBS 12.1.1 and 12.2.2 the view remains a read-only, joined view owned by the APPS schema. It is primarily consumed by accounting reconciliation reports, custom inquiries, and integration extracts. No base-table DML is supported through it.

Underlying Base Objects

The view is defined over ten documented base objects, joined to reconcile loan events with their GL impact:

• LNS_LOAN_HEADERS_ALL — the driving loans table, providing loan number, currency, loan class, loan type, GL date, org, and borrower.
• HZ_PARTIES — joined on PARTY_ID = LNH.PRIMARY_BORROWER_ID to supply the third-party (borrower) name.
• XLA_TRANSACTION_ENTITIES and XLA_EVENTS — link the loan (SOURCE_ID_INT_1) to its accounting events.
• XLA_AE_HEADERS and XLA_AE_LINES — provide the subledger journal entry headers and lines, including entered and accounted amounts and currency conversion attributes.
• GL_IMPORT_REFERENCES — links the XLA accounting lines to the corresponding GL journal lines via GL_SL_LINK_ID.
• GL_JE_HEADERS and GL_JE_LINES — supply the final posted journal header and line information.
• LNS_UTILITY_PUB — a PL/SQL package whose GET_LOOKUP_MEANING function is invoked twice to translate the loan class and loan type codes into their descriptive meanings (TRX_CLASS_NAME and TRX_TYPE_NAME).

Key Columns

• TRX_TYPE_NAME — derived via LNS_UTILITY_PUB.GET_LOOKUP_MEANING('LOAN_TYPE', LNH.LOAN_TYPE); the descriptive name of the loan type. This is the column most frequently sought in the context of the user's search term trx_type_name.
• TRX_CLASS_NAME — the descriptive loan class, obtained from the LOAN_CLASS lookup.
• TRX_NUMBER_DISPLAYED — the loan number (LNH.LOAN_NUMBER).
• TRX_HDR_ID — the loan identifier (LNH.LOAN_ID).
• ORG_ID, CURRENCY_CODE, ACCOUNTING_DATE (TRUNC(LNH.GL_DATE)) — organizational, currency, and accounting date context.
• THIRD_PARTY_NAME — the primary borrower's party name from HZ_PARTIES.
• ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR — entered and accounted debit/credit amounts from the XLA accounting lines.
• CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE — currency conversion details.
• JE_HEADER_ID, JE_LINE_NUM, JE_CATEGORY, LEDGER_ID (exposed as SET_OF_BOOKS_ID) — GL journal identification and ledger context.
• Several structural columns are hard-coded as NULL (for example TRX_CLASS, TRX_DATE, ACCT_LINE_TYPE, CODE_COMBINATION_ID, and numerous others), retaining AEL-compatible column positioning while not carrying data in this LNS implementation.

Common Use Cases and Queries

Typical uses include loan accounting reconciliation, ledger-level reporting of loans entries, and extracts that require the descriptive loan type. A representative query filtering on the loan type name is:

SELECT TRX_NUMBER_DISPLAYED, TRX_TYPE_NAME, TRX_CLASS_NAME,
       THIRD_PARTY_NAME, ACCOUNTING_DATE, CURRENCY_CODE,
       ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR
  FROM APPS.LNS_AEL_GL_V
 WHERE TRX_TYPE_NAME = '&loan_type
   AND ORG_ID = :org_id;

Other scenarios include reconciling subledger lines to GL journals by joining on JE_HEADER_ID and JE_LINE_NUM, summarizing accounted amounts by ledger, and auditing currency conversion details for foreign-currency loans. Because lookup translation relies on LNS_UTILITY_PUB, callers should ensure the package is valid and accessible in the querying session.