Search Results storage_class




Overview
Explore in AI Chat

Overview

The APPS.IC_STOR_CLS_VW view is an Oracle E-Business Suite dictionary view that exposes storage class definitions used by Oracle Process Manufacturing (OPM) and Inventory. In EBS, a "storage class" is a categorization applied to inventory items that communicates handling, environmental, or storage requirements — for example, refrigerated, hazardous, or temperature-controlled goods. The view name (IC_STOR_CLS_VW) reflects its historical association with Inventory (IC) and its purpose of surfacing storage class data to Inventory and OPM modules.

The view presents a normalized, reporting-friendly projection of storage class categories drawn from the MTL category framework combined with OPM category set definitions. Its principal role is to provide a single, consistent source of storage class records for concurrent programs, forms, validation logic, and integration interfaces. Because it consolidates data spanning the MTL_CATEGORIES_V view and OPM's GMI_CATEGORY_SETS table, it abstracts the underlying category structure and validation rules away from calling code.

Underlying Base Objects

The view is defined over four documented base objects:

  • GMI_CATEGORY_SETS (SYNONYM) — the OPM category set table. The view filters on OPM_CLASS = 'STORAGE_CLASS' to restrict results to storage class definitions only.
  • MTL_CATEGORIES_V (VIEW) — the Inventory categories view supplying the concatenated category segments, description, IDs, audit columns, and the descriptive flexfield ATTRIBUTE1–ATTRIBUTE15 and ATTRIBUTE_CATEGORY columns.
  • MTL_CATEGORY_SETS (SYNONYM) — the Inventory category set table, joined by CATEGORY_SET_ID and STRUCTURE_ID to link the OPM class to its MTL category structure.
  • MTL_CATEGORY_SET_VALID_CATS (SYNONYM) — the table of categories valid within each category set, joined in the second half of the UNION.

The view is implemented as a two-branch UNION. The first branch joins MTL_CATEGORIES_V, MTL_CATEGORY_SETS, and GMI_CATEGORY_SETS and applies the condition cs.validate_flag <> 'Y' with a constraint that the concatenated segment is upper-cased. The second branch joins the same tables plus MTL_CATEGORY_SET_VALID_CATS, returning categories that are explicitly validated within the set. This UNION ensures both validated and non-validated storage class categories are surfaced.

Key Columns

  • CATEGORY_CONCAT_SEGS (truncated to 8 characters) — the concatenated category segment value, serving as the human-readable storage class code.
  • CATEGORY_ID — the unique identifier of the underlying category.
  • DESCRIPTION (truncated to 70 characters) — the storage class description.
  • DISABLE_DATE (via DECODE returning 0/1) — an enable/disable indicator; 0 means active, 1 means disabled.
  • CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
  • ATTRIBUTE1 through ATTRIBUTE15, ATTRIBUTE_CATEGORY — the descriptive flexfield attributes carried through from MTL_CATEGORIES_V.

Several literal and NULL placeholders (0, TO_NUMBER(NULL), TO_CHAR(NULL)) are included to align the column shapes of the two UNION branches, which is a common EBS view design pattern.

Common Use Cases and Queries

The view is typically queried when building reports, LOVs, or integration extracts that require the list of active storage classes. A simple retrieval of active storage classes follows:

  • SELECT category_concat_segs, category_id, description FROM apps.ic_stor_cls_vw WHERE disable_flag = 0 ORDER BY 1;

Applications may join this view to item master data to determine the storage class assigned to each item, or use it to populate a value set for user entry. Because the view filters specifically on the OPM_CLASS value 'STORAGE_CLASS', it is the authoritative reference for storage class lookups in OPM-integrated Inventory environments. Developers should be aware that results are truncated to 8-character segment codes and that the UNION may return a category from either branch, so DISTINCT or filtering may be appropriate depending on the query.