Search Results wsm_sm_resulting_lots




Overview
Explore in AI Chat

Overview

The WSM_SM_RESULTING_LOTS table is a core transactional data structure within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Shop Floor Management (WSM) module. It serves as the base table for storing detailed information about resulting lots generated from inventory lot transactions processed through Oracle Shop Floor Management (OSFM). Its primary role is to record the new lot numbers created as a direct outcome of lot-based manufacturing and inventory operations, such as splits and merges, thereby providing a critical audit trail for lot genealogy and inventory tracking.

Key Information Stored

The table's structure is centered on linking a transaction to its specific lot outputs. Its primary key is a composite of TRANSACTION_ID and LOT_NUMBER, ensuring a unique record for each new lot created by a transaction. Key columns include TRANSACTION_ID, which links to the originating operation in WSM_LOT_SPLIT_MERGES; LOT_NUMBER, which stores the identifier of the newly created lot; and ORGANIZATION_ID, which identifies the inventory organization. Other significant columns typically include LOCATOR_ID for subinventory location details, ITEM_ID, and QUANTITY to record the amount assigned to the new lot. This data is essential for reconciling inventory balances and understanding the flow of material lots on the shop floor.

Common Use Cases and Queries

This table is central to reporting and troubleshooting lot transformation activities. A common use case is tracing the lineage of a specific lot back to its source transaction, or identifying all lots produced from a particular manufacturing event. For reporting, it is frequently joined to transaction and item master tables. A typical query pattern involves selecting resulting lot details for a given transaction:

  • SELECT lot_number, item_id, quantity FROM wsm_sm_resulting_lots WHERE transaction_id = :p_transaction_id AND organization_id = :p_org_id;

Another critical use case is generating audit reports that list all lot creation events within a date range, which requires joining to WSM_LOT_SPLIT_MERGES to get the transaction date and type.

Related Objects

WSM_SM_RESULTING_LOTS has defined foreign key relationships with several key EBS tables, as documented in the ETRM. These relationships are fundamental for data integrity and query joins:

  • WSM_LOT_SPLIT_MERGES: The table is directly dependent on this parent table via the TRANSACTION_ID column. This links each resulting lot record to its source transaction.
  • MTL_ITEM_LOCATIONS: References this table via the LOCATOR_ID and ORGANIZATION_ID columns to validate and provide details on the storage location for the resulting lot.
  • WSM_PARAMETERS: References this table via the ORGANIZATION_ID column to enforce valid organization identifiers within the WSM module.

In practice, queries also often join to MTL_SYSTEM_ITEMS_B (via ITEM_ID) and MTL_MATERIAL_TRANSACTIONS for comprehensive reporting.

  • Table: WSM_SM_RESULTING_LOTS 12.2.2

    owner:WSM,  object_type:TABLE,  fnd_design_data:WSM.WSM_SM_RESULTING_LOTS,  object_name:WSM_SM_RESULTING_LOTS,  status:VALID,  product: WSM - Shop Floor Management ,  description: Base table for Resulting Lots for Inventory Lot Transactions in OSFM. ,  implementation_dba_data: WSM.WSM_SM_RESULTING_LOTS , 

  • Table: WSM_SM_RESULTING_LOTS 12.1.1

    owner:WSM,  object_type:TABLE,  fnd_design_data:WSM.WSM_SM_RESULTING_LOTS,  object_name:WSM_SM_RESULTING_LOTS,  status:VALID,  product: WSM - Shop Floor Management ,  description: Base table for Resulting Lots for Inventory Lot Transactions in OSFM. ,  implementation_dba_data: WSM.WSM_SM_RESULTING_LOTS , 

  • Table: WSM_LOT_SPLIT_MERGES 12.1.1

    owner:WSM,  object_type:TABLE,  fnd_design_data:WSM.WSM_LOT_SPLIT_MERGES,  object_name:WSM_LOT_SPLIT_MERGES,  status:VALID,  product: WSM - Shop Floor Management ,  description: Base table for Lot based Inventory Transactions - Header Information. ,  implementation_dba_data: WSM.WSM_LOT_SPLIT_MERGES , 

  • Table: WSM_LOT_SPLIT_MERGES 12.2.2

    owner:WSM,  object_type:TABLE,  fnd_design_data:WSM.WSM_LOT_SPLIT_MERGES,  object_name:WSM_LOT_SPLIT_MERGES,  status:VALID,  product: WSM - Shop Floor Management ,  description: Base table for Lot based Inventory Transactions - Header Information. ,  implementation_dba_data: WSM.WSM_LOT_SPLIT_MERGES , 

  • Table: WSM_PARAMETERS 12.1.1

    owner:WSM,  object_type:TABLE,  fnd_design_data:WSM.WSM_PARAMETERS,  object_name:WSM_PARAMETERS,  status:VALID,  product: WSM - Shop Floor Management ,  description: To define an organization parameter for OSFM, the organization should satisfy the following conditions;1. Standard Costing organization.2. LotNumber Uniqueness in Inventory parameters should be NONE.3. LotNumber Default Type in WIP paramete ,  implementation_dba_data: WSM.WSM_PARAMETERS , 

  • Table: WSM_PARAMETERS 12.2.2

    owner:WSM,  object_type:TABLE,  fnd_design_data:WSM.WSM_PARAMETERS,  object_name:WSM_PARAMETERS,  status:VALID,  product: WSM - Shop Floor Management ,  description: To define an organization parameter for OSFM, the organization should satisfy the following conditions;1. Standard Costing organization.2. LotNumber Uniqueness in Inventory parameters should be NONE.3. LotNumber Default Type in WIP paramete ,  implementation_dba_data: WSM.WSM_PARAMETERS ,