Search Results mtl_default_category_sets_fk_v




Overview
Explore in AI Chat

Overview

MTL_DEFAULT_CATEGORY_SETS_FK_V is a view owned by the APPS schema within the Oracle E-Business Suite Inventory (INV) module. The ETRM metadata designates this object with the description "10SC ONLY," indicating that its functional scope is restricted to a specific deployment or localization context rather than being part of the general-purpose Inventory schema surface. The view presents functional-area-to-category-set assignments, joining the default category set configuration table against a functional area lookup and the translatable category set description table. Its principal role is to expose a denormalized, human-readable representation of which default category set is associated with each functional area in the Inventory application, including the language-sensitive category set name and description.

For reporting and integration purposes, the view removes the burden of resolving lookup codes and multi-language (TL) translation tables in ad hoc queries. Rather than joining MTL_DEFAULT_CATEGORY_SETS, MFG_LOOKUPS, and MTL_CATEGORY_SETS_TL manually, consumers can query a single object and obtain the functional area meaning, category set name, and category set description in one row. This is particularly relevant for the search term "category_set_description," since the view exposes a column by that exact name — sourced from the DESCRIPTION column of MTL_CATEGORY_SETS_TL and aliased as CATEGORY_SET_DESCRIPTION to disambiguate it from other descriptive attributes.

Underlying Base Objects

The view is defined over three referenced objects. MTL_DEFAULT_CATEGORY_SETS (a synonym over the base table) supplies the primary driving rows, contributing the functional area identifier, category set identifier, and the standard WHO audit columns. MFG_LOOKUPS (exposed as a view) is joined to decode the functional area, restricting rows to LOOKUP_TYPE = 'MTL_FUNCTIONAL_AREAS' and matching LOOKUP_CODE to the FUNCTIONAL_AREA_ID. MTL_CATEGORY_SETS_TL (a synonym over the translatable category sets table) supplies the language-specific CATEGORY_SET_NAME and DESCRIPTION, joined by CATEGORY_SET_ID.

The join to MTL_CATEGORY_SETS_TL is an outer join (CATEGORY_SET_ID(+) and LANGUAGE(+) = USERENV('LANG')), meaning rows in MTL_DEFAULT_CATEGORY_SETS without a corresponding translated category set record — or without a translation in the session's current language — are still returned, with NULL category set name and description. The join to MFG_LOOKUPS is an inner join, so only functional area identifiers present in the MTL_FUNCTIONAL_AREAS lookup are surfaced.

Key Columns

Common Use Cases and Queries

Typical uses include validating default category set configuration per functional area, producing configuration reports for Inventory implementation reviews, and feeding integration extracts where the English or session-language description must accompany the category set identifier.

A representative query retrieving descriptions for all functional areas follows:

  • SELECT functional_area_desc, category_set_name, category_set_description FROM mtl_default_category_sets_fk_v ORDER BY functional_area_desc;
  • SELECT functional_area_desc, category_set_name, category_set_description FROM mtl_default_category_sets_fk_v WHERE category_set_description IS NOT NULL;
  • SELECT category_set_id, functional_area_desc, category_set_description FROM mtl_default_category_sets_fk_v WHERE functional_area_desc = :area;

Because CATEGORY_SET_NAME and CATEGORY_SET_DESCRIPTION are language-dependent, results depend on the session language set via USERENV('LANG'). Queries intended for reporting should therefore account for localization, and note that missing translations return NULLs by virtue of the outer join.