Search Results wsm_co_products




Overview
Explore in AI Chat

Overview

The WSM_CO_PRODUCTS table is a core data object within the Oracle E-Business Suite (EBS) Shop Floor Management (WSM) module, specifically supporting the Oracle Shop Floor Management (OSFM) functionality. Its primary role is to define and store co-product relationships within a manufacturing environment. A co-product is a secondary item that is intentionally produced alongside a primary product from the same manufacturing operation, sharing the same material inputs and resources. This table is essential for accurately modeling complex production processes where multiple valuable outputs are generated from a single job or batch, enabling precise cost allocation, material planning, and inventory tracking for all resulting items.

Key Information Stored

The table stores the structural definition linking co-products to their parent manufacturing bill. The primary key, composed of CO_PRODUCT_GROUP_ID and COMPONENT_ID, uniquely identifies each co-product entry within a group. Key columns include the ORGANIZATION_ID, which ties the relationship to a specific inventory organization, and the BILL_SEQUENCE_ID, which references the parent bill of material (BOM_BILL_OF_MATERIALS) defining the assembly. The COMPONENT_SEQUENCE_ID links to the specific component line (BOM_INVENTORY_COMPONENTS) that defines the co-product item. For supply chain execution, the table also holds SUPPLY_SUBINVENTORY and SUPPLY_LOCATOR_ID, referencing MTL_SECONDARY_INVENTORIES and MTL_ITEM_LOCATIONS respectively, to specify where the co-product is staged upon completion of the work order.

Common Use Cases and Queries

This table is central to reporting and transactional logic involving co-products. Common use cases include generating a pick list for a discrete job that includes all planned co-products, calculating yield and output quantities for cost accounting, and validating bill of material configurations. A typical query might join this table to item master and bill tables to list all co-products for a specific assembly in an organization.

SELECT wcp.CO_PRODUCT_GROUP_ID,
       msib1.CONCATENATED_SEGMENTS ASSEMBLY_ITEM,
       msib2.CONCATENATED_SEGMENTS CO_PRODUCT_ITEM
FROM WSM_CO_PRODUCTS wcp,
     BOM_BILL_OF_MATERIALS bom,
     MTL_SYSTEM_ITEMS_B_KFV msib1,
     MTL_SYSTEM_ITEMS_B_KFV msib2
WHERE wcp.BILL_SEQUENCE_ID = bom.BILL_SEQUENCE_ID
AND   bom.ASSEMBLY_ITEM_ID = msib1.INVENTORY_ITEM_ID
AND   bom.ORGANIZATION_ID = msib1.ORGANIZATION_ID
AND   wcp.COMPONENT_ID = msib2.INVENTORY_ITEM_ID
AND   wcp.ORGANIZATION_ID = msib2.ORGANIZATION_ID
AND   wcp.ORGANIZATION_ID = :p_org_id;

Related Objects

The WSM_CO_PRODUCTS table has defined foreign key relationships with several fundamental EBS tables, primarily within the Bills of Material (BOM) and Inventory modules. These relationships are critical for maintaining data integrity and enabling joins for reporting.

  • BOM_BILL_OF_MATERIALS: Joined via WSM_CO_PRODUCTS.BILL_SEQUENCE_ID. This links the co-product to its parent assembly bill.
  • BOM_INVENTORY_COMPONENTS: Joined via WSM_CO_PRODUCTS.COMPONENT_SEQUENCE_ID. This links to the specific component line item definition.
  • MTL_SECONDARY_INVENTORIES: Joined via WSM_CO_PRODUCTS.SUPPLY_SUBINVENTORY and ORGANIZATION_ID. Identifies the subinventory for co-product receipt.
  • MTL_ITEM_LOCATIONS: Joined via WSM_CO_PRODUCTS.SUPPLY_LOCATOR_ID and ORGANIZATION_ID. Identifies the precise locator within the subinventory.