Results for “accounting_line_type_dsp”

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

Overview

XLA_PROD_ACCT_LINES_FVL is an APPS-owned, VALID database view within the XLA (Subledger Accounting) product of Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a denormalized, flexible-validation (FVL) representation of the seeded and user-defined accounting line definitions that drive Subledger Accounting's product rules. The view joins the base accounting-line definition table XLA_PROD_ACCT_LINES to its translation table, description table, and lookup views to expose human-readable names alongside the underlying coded values.

The _FVL suffix indicates the view is intended for use as an Oracle Forms flexfield/value validation source and for ad-hoc reporting and integration purposes where display values are preferred over raw lookup codes. Analysts and developers query it to resolve the meaning of stored accounting line definitions, particularly the ACCOUNTING_LINE_TYPE_DSP column, which the ETRM metadata identifies as a key exposed attribute derived from the XLA_LOOKUPS view.

Underlying Base Objects

The view is defined over four documented objects, all resolved in the APPS schema:

• XLA_PROD_ACCT_LINES (SYNONYM) — the driving base object, supplying the majority of the projected columns, including APPLICATION_ID, AMB_CONTEXT_CODE, ENTITY_CODE, EVENT_CLASS_CODE, ACCOUNTING_LINE_CODE, ACCOUNTING_LINE_TYPE_CODE, and the audit and active-flag columns.
• XLA_ACCT_LINE_TYPES_TL (SYNONYM) — the translated accounting line type table, joined on the application, accounting method context, entity, event class, accounting line type, and accounting line code, filtered to USERENV('LANG'), to yield ACCOUNTING_LINE_NAME.
• XLA_DESCRIPTIONS_TL (SYNONYM) — outer-joined to supply optional description names and description-type display values, filtered to the session language.
• XLA_LOOKUPS (VIEW) — joined twice (aliased K and K1) on lookup type XLA_OWNER_TYPE to derive ACCOUNTING_LINE_TYPE_DSP and the description type display meaning.

The join to XLA_LOOKUPS for ACCOUNTING_LINE_TYPE_CODE is mandatory (inner join), while the description joins are outer joins ((+) operator), reflecting that descriptions are optional for a given accounting line definition.

Key Columns

• ROW_ID — the ROWID of the underlying XLA_PROD_ACCT_LINES row, used for update forms.
• APPLICATION_ID — numeric identifier of the owning subledger application (e.g., Payables, Receivables).
• AMB_CONTEXT_CODE — the accounting methods builder context code that scopes the definition.
• ENTITY_CODE / EVENT_CLASS_CODE / EVENT_TYPE_CODE — the transaction entity, event class, and event type to which the accounting line applies.
• ACCOUNTING_LINE_CODE — the seeded or user-defined code of the accounting line.
• ACCOUNTING_LINE_TYPE_CODE — the coded line type value; joined to XLA_LOOKUPS on lookup type XLA_OWNER_TYPE.
• ACCOUNTING_LINE_TYPE_DSP — the translated display meaning of the accounting line type, resolved from XLA_LOOKUPS.MEANING; this is the column the user searched for.
• ACCOUNTING_LINE_NAME — the translated name from XLA_ACCT_LINE_TYPES_TL.
• DESCRIPTION_CODE / DESCRIPTION_TYPE_CODE / DESCRIPTION_NAME / DESCRIPTION_TYPE_DSP — optional description definition and its display equivalents.
• ACTIVE_FLAG, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit and status columns inherited from the base table.

Common Use Cases and Queries

The view is typically used to report the accounting line definitions associated with a given subledger application and accounting method, or to resolve display values for the accounting line type without separately joining lookup and translation tables.

Retrieve all accounting line definitions for a specific application and event class:

• SELECT application_id, entity_code, event_class_code, accounting_line_code, accounting_line_type_dsp, accounting_line_name FROM apps.xla_prod_acct_lines_fvl WHERE application_id = 200 AND event_class_code = 'INVOICES' AND active_flag = 'Y';

Distinct display values for accounting line types:

• SELECT DISTINCT accounting_line_type_code, accounting_line_type_dsp FROM apps.xla_prod_acct_lines_fvl ORDER BY accounting_line_type_dsp;

Locate definitions carrying a specific description type, using the outer-joined description columns:

• SELECT accounting_line_code, description_code, description_type_dsp FROM apps.xla_prod_acct_lines_fvl WHERE description_type_code IS NOT NULL;

Because the view filters translation and description lookups by USERENV('LANG'), query results are returned in the session language of the connected user, making it suitable for localized reporting and for populating FVL value sets in Subledger Accounting setup forms.