Search Results component_item_desc




Overview
Explore in AI Chat

Overview

APPS.WSM_CO_PRODUCT_COMPONENTS_V is a supplementary Oracle EBS view owned by the APPS schema and registered in FND Design Data under the WSM (Work in Process / Shop Floor Management) product family. It exposes the component lines that belong to co-product and by-product definitions stored in the WSM co-products model. In Oracle EBS 12.1.1 and 12.2.2, co-products and by-products are defined against a primary assembly, and each definition carries one or more component entries describing the items that are expected to be produced or consumed alongside the primary item.

The view exists primarily to simplify Oracle Forms coding, which means it is a display and validation layer rather than a general-purpose reporting interface. Oracle explicitly does not recommend querying or altering data through this view because its definition may change dramatically in subsequent minor or major releases. Despite that caveat, the view is frequently discovered by users searching for the column component_item_desc, because the component description is resolved through the join to MTL_SYSTEM_ITEMS. Developers and report authors should treat it as a convenient but non-contractual access path to co-product component data.

Underlying Base Objects

According to the documented view metadata, WSM_CO_PRODUCT_COMPONENTS_V is defined over the following base objects:

  • WSM_CO_PRODUCTS (synonym) — stores the header record for a co-product or by-product definition, keyed by CO_PRODUCT_GROUP_ID.
  • MTL_SYSTEM_ITEMS (synonym) — supplies the item master attributes used to resolve component number and description.
  • MFG_LOOKUPS (view) — supplies the meaning of code-based columns such as WIP_SUPPLY_TYPE and SUPPLY_TYPE.
  • FND_COMMON_LOOKUPS (view) — supplies common lookup meanings, typically for attribute or status values.
  • FND_GLOBAL (package) — provides session context functions such as ORG_ID and USER_ID used for organization and security filtering.
  • WSMPCOGI (package) — the WSM co-product and by-product processing package that underpins maintenance and validation logic.

The view therefore joins the co-product header to its component rows and enriches them with item and lookup descriptions. No direct DML should be attempted, and any modification must be routed through the WSMPCOGI package or the standard co-product forms.

Key Columns

The view exposes a substantial set of columns. The most significant include:

Common Use Cases and Queries

The most frequent requirement is retrieving the component item description for each co-product component row, which is the reason this view is discovered through the search term component_item_desc. A representative query is:

  • SELECT co_product_group_id, component_id, component_sequence_id, usage_rate, component_yield_factor, effectivity_date, disable_date FROM apps.wsm_co_product_components_v WHERE organization_id = :org_id;
  • SELECT co_product_group_id, component_id FROM apps.wsm_co_product_components_v WHERE include_in_cost_rollup = 1 AND TRUNC(SYSDATE) BETWEEN effectivity_date AND NVL(disable_date, TRUNC(SYSDATE));

Note that because the component description is not a physical column in the view's documented structure, reports requiring an explicit description should join the component identifier to MTL_SYSTEM_ITEMS using ORGANIZATION_ID and INVENTORY_ITEM_ID. This avoids reliance on a view whose definition Oracle may change without notice.