Search Results gmd_storage_plans_vl




Overview
Explore in AI Chat

Overview

GMD_STORAGE_PLANS_VL is a multi-lingual (ML) view owned by the APPS schema in Oracle E-Business Suite, registered against the GMD - Process Manufacturing Product Development product. It exposes storage plan definitions maintained by Process Manufacturing, presenting a translated, user-facing representation of storage planning data. The _VL suffix indicates that the view joins a base (_B) table with its translation (_TL) table and filters the translation rows by the current session language using USERENV('LANG'), so that consumers see only the description corresponding to their login language.

Storage plans in Oracle Process Manufacturing define the physical and procedural handling of materials in storage, including the associated test intervals applied to stored items. The view is therefore commonly used in reporting, integration, and extension development where plan names, plan identifiers, and their language-specific descriptions must be presented together, without requiring the caller to write the language join manually.

Underlying Base Objects

The view is defined over two documented base objects, both exposed in the APPS schema as synonyms:

  • GMD_STORAGE_PLANS_B — the base table holding language-independent storage plan data, referenced in the view text as alias B. It supplies the primary key, plan name, test interval reference, DFF attributes, audit columns, and the DELETE_MARK flag.
  • GMD_STORAGE_PLANS_TL — the translation table, referenced as alias T. It holds the language-specific DESCRIPTION and the LANGUAGE discriminator.

The join condition is B.STORAGE_PLAN_ID = T.STORAGE_PLAN_ID AND T.LANGUAGE = USERENV('LANG'). Because the language predicate is embedded in the view, each query returns exactly one row per storage plan for the session language, provided the corresponding translation row exists. The view additionally exposes B.ROWID as ROW_ID, which supports identifying the underlying base-table row in update-capable contexts.

Key Columns

  • ROW_ID — the ROWID of the base table row, useful for direct row identification.
  • STORAGE_PLAN_ID — primary key of the storage plan; the join key between the _B and _TL tables and the value typically stored as a foreign key on downstream entities.
  • STORAGE_PLAN_NAME — the language-independent name of the storage plan.
  • BASE_TEST_INTERVAL_PLAN_ID — the identifier of the base test interval plan associated with the storage plan. This is the column most commonly referenced in searches such as "base_test_interval_plan_id"; it links a storage plan to the test interval definition that governs the frequency of quality or stability testing for material held under that plan.
  • TEXT_CODE and ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE30 — descriptive flexfield context and segment columns carried through from the base table.
  • DELETE_MARK — soft-delete indicator; rows marked deleted remain physically present and should be filtered out in most reporting queries.
  • CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.
  • DESCRIPTION — the translated description sourced from GMD_STORAGE_PLANS_TL for the session language.

Common Use Cases and Queries

Typical uses include identifying which base test interval plan is assigned to a given storage plan, validating plan setup during configuration or migration, and joining storage plans to test interval definitions for quality reporting. Because the view already resolves the language join, it is preferred over querying the base and translation tables separately. Filtering on DELETE_MARK is advisable to exclude logically deleted plans.

Retrieve a specific plan and its interval assignment:

  • SELECT storage_plan_id, storage_plan_name, base_test_interval_plan_id, description FROM apps.gmd_storage_plans_vl WHERE delete_mark = 0 AND storage_plan_id = :p_plan_id;

Locate all plans linked to a particular test interval plan:

  • SELECT storage_plan_id, storage_plan_name, description FROM apps.gmd_storage_plans_vl WHERE base_test_interval_plan_id = :p_interval_plan_id AND delete_mark = 0 ORDER BY storage_plan_name;

List active plans with descriptions for reporting:

  • SELECT storage_plan_id, storage_plan_name, base_test_interval_plan_id, description FROM apps.gmd_storage_plans_vl WHERE delete_mark = 0 ORDER BY storage_plan_name;

Note that the DESCRIPTION returned depends on USERENV('LANG') at execution time, so reports run under different language sessions will render the description in the corresponding installed language, provided a translation row exists.