Results for “mtl_system_items_fvl”

46 results




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

Overview

MTL_SYSTEM_ITEMS_FVL is an APPS-owned, valid view within the Oracle E-Business Suite Inventory (INV) module. It serves as the base view for the Define System Items (INVIDITM) form, specifically the MTL_SYSTEM_ITEMS block, providing the transactional foundation for item definition and maintenance. Because the view is MLS (Multi-Lingual Support) enabled, it transparently resolves translated item attributes—such as descriptions—according to the session language, returning only the appropriate language rows from the underlying translation table.

In Oracle EBS 12.1.1 and 12.2.2, the object plays a dual role: it drives the form-based maintenance of item master records and acts as the canonical join point for both base item attributes (physical, planning, and costing controls) and translated, user-facing descriptive fields. Reporting and integration developers frequently select from this view instead of joining MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_TL manually, since the view encapsulates the MLS join logic and exposes the row identifier needed by Oracle Forms.

Underlying Base Objects

The documented metadata for ETRM 12.2.2 identifies two referenced base objects, both accessed through synonyms:

  • MTL_SYSTEM_ITEMS_B – the base (non-translated) item master table holding organization-specific item attributes such as inventory, purchasing, BOM, and costing flags.
  • MTL_SYSTEM_ITEMS_TL – the translation table holding language-dependent attributes, principally DESCRIPTION and LONG_DESCRIPTION, keyed by language and source language.

The view text reveals an inner-select pattern: columns are sourced from the B alias (MTL_SYSTEM_ITEMS_B), with the MLS-enabled translation join applied to produce a single, language-filtered result set. The view returns B.ROWID AS ROW_ID plus the full set of item attribute columns, which permits the Oracle Forms block to perform its normal insert, update, and delete processing against the underlying base table.

Note that the view is defined in the APPS schema and depends on the synonyms at runtime, so grants on the base tables and the translation table must be in place for any custom code referencing it.

Key Columns

The view exposes the complete attribute set of MTL_SYSTEM_ITEMS_B. The most frequently referenced columns include:

Common Use Cases and Queries

The view is used in item master validation, item status reporting, and cross-module integration queries. A representative query returns active, stock-enabled items with their translated descriptions:

  • SELECT inventory_item_id, organization_id, segment1, description, primary_uom_code FROM mtl_system_items_fvl WHERE organization_id = :org_id AND inventory_item_status_code = 'Active' AND stock_enabled_flag = 'Y';
  • Item attribute extraction for interfaces: SELECT inventory_item_id, segment1, item_type, lot_control_code, serial_number_control_code FROM mtl_system_items_fvl WHERE organization_id = :org_id;
  • Purchasing eligibility check: SELECT segment1, description, buyer_id, purchasing_enabled_flag FROM mtl_system_items_fvl WHERE organization_id = :org_id AND purchasing_enabled_flag = 'Y';

Because the view is MLS enabled, developers should filter or rely on the language join to ensure descriptions return in the intended language, and should be aware that it is optimized for form access rather than large-scale reporting; high-volume extracts are often better served by direct queries against MTL_SYSTEM_ITEMS_B with an explicit translation join.