WSM Tables (24)

WSM - Shop Floor Management — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
WSM_CO_PRODUCTS	65	Definition of OSFM Co-product relationship
WSM_CO_PROD_COMP_SUBSTITUTES	29	Substitute Component Details for co-product group component.
WSM_CO_PROD_SUBSTITUTES	28	Details of Substitute Co-product for the coproducs in a coproduct group..
WSM_INTERFACE_ERRORS	12	Table for capturing information regarding errors encountered in processing records in OSFM Interface tables.
WSM_ITEM_EXTENSIONS	8	Sector Extensions for OSFM Organization Items.
WSM_LOT_JOB_INTERFACE	108	Interface table for the Import of Lot based Jobs in OSFM.
WSM_LOT_MOVE_TXN_INTERFACE	80	Interface table for the Import of Lot based Jobs Shopfloor Move Transactions in OSFM.
WSM_LOT_SPLIT_MERGES	37	Base table for Lot based Inventory Transactions - Header Information.
WSM_LOT_SPLIT_MERGES_INTERFACE	39	Interface table for Lot based Inventory Lot Transactions - Header Information.
WSM_OPERATION_DETAILS	12	OSFM Specific details for Standard Operations defined in an OSFM organization.
WSM_PARAMETERS	25	To define an organization parameter for OSFM, the organization should satisfy the following conditions;1. Standard Costing organization.2. L
WSM_RESULTING_JOBS_INTERFACE	63	Interface table for Import WIP Lot Transaction's Resulting Lots - Child Table for WSM_SPLIT_MERGE_TXN_INTERFACE.
WSM_RESULTING_LOTS_INTERFACE	36	Interface table for Import Inventory Lot Transaction's Resulting Lots. Child Table for WSM_LOT_SPLIT_MERGES_INTERFACE.
WSM_SECTOR_EXTENSIONS	10	Sector Extensions in OSFM are the segment of a manufacturing process for which a Lot based Job is defined.
WSM_SM_RESULTING_JOBS	61	Base table for Resulting Lots for WIP Lot Transactions in OSFM.
WSM_SM_RESULTING_LOTS	34	Base table for Resulting Lots for Inventory Lot Transactions in OSFM.
WSM_SM_STARTING_JOBS	53	Base table for Starting Lots for WIP Lot Transactions in OSFM.
WSM_SM_STARTING_LOTS	34	Base table for Starting Lots for Inventory Lot Transactions in OSFM.
WSM_SPLIT_MERGE_SNAPSHOT	13	WIP Lot Transactions Snapshot table for Shop Floor cost processor.
WSM_SPLIT_MERGE_TRANSACTIONS	39	Base table for header information for WIP Lot Transactions in OSFM.
WSM_SPLIT_MERGE_TXN_INTERFACE	38	Interface table for Lot based WIP Lot Transactions.
WSM_STARTING_JOBS_INTERFACE	39	Interface table for Import WIP Lot Transaction's Starting Lots. Child table for WSM_SPLIT_MERGE_TXN_INTERFACE.
WSM_STARTING_LOTS_INTERFACE	37	Interface table for Import Inventory Lot Transaction's Starting Lots. Child table for WSM_LOT_SPLIT_MERGES_INTERFACE.
WSM_SUBINVENTORY_EXTENSIONS	8	Sector Extensions associated with a subinventory in an OSFM organization.