FND Design Data [Home] [Help]

Table: WSM_SM_STARTING_LOTS

Product: WSM - Shop Floor Management
Description: Base table for Starting Lots for Inventory Lot Transactions in OSFM.
Implementation/DBA Data: TableWSM.WSM_SM_STARTING_LOTS
Primary Key: WSM_SM_STARTING_LOTS_PK
  1. ColumnTRANSACTION_ID
  2. ColumnLOT_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
WSM_SM_STARTING_LOTS FK Joins to TableMTL_ITEM_LOCATIONS WSM_SM_STARTING_LOTS.LOCATOR_ID
WSM_SM_STARTING_LOTS.ORGANIZATION_ID
WSM_SM_STARTING_LOTS FK Joins to TableMTL_SECONDARY_INVENTORIES WSM_SM_STARTING_LOTS.SUBINVENTORY_CODE
WSM_SM_STARTING_LOTS.ORGANIZATION_ID
WSM_SM_STARTING_LOTS FK Joins to TableWSM_LOT_SPLIT_MERGES WSM_SM_STARTING_LOTS.TRANSACTION_ID
WSM_SM_STARTING_LOTS FK Joins to TableWSM_PARAMETERS WSM_SM_STARTING_LOTS.ORGANIZATION_ID