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:
- ROW_ID – the ROWID of the base row, used for form-based row locking and updates.
- INVENTORY_ITEM_ID / ORGANIZATION_ID – the composite key of an item within an inventory organization.
- SEGMENT1–SEGMENT20 (surfaced via the form block) – the concatenated key segments comprising the item number.
- PRIMARY_UOM_CODE, PRIMARY_UNIT_OF_MEASURE – the item's primary stocking unit of measure.
- ITEM_TYPE – standard, model, option class, or planning item classification.
- INVENTORY_ITEM_STATUS_CODE – active, inactive, or pending status controlling transactional eligibility.
- INVENTORY_ITEM_FLAG, STOCK_ENABLED_FLAG, MTL_TRANSACTIONS_ENABLED_FLAG, BOM_ENABLED_FLAG, PURCHASING_ENABLED_FLAG, COSTING_ENABLED_FLAG – module enablement flags governing where the item may be used.
- LOT_CONTROL_CODE, SERIAL_NUMBER_CONTROL_CODE, SHELF_LIFE_CODE, REVISION_QTY_CONTROL_CODE – control attributes determining lot, serial, shelf-life, and revision handling.
- DESCRIPTION – supplied from the translation table and returned in the session language.
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.
-
View: MTL_SYSTEM_ITEMS_FVL 12.1.1
Base view for the Define System Items (INVIDITM) form MTL_SYSTEM_ITEMS block. This view is MLS enabled.
APPS.MTL_SYSTEM_ITEMS_FVL·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_SYSTEM_ITEMS_TL·Explore INV module →
-
View: MTL_SYSTEM_ITEMS_FVL 12.2.2
Base view for the Define System Items (INVIDITM) form MTL_SYSTEM_ITEMS block. This view is MLS enabled.
APPS.MTL_SYSTEM_ITEMS_FVL·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_SYSTEM_ITEMS_TL·Explore INV module →
-
APPS.INVTROAP SQL Statements 12.1.1
-
APPS.INVTROAP SQL Statements 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
PACKAGE BODY: APPS.INVTROAP 12.2.2
-
PACKAGE BODY: APPS.INVTROAP 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - INV Tables and Views 12.2.2
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2