Results for “mtl_categories_v”

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

Overview

MTL_CATEGORIES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the Inventory (INV) product. The ETRM metadata designates the object description as "10SC ONLY", indicating that the view is documented and validated for the Discrete Manufacturing / 10SC configuration path rather than for every deployment of EBS 12.1.1 or 12.2.2. In practice, the view presents item category assignments in a denormalized, presentation-ready form: it joins the category base and translation layers together with the key flexfield structure definition, so that consumers receive category identifiers, all twenty category key flexfield segments, descriptive text, and the concatenated category name in a single row.

Its role in EBS reporting and integration is essentially that of a convenience access layer over the Item Categories (MCAT) key flexfield. Instead of requiring report authors to resolve the MTL_CATEGORIES_TL translation row, flatten the key flexfield via the KFV view, and separately look up the structure name from the flexfield definition tables, MTL_CATEGORIES_V performs all of these joins internally. Because the view resolves language through USERENV('LANG') and restricts the flexfield lookup to application 401 with ID_FLEX_CODE 'MCAT', it returns only Item Categories structures and automatically delivers descriptions in the session's current language.

Underlying Base Objects

The documented referenced objects are MTL_CATEGORIES_TL (SYNONYM), MTL_CATEGORIES_B_KFV (VIEW), and FND_ID_FLEX_STRUCTURES_VL (VIEW).

• MTL_CATEGORIES_TL — the translation table holding the DESCRIPTION for each category in each installed language. The view joins it on CATEGORY_ID and filters MCT.LANGUAGE = USERENV('LANG') to produce a single language-appropriate description row.
• MTL_CATEGORIES_B_KFV — the key flexfield view over the MTL_CATEGORIES_B base table. It supplies the surrogate keys (ROW_ID, CATEGORY_ID, STRUCTURE_ID), the individual SEGMENT1 through SEGMENT20 values, the CONCATENATED_SEGMENTS alias exposed as CATEGORY_CONCAT_SEGS, and the standard WHO/audit columns plus the descriptive flexfield ATTRIBUTE columns.
• FND_ID_FLEX_STRUCTURES_VL — the flexfield structure definition view. It is joined on STRUCTURE_ID = ID_FLEX_NUM and constrained by APPLICATION_ID = 401 and ID_FLEX_CODE = 'MCAT', providing ID_FLEX_STRUCTURE_NAME as the STRUCTURE_NAME column.

Because two of the three sources are themselves views or synonyms, MTL_CATEGORIES_V is a layered access path rather than a direct projection of a single physical table.

Key Columns

• CATEGORY_ID / STRUCTURE_ID — the primary identifiers linking a category to its Item Categories flexfield structure.
• SEGMENT1 … SEGMENT20 — the individual category key flexfield segment values (typically Summary, Category, and so on, depending on the structure).
• CATEGORY_CONCAT_SEGS — the concatenated, display-ready category name derived from the underlying KFV CONCATENATED_SEGMENTS.
• DESCRIPTION — the translated category description from MTL_CATEGORIES_TL.
• STRUCTURE_NAME — the flexfield structure name, useful when multiple category structures exist.
• ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, DISABLE_DATE, WEB_STATUS, SUPPLIER_ENABLED_FLAG — enablement, date-range, web, and supplier-related status indicators.
• SUMMARY_FLAG, ATTRIBUTE_CATEGORY, ATTRIBUTE1 … ATTRIBUTE15 — hierarchy and descriptive flexfield attributes.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical scenarios include category listings for inventory reporting, resolving concatenated category names for item assignment extracts, and supplying translated descriptions to interfaces or BI Publisher data models. A representative query filtering enabled categories within a single structure:

• SELECT category_id, category_concat_segs, description, structure_name
• FROM mtl_categories_v
• WHERE enabled_flag = 'Y' AND structure_name = :p_structure;

Because the "10SC ONLY" designation limits documented applicability, implementations should verify the object's presence and behavior in their specific 12.1.1 or 12.2.2 instance before relying on it in production reports.