WSM — Shop Floor Management
24 documented tables · 22 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
WSM_PARAMETERS |
To define an organization parameter for OSFM, the organization should satisfy the following conditions;1. Stan | hub-leaning |
WSM_LOT_SPLIT_MERGES |
Base table for Lot based Inventory Transactions - Header Information. | satellite-leaning |
WSM_SECTOR_EXTENSIONS |
Sector Extensions in OSFM are the segment of a manufacturing process for which a Lot based Job is defined. | satellite-leaning |
WSM_LOT_SPLIT_MERGES_INTERFACE |
Interface table for Lot based Inventory Lot Transactions - Header Information. | satellite-leaning |
WSM_SPLIT_MERGE_TXN_INTERFACE |
Interface table for Lot based WIP Lot Transactions. | satellite-leaning |
WSM_SM_STARTING_LOTS |
Base table for Starting Lots for Inventory Lot Transactions in OSFM. | link |
WSM_CO_PROD_COMP_SUBSTITUTES |
Substitute Component Details for co-product group component. | standalone |
WSM_SPLIT_MERGE_SNAPSHOT |
WIP Lot Transactions Snapshot table for Shop Floor cost processor. | satellite-leaning |
WSM_ITEM_EXTENSIONS |
Sector Extensions for OSFM Organization Items. | satellite-leaning |
WSM_SM_RESULTING_LOTS |
Base table for Resulting Lots for Inventory Lot Transactions in OSFM. | link |
WSM_RESULTING_JOBS_INTERFACE |
Interface table for Import WIP Lot Transaction's Resulting Lots - Child Table for WSM_SPLIT_MERGE_TXN_INTERFAC | link |
WSM_SPLIT_MERGE_TRANSACTIONS |
Base table for header information for WIP Lot Transactions in OSFM. | link |
WSM_CO_PROD_SUBSTITUTES |
Details of Substitute Co-product for the coproducs in a coproduct group.. | standalone |
WSM_LOT_MOVE_TXN_INTERFACE |
Interface table for the Import of Lot based Jobs Shopfloor Move Transactions in OSFM. | link |
WSM_LOT_JOB_INTERFACE |
Interface table for the Import of Lot based Jobs in OSFM. | link |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
WSM_SERIAL_SUPPORT_GRP |
GRP | 2 | 7 packages |
WSM_RESERVATIONS_GRP |
GRP | 2 | 2 packages |
WSM_JOBPURGE_GRP |
GRP | 1 | 1 packages |
WSM_JOBCOSTING_GRP |
GRP | 2 | 1 packages |
WSM_INFINITE_SCHEDULER_GRP |
GRP | 1 | 0 packages |
WSM_JOBCOPIES_PUB |
PUB | 1 | 0 packages |