Search Results displayed_field




Overview
Explore in AI Chat

Overview

AP_AEL_SL_INV_V is a Payables subledger accounting view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that exposes accounted invoice lines together with the descriptive ("displayed") names of their associated lookup codes. It belongs to the family of AP_AEL_SL_*_V views, which present subledger journal entries created by the Subledger Accounting (SLA) engine. This view specifically covers transactions of class 'INV' (Invoices) originating from the Payables application.

The view's role is to resolve technical codes — such as the transaction class, transaction type, accounting line type, and GL transfer status — into user-facing text via the DISPLAYED_FIELD column drawn from EBS lookup tables (aliased L1 through L12). This makes the view suitable for reconciliation reports, accounting inquiries, audit extracts, and downstream integrations that require readable SLA accounting data rather than raw lookup codes.

Underlying Base Objects

The ETRM metadata notes that no base objects are formally documented for this view and it is "Not implemented in this database," meaning the definition is version-dependent and may not exist in every environment. The view text, however, reveals the core contributing tables:

Key Columns

Common Use Cases and Queries

Typical uses include reconciling Payables SLA entries to GL, auditing accounted invoice lines with readable status text, and feeding downstream reporting.

SELECT TRX_NUMBER_DISPLAYED,
       TRX_TYPE_NAME,
       ACCT_LINE_TYPE_NAME,
       ACCOUNTED_DR,
       ACCOUNTED_CR,
       GL_TRANSFER_STATUS_NAME,
       THIRD_PARTY_NAME
FROM   AP_AEL_SL_INV_V
WHERE  ACCOUNTING_DATE BETWEEN :p_from AND :p_to
  AND  SET_OF_BOOKS_ID = :p_sob;

SELECT AE_LINE_REFERENCE, TRANSFER_STATUS_DETAIL_NAME
FROM   AP_AEL_SL_INV_V
WHERE  GL_TRANSFER_STATUS = 'N';

Because the view is not implemented in every database, availability should be verified against the specific EBS instance before relying on it in custom code.