Results for “gl_ledger_norm_msvs_v”

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

Overview

GL_LEDGER_NORM_MSVS_V is a read-only Oracle EBS view owned by the APPS schema and defined in the General Ledger (GL) product. It presents a normalized, filtered projection of ledger segment values stored in the underlying GL_LEDGER_NORM_SEG_VALS table. The "MSVS" suffix denotes "Mapping Set Segment Values," a construct used by Oracle General Ledger and by integration/reporting components that require a consistent, normalized representation of segment value assignments across ledgers.

The view is central to any consumer that resolves the relationship between a ledger and its assigned segment values — for example, intercompany balancing rules, ledger mapping sets, and financial consolidation setups. Because it excludes logically deleted records and restricts results to one segment type, it delivers a clean, purpose-built row set rather than exposing the full base table. The presence of the SEGMENT_VALUE_TYPE_CODE column, which the user specifically searched for, reflects its role in distinguishing segment value categories used in mapping and validation logic.

Underlying Base Objects

The view is defined exclusively over a single documented base object: GL_LEDGER_NORM_SEG_VALS (referenced through a synonym in the APPS schema). The view text applies two important filters against that table, both of which shape the data any query will see:

• A deletion filter: NVL(LSV.STATUS_CODE, 'X') <> 'D', which suppresses rows marked as deleted, including those with a NULL status code.
• A segment-type filter: LSV.SEGMENT_TYPE_CODE = 'M', restricting output to the segment type associated with mapping set segment values.
• An ORDER BY LSV.SEGMENT_VALUE clause, which returns rows sorted alphabetically by segment value.

Each column in the view maps one-to-one to a column on the base table, so no joins, aggregations, or computed expressions are introduced. The view therefore inherits the base table's keys, audit columns, and descriptive flexfield attribute columns.

Key Columns

• ROW_ID — the ROWID of the underlying base-table row, useful for row-level identification and direct DML targeting.
• LEDGER_ID — the ledger with which the segment value is associated.
• SEGMENT_VALUE — the segment value itself; also the column used for the view's sort order.
• SEGMENT_VALUE_TYPE_CODE — classifies the type of segment value (the field the user searched for), used in mapping and assignment logic.
• STATUS_CODE — lifecycle status of the record; rows with value 'D' are excluded from the view.
• RECORD_ID — surrogate identifier for the record.
• START_DATE / END_DATE — the effective date range for which the segment value assignment is valid.
• Audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) — standard EBS who-columns.
• CONTEXT and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield (DFF) supporting columns.
• REQUEST_ID — the concurrent request that created or last processed the record, supporting audit and reconciliation.

Common Use Cases and Queries

This view is typically queried when validating or reconciling segment value assignments per ledger, particularly where the segment value type is significant. A representative query retrieves all active mapping set segment values for a given ledger, filtered by segment value type:

• SELECT LEDGER_ID, SEGMENT_VALUE, SEGMENT_VALUE_TYPE_CODE, STATUS_CODE FROM GL_LEDGER_NORM_MSVS_V WHERE LEDGER_ID = :p_ledger_id AND SEGMENT_VALUE_TYPE_CODE = :p_type_code ORDER BY SEGMENT_VALUE;
• SELECT SEGMENT_VALUE, START_DATE, END_DATE FROM GL_LEDGER_NORM_MSVS_V WHERE LEDGER_ID = :p_ledger_id AND SYSDATE BETWEEN START_DATE AND END_DATE;
• SELECT SEGMENT_VALUE_TYPE_CODE, COUNT(*) FROM GL_LEDGER_NORM_MSVS_V GROUP BY SEGMENT_VALUE_TYPE_CODE;

Because the view is defined over a single base table and excludes deleted rows, it is a convenient, low-risk source for read-only reporting and integration extracts without the need to re-implement the deletion and segment-type business filters.