Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - WSM Tables and Views

TABLE - WSM.WSM_CO_PRODUCTS
TABLE - WSM.WSM_CO_PROD_COMP_SUBSTITUTES
TABLE - WSM.WSM_CO_PROD_SUBSTITUTES
TABLE - WSM.WSM_INTERFACE_ERRORS
TABLE - WSM.WSM_ITEM_EXTENSIONS
TABLE - WSM.WSM_LOT_JOB_INTERFACE
TABLE - WSM.WSM_LOT_MOVE_TXN_INTERFACE
TABLE - WSM.WSM_LOT_SPLIT_MERGES
TABLE - WSM.WSM_LOT_SPLIT_MERGES_INTERFACE
TABLE - WSM.WSM_OPERATION_DETAILS
TABLE - WSM.WSM_PARAMETERS
TABLE - WSM.WSM_RESULTING_JOBS_INTERFACE
TABLE - WSM.WSM_RESULTING_LOTS_INTERFACE
TABLE - WSM.WSM_SECTOR_EXTENSIONS
TABLE - WSM.WSM_SM_RESULTING_JOBS
TABLE - WSM.WSM_SM_RESULTING_LOTS
TABLE - WSM.WSM_SM_STARTING_JOBS
TABLE - WSM.WSM_SM_STARTING_LOTS
TABLE - WSM.WSM_SPLIT_MERGE_SNAPSHOT
TABLE - WSM.WSM_SPLIT_MERGE_TRANSACTIONS
TABLE - WSM.WSM_SPLIT_MERGE_TXN_INTERFACE
TABLE - WSM.WSM_STARTING_JOBS_INTERFACE
TABLE - WSM.WSM_STARTING_LOTS_INTERFACE
TABLE - WSM.WSM_SUBINVENTORY_EXTENSIONS
VIEW - APPS.WSM_ALL_OPERATIONS_V
VIEW - APPS.WSM_COMPONENTS_V
VIEW - APPS.WSM_COPRODUCT_SPLIT_DATES_V
VIEW - APPS.WSM_COPRODUCT_SPLIT_PERC_V
VIEW - APPS.WSM_COPY_ALL_OPERATIONS_V
VIEW - APPS.WSM_COPY_NEXT_OPERATIONS_V
VIEW - APPS.WSM_CO_PRODUCTS_V
VIEW - APPS.WSM_CO_PRODUCT_COMPONENTS_V
VIEW - APPS.WSM_CO_PROD_COMP_SUBSTITUTES_V
VIEW - APPS.WSM_DISCRETE_JOBS_V
VIEW - APPS.WSM_INV_GENEALOGY_V
VIEW - APPS.WSM_INV_TXNS_WIP_LOTS_V
VIEW - APPS.WSM_ITEM_EXTENSIONS_V
VIEW - APPS.WSM_NEXT_OPERATIONS_V
VIEW - APPS.WSM_OPERATION_DETAILS_V
VIEW - APPS.WSM_SM_RESULTING_JOBS_V
VIEW - APPS.WSM_SM_STARTING_JOBS_V
VIEW - APPS.WSM_SOURCE_LOTS_V
VIEW - APPS.WSM_STANDARD_CLASSES_VAL_V
VIEW - APPS.WSM_WIP_GENEALOGY_V
VIEW - APPS.WSM_WIP_LOT_TXNS_V
VIEW - APPS.WSM_WIP_OPERATIONS_V

Table: WSM_CO_PRODUCTS

Description: Definition of OSFM Co-product relationship
Primary Key: WSM_CO_PRODUCTS_PK
  1. CO_PRODUCT_GROUP_ID
  2. COMPONENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_CO_PRODUCTS.BILL_SEQUENCE_ID BOM_BILL_OF_MATERIALS
WSM_CO_PRODUCTS.COMPONENT_SEQUENCE_ID BOM_INVENTORY_COMPONENTS
WSM_CO_PRODUCTS.SUPPLY_LOCATOR_ID
WSM_CO_PRODUCTS.ORGANIZATION_ID 		MTL_ITEM_LOCATIONS
WSM_CO_PRODUCTS.SUPPLY_SUBINVENTORY
WSM_CO_PRODUCTS.ORGANIZATION_ID 		MTL_SECONDARY_INVENTORIES
WSM_CO_PRODUCTS.ORGANIZATION_ID %

[top of page]

WSM.WSM_CO_PRODUCTS does not reference any database object

WSM.WSM_CO_PRODUCTS is referenced by following:

APPS
SYNONYM - WSM_CO_PRODUCTS

[top of page]

Table: WSM_CO_PROD_COMP_SUBSTITUTES

Description: Substitute Component Details for co-product group component.
Primary Key: WSM_CO_PROD_COMP_SUBSTITUT_PK
  1. CO_PRODUCT_GROUP_ID
  2. SUBSTITUTE_COMPONENT_ID

[top of page]

WSM.WSM_CO_PROD_COMP_SUBSTITUTES does not reference any database object

WSM.WSM_CO_PROD_COMP_SUBSTITUTES is referenced by following:

APPS
SYNONYM - WSM_CO_PROD_COMP_SUBSTITUTES

[top of page]

Table: WSM_CO_PROD_SUBSTITUTES

Description: Details of Substitute Co-product for the coproducs in a coproduct group..
Primary Key: WSM_CO_PROD_SUBSTITUTES_PK
  1. CO_PRODUCT_GROUP_ID
  2. CO_PRODUCT_ID
  3. SUBSTITUTE_CO_PRODUCT_ID

[top of page]

WSM.WSM_CO_PROD_SUBSTITUTES does not reference any database object

WSM.WSM_CO_PROD_SUBSTITUTES is referenced by following:

APPS
SYNONYM - WSM_CO_PROD_SUBSTITUTES

[top of page]

Table: WSM_INTERFACE_ERRORS

Description: Table for capturing information regarding errors encountered in processing records in OSFM Interface tables.

[top of page]

WSM.WSM_INTERFACE_ERRORS does not reference any database object

WSM.WSM_INTERFACE_ERRORS is referenced by following:

APPS
SYNONYM - WSM_INTERFACE_ERRORS

[top of page]

Table: WSM_ITEM_EXTENSIONS

Description: Sector Extensions for OSFM Organization Items.
Primary Key: WSM_ITEM_EXTENSIONS_PK
  1. ORGANIZATION_ID
  2. INVENTORY_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_ITEM_EXTENSIONS.SECTOR_EXTENSION_ID %

[top of page]

WSM.WSM_ITEM_EXTENSIONS does not reference any database object

WSM.WSM_ITEM_EXTENSIONS is referenced by following:

APPS
SYNONYM - WSM_ITEM_EXTENSIONS

[top of page]

Table: WSM_LOT_JOB_INTERFACE

Description: Interface table for the Import of Lot based Jobs in OSFM.
Primary Key: WSM_LOT_JOB_INTERFACE_PK
  1. HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_LOT_JOB_INTERFACE.PRIMARY_ITEM_ID
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID
WSM_LOT_JOB_INTERFACE.ALTERNATE_BOM_DESIGNATOR 		BOM_BILL_OF_MATERIALS
WSM_LOT_JOB_INTERFACE.PRIMARY_ITEM_ID
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID
WSM_LOT_JOB_INTERFACE.ALTERNATE_ROUTING_DESIGNATOR 		BOM_OPERATIONAL_ROUTINGS
WSM_LOT_JOB_INTERFACE.COMPLETION_LOCATOR_ID
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID 		MTL_ITEM_LOCATIONS
WSM_LOT_JOB_INTERFACE.COMPLETION_SUBINVENTORY
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID 		MTL_SECONDARY_INVENTORIES
WSM_LOT_JOB_INTERFACE.CLASS_CODE
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID 		WIP_ACCOUNTING_CLASSES
WSM_LOT_JOB_INTERFACE.JOB_NAME
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID 		WIP_ENTITIES
WSM_LOT_JOB_INTERFACE.WIP_ENTITY_ID WIP_ENTITIES
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID WSM_PARAMETERS

[top of page]

WSM.WSM_LOT_JOB_INTERFACE does not reference any database object

WSM.WSM_LOT_JOB_INTERFACE is referenced by following:

APPS
SYNONYM - WSM_LOT_JOB_INTERFACE

[top of page]

Table: WSM_LOT_MOVE_TXN_INTERFACE

Description: Interface table for the Import of Lot based Jobs Shopfloor Move Transactions in OSFM.
Primary Key: WSM_LOT_MOVE_TXN_INTERFACE_PK
  1. HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_LOT_MOVE_TXN_INTERFACE.FM_DEPARTMENT_ID BOM_DEPARTMENTS
WSM_LOT_MOVE_TXN_INTERFACE.TO_DEPARTMENT_ID BOM_DEPARTMENTS
WSM_LOT_MOVE_TXN_INTERFACE.SCRAP_ACCOUNT_ID GL_CODE_COMBINATIONS
WSM_LOT_MOVE_TXN_INTERFACE.REASON_ID MTL_TRANSACTION_REASONS
WSM_LOT_MOVE_TXN_INTERFACE.WIP_ENTITY_ID WIP_ENTITIES
WSM_LOT_MOVE_TXN_INTERFACE.LINE_ID WIP_LINES
WSM_LOT_MOVE_TXN_INTERFACE.ORGANIZATION_ID WSM_PARAMETERS

[top of page]

WSM.WSM_LOT_MOVE_TXN_INTERFACE does not reference any database object

WSM.WSM_LOT_MOVE_TXN_INTERFACE is referenced by following:

APPS
SYNONYM - WSM_LOT_MOVE_TXN_INTERFACE

[top of page]

Table: WSM_LOT_SPLIT_MERGES

Description: Base table for Lot based Inventory Transactions - Header Information.
Primary Key: WSM_LOT_SPLIT_MERGES_PK
  1. TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_LOT_SPLIT_MERGES.REASON_ID MTL_TRANSACTION_REASONS
WSM_LOT_SPLIT_MERGES.ORGANIZATION_ID WSM_PARAMETERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
WSM_SM_RESULTING_LOTS.TRANSACTION_ID WSM_LOT_SPLIT_MERGES
WSM_SM_STARTING_LOTS.TRANSACTION_ID WSM_LOT_SPLIT_MERGES

[top of page]

WSM.WSM_LOT_SPLIT_MERGES does not reference any database object

WSM.WSM_LOT_SPLIT_MERGES is referenced by following:

APPS
SYNONYM - WSM_LOT_SPLIT_MERGES

[top of page]

Table: WSM_LOT_SPLIT_MERGES_INTERFACE

Description: Interface table for Lot based Inventory Lot Transactions - Header Information.
Primary Key: WSM_LOT_SPLIT_MERGES_INTER_UK
  1. HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_LOT_SPLIT_MERGES_INTERFACE.REASON_ID MTL_TRANSACTION_REASONS
WSM_LOT_SPLIT_MERGES_INTERFACE.ORGANIZATION_ID WSM_PARAMETERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
WSM_RESULTING_LOTS_INTERFACE.HEADER_ID WSM_LOT_SPLIT_MERGES_INTERFACE
WSM_STARTING_LOTS_INTERFACE.HEADER_ID WSM_LOT_SPLIT_MERGES_INTERFACE

[top of page]

WSM.WSM_LOT_SPLIT_MERGES_INTERFACE does not reference any database object

WSM.WSM_LOT_SPLIT_MERGES_INTERFACE is referenced by following:

APPS
SYNONYM - WSM_LOT_SPLIT_MERGES_INTERFACE

[top of page]

Table: WSM_OPERATION_DETAILS

Description: OSFM Specific details for Standard Operations defined in an OSFM organization.
Primary Key: WSM_OPERATION_DETAILS_PK
  1. STANDARD_OPERATION_ID

[top of page]

WSM.WSM_OPERATION_DETAILS does not reference any database object

WSM.WSM_OPERATION_DETAILS is referenced by following:

APPS
SYNONYM - WSM_OPERATION_DETAILS

[top of page]

Table: WSM_PARAMETERS

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
Primary Key: WSM_PARAMETERS_PK
  1. ORGANIZATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_PARAMETERS.ORGANIZATION_ID MTL_PARAMETERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID WSM_PARAMETERS
WSM_LOT_MOVE_TXN_INTERFACE.ORGANIZATION_ID WSM_PARAMETERS
WSM_LOT_SPLIT_MERGES.ORGANIZATION_ID WSM_PARAMETERS
WSM_LOT_SPLIT_MERGES_INTERFACE.ORGANIZATION_ID WSM_PARAMETERS
WSM_RESULTING_LOTS_INTERFACE.ORGANIZATION_ID WSM_PARAMETERS
WSM_SECTOR_EXTENSIONS.ORGANIZATION_ID WSM_PARAMETERS
WSM_SM_RESULTING_LOTS.ORGANIZATION_ID WSM_PARAMETERS
WSM_SM_STARTING_LOTS.ORGANIZATION_ID WSM_PARAMETERS
WSM_SPLIT_MERGE_TXN_INTERFACE.ORGANIZATION_ID WSM_PARAMETERS
WSM_SPLIT_MERGE_TRANSACTIONS.ORGANIZATION_ID WSM_PARAMETERS
WSM_STARTING_LOTS_INTERFACE.ORGANIZATION_ID WSM_PARAMETERS

[top of page]

WSM.WSM_PARAMETERS does not reference any database object

WSM.WSM_PARAMETERS is referenced by following:

APPS
SYNONYM - WSM_PARAMETERS

[top of page]

Table: WSM_RESULTING_JOBS_INTERFACE

Description: Interface table for Import WIP Lot Transaction's Resulting Lots - Child Table for WSM_SPLIT_MERGE_TXN_INTERFACE.
Primary Key: WSM_RESULTING_JOBS_INTERFA_PK
  1. HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_RESULTING_JOBS_INTERFACE.HEADER_ID %
WSM_RESULTING_JOBS_INTERFACE.HEADER_ID %

[top of page]

WSM.WSM_RESULTING_JOBS_INTERFACE does not reference any database object

WSM.WSM_RESULTING_JOBS_INTERFACE is referenced by following:

APPS
SYNONYM - WSM_RESULTING_JOBS_INTERFACE

[top of page]

Table: WSM_RESULTING_LOTS_INTERFACE

Description: Interface table for Import Inventory Lot Transaction's Resulting Lots. Child Table for WSM_LOT_SPLIT_MERGES_INTERFACE.
Primary Key: WSM_RESULTING_LOTS_INTERFA_UK
  1. HEADER_ID
  2. LOT_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_RESULTING_LOTS_INTERFACE.LOCATOR_ID
WSM_RESULTING_LOTS_INTERFACE.ORGANIZATION_ID 		MTL_ITEM_LOCATIONS
WSM_RESULTING_LOTS_INTERFACE.SUBINVENTORY_CODE
WSM_RESULTING_LOTS_INTERFACE.ORGANIZATION_ID 		MTL_SECONDARY_INVENTORIES
WSM_RESULTING_LOTS_INTERFACE.HEADER_ID WSM_LOT_SPLIT_MERGES_INTERFACE
WSM_RESULTING_LOTS_INTERFACE.ORGANIZATION_ID WSM_PARAMETERS

[top of page]

WSM.WSM_RESULTING_LOTS_INTERFACE does not reference any database object

WSM.WSM_RESULTING_LOTS_INTERFACE is referenced by following:

APPS
SYNONYM - WSM_RESULTING_LOTS_INTERFACE

[top of page]

Table: WSM_SECTOR_EXTENSIONS

Description: Sector Extensions in OSFM are the segment of a manufacturing process for which a Lot based Job is defined.
Primary Key: WSM_SECTOR_EXTENSIONS_PK
  1. SECTOR_EXTENSION_ID
Primary Key: WSM_SECTOR_EXTENSIONS_UK
  1. ORGANIZATION_ID
  2. SECTOR_EXTENSION_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_SECTOR_EXTENSIONS.DEFAULT_ACCT_CLASS_CODE
WSM_SECTOR_EXTENSIONS.ORGANIZATION_ID 		WIP_ACCOUNTING_CLASSES
WSM_SECTOR_EXTENSIONS.ORGANIZATION_ID WSM_PARAMETERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
WSM_SUBINVENTORY_EXTENSIONS.SECTOR_EXTENSION_ID WSM_SECTOR_EXTENSIONS

[top of page]

WSM.WSM_SECTOR_EXTENSIONS does not reference any database object

WSM.WSM_SECTOR_EXTENSIONS is referenced by following:

APPS
SYNONYM - WSM_SECTOR_EXTENSIONS

[top of page]

Table: WSM_SM_RESULTING_JOBS

Description: Base table for Resulting Lots for WIP Lot Transactions in OSFM.
Primary Key: WSM_SM_RESULTING_JOBS_PK
  1. TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_SM_RESULTING_JOBS.WIP_ENTITY_ID WIP_ENTITIES
WSM_SM_RESULTING_JOBS.TRANSACTION_ID %

[top of page]

WSM.WSM_SM_RESULTING_JOBS does not reference any database object

WSM.WSM_SM_RESULTING_JOBS is referenced by following:

APPS
SYNONYM - WSM_SM_RESULTING_JOBS

[top of page]

Table: WSM_SM_RESULTING_LOTS

Description: Base table for Resulting Lots for Inventory Lot Transactions in OSFM.
Primary Key: WSM_SM_RESULTING_LOTS_PK
  1. TRANSACTION_ID
  2. LOT_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_SM_RESULTING_LOTS.LOCATOR_ID
WSM_SM_RESULTING_LOTS.ORGANIZATION_ID 		MTL_ITEM_LOCATIONS
WSM_SM_RESULTING_LOTS.TRANSACTION_ID WSM_LOT_SPLIT_MERGES
WSM_SM_RESULTING_LOTS.ORGANIZATION_ID WSM_PARAMETERS

[top of page]

WSM.WSM_SM_RESULTING_LOTS does not reference any database object

WSM.WSM_SM_RESULTING_LOTS is referenced by following:

APPS
SYNONYM - WSM_SM_RESULTING_LOTS

[top of page]

Table: WSM_SM_STARTING_JOBS

Description: Base table for Starting Lots for WIP Lot Transactions in OSFM.
Primary Key: WSM_SM_STARTING_JOBS_PK
  1. TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_SM_STARTING_JOBS.WIP_ENTITY_ID WIP_ENTITIES
WSM_SM_STARTING_JOBS.TRANSACTION_ID %

[top of page]

WSM.WSM_SM_STARTING_JOBS does not reference any database object

WSM.WSM_SM_STARTING_JOBS is referenced by following:

APPS
SYNONYM - WSM_SM_STARTING_JOBS

[top of page]

Table: WSM_SM_STARTING_LOTS

Description: Base table for Starting Lots for Inventory Lot Transactions in OSFM.
Primary Key: WSM_SM_STARTING_LOTS_PK
  1. TRANSACTION_ID
  2. LOT_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_SM_STARTING_LOTS.LOCATOR_ID
WSM_SM_STARTING_LOTS.ORGANIZATION_ID 		MTL_ITEM_LOCATIONS
WSM_SM_STARTING_LOTS.SUBINVENTORY_CODE
WSM_SM_STARTING_LOTS.ORGANIZATION_ID 		MTL_SECONDARY_INVENTORIES
WSM_SM_STARTING_LOTS.TRANSACTION_ID WSM_LOT_SPLIT_MERGES
WSM_SM_STARTING_LOTS.ORGANIZATION_ID WSM_PARAMETERS

[top of page]

WSM.WSM_SM_STARTING_LOTS does not reference any database object

WSM.WSM_SM_STARTING_LOTS is referenced by following:

APPS
SYNONYM - WSM_SM_STARTING_LOTS

[top of page]

Table: WSM_SPLIT_MERGE_SNAPSHOT

Description: WIP Lot Transactions Snapshot table for Shop Floor cost processor.
Primary Key: WSM_SPLIT_MERGE_SNAPSHOT_PK
  1. TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_SPLIT_MERGE_SNAPSHOT.WIP_ENTITY_ID WIP_ENTITIES

[top of page]

WSM.WSM_SPLIT_MERGE_SNAPSHOT does not reference any database object

WSM.WSM_SPLIT_MERGE_SNAPSHOT is referenced by following:

APPS
SYNONYM - WSM_SPLIT_MERGE_SNAPSHOT

[top of page]

Table: WSM_SPLIT_MERGE_TRANSACTIONS

Description: Base table for header information for WIP Lot Transactions in OSFM.
Primary Key: WSM_SPLIT_MERGE_TRANSACTIO_PK
  1. TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_SPLIT_MERGE_TRANSACTIONS.REASON_ID MTL_TRANSACTION_REASONS
WSM_SPLIT_MERGE_TRANSACTIONS.ORGANIZATION_ID WSM_PARAMETERS

[top of page]

WSM.WSM_SPLIT_MERGE_TRANSACTIONS does not reference any database object

WSM.WSM_SPLIT_MERGE_TRANSACTIONS is referenced by following:

APPS
SYNONYM - WSM_SPLIT_MERGE_TRANSACTIONS

[top of page]

Table: WSM_SPLIT_MERGE_TXN_INTERFACE

Description: Interface table for Lot based WIP Lot Transactions.
Primary Key: WSM_SPLIT_MERGE_TXN_INTERF_PK
  1. HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_SPLIT_MERGE_TXN_INTERFACE.REASON_ID MTL_TRANSACTION_REASONS
WSM_SPLIT_MERGE_TXN_INTERFACE.ORGANIZATION_ID WSM_PARAMETERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
WSM_STARTING_JOBS_INTERFACE.HEADER_ID WSM_SPLIT_MERGE_TXN_INTERFACE
WSM_STARTING_JOBS_INTERFACE.HEADER_ID WSM_SPLIT_MERGE_TXN_INTERFACE

[top of page]

WSM.WSM_SPLIT_MERGE_TXN_INTERFACE does not reference any database object

WSM.WSM_SPLIT_MERGE_TXN_INTERFACE is referenced by following:

APPS
SYNONYM - WSM_SPLIT_MERGE_TXN_INTERFACE

[top of page]

Table: WSM_STARTING_JOBS_INTERFACE

Description: Interface table for Import WIP Lot Transaction's Starting Lots. Child table for WSM_SPLIT_MERGE_TXN_INTERFACE.
Primary Key: WSM_STARTING_JOBS_INTERFAC_PK
  1. HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_STARTING_JOBS_INTERFACE.WIP_ENTITY_ID WIP_ENTITIES
WSM_STARTING_JOBS_INTERFACE.HEADER_ID WSM_SPLIT_MERGE_TXN_INTERFACE
WSM_STARTING_JOBS_INTERFACE.HEADER_ID WSM_SPLIT_MERGE_TXN_INTERFACE

[top of page]

WSM.WSM_STARTING_JOBS_INTERFACE does not reference any database object

WSM.WSM_STARTING_JOBS_INTERFACE is referenced by following:

APPS
SYNONYM - WSM_STARTING_JOBS_INTERFACE

[top of page]

Table: WSM_STARTING_LOTS_INTERFACE

Description: Interface table for Import Inventory Lot Transaction's Starting Lots. Child table for WSM_LOT_SPLIT_MERGES_INTERFACE.
Primary Key: WSM_STARTING_LOTS_INTERFAC_UK
  1. HEADER_ID
  2. LOT_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_STARTING_LOTS_INTERFACE.LOCATOR_ID
WSM_STARTING_LOTS_INTERFACE.ORGANIZATION_ID 		MTL_ITEM_LOCATIONS
WSM_STARTING_LOTS_INTERFACE.SUBINVENTORY_CODE
WSM_STARTING_LOTS_INTERFACE.ORGANIZATION_ID 		MTL_SECONDARY_INVENTORIES
WSM_STARTING_LOTS_INTERFACE.HEADER_ID WSM_LOT_SPLIT_MERGES_INTERFACE
WSM_STARTING_LOTS_INTERFACE.ORGANIZATION_ID WSM_PARAMETERS

[top of page]

WSM.WSM_STARTING_LOTS_INTERFACE does not reference any database object

WSM.WSM_STARTING_LOTS_INTERFACE is referenced by following:

APPS
SYNONYM - WSM_STARTING_LOTS_INTERFACE

[top of page]

Table: WSM_SUBINVENTORY_EXTENSIONS

Description: Sector Extensions associated with a subinventory in an OSFM organization.
Primary Key: WSM_SUBINVENTORY_EXTENSION_PK
  1. ORGANIZATION_ID
  2. SECONDARY_INVENTORY_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
WSM_SUBINVENTORY_EXTENSIONS.SECONDARY_INVENTORY_NAME
WSM_SUBINVENTORY_EXTENSIONS.ORGANIZATION_ID 		MTL_SECONDARY_INVENTORIES
WSM_SUBINVENTORY_EXTENSIONS.SECTOR_EXTENSION_ID WSM_SECTOR_EXTENSIONS

[top of page]

WSM.WSM_SUBINVENTORY_EXTENSIONS does not reference any database object

WSM.WSM_SUBINVENTORY_EXTENSIONS is referenced by following:

APPS
SYNONYM - WSM_SUBINVENTORY_EXTENSIONS

[top of page]

View: WSM_ALL_OPERATIONS_V

[top of page]

APPS.WSM_ALL_OPERATIONS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - BOM_OPERATIONAL_ROUTINGS
SYNONYM - BOM_OPERATION_NETWORKS
SYNONYM - BOM_OPERATION_SEQUENCES
SYNONYM - BOM_STANDARD_OPERATIONS
SYNONYM - WIP_DISCRETE_JOBS

APPS.WSM_ALL_OPERATIONS_V is not referenced by any database object

[top of page]

View: WSM_COMPONENTS_V

[top of page]

APPS.WSM_COMPONENTS_V references the following:

APPS
VIEW - BOM_BILL_OF_MATERIALS
VIEW - BOM_INVENTORY_COMPONENTS
SYNONYM - BOM_SUBSTITUTE_COMPONENTS
PACKAGE - FND_GLOBAL
SYNONYM - MTL_SYSTEM_ITEMS
APPS.WSM_COMPONENTS_V is referenced by following:

APPS
PACKAGE BODY - WSMPLBJT

[top of page]

View: WSM_COPRODUCT_SPLIT_DATES_V

[top of page]

APPS.WSM_COPRODUCT_SPLIT_DATES_V references the following:

APPS
SYNONYM - WSM_COPRODUCT_SPLIT_PERC

APPS.WSM_COPRODUCT_SPLIT_DATES_V is not referenced by any database object

[top of page]

View: WSM_COPRODUCT_SPLIT_PERC_V

[top of page]

APPS.WSM_COPRODUCT_SPLIT_PERC_V references the following:

APPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WSM_COPRODUCT_SPLIT_PERC

APPS.WSM_COPRODUCT_SPLIT_PERC_V is not referenced by any database object

[top of page]

View: WSM_COPY_ALL_OPERATIONS_V

[top of page]

APPS.WSM_COPY_ALL_OPERATIONS_V references the following:

APPS
SYNONYM - WSM_COPY_OPERATIONS
SYNONYM - WSM_COPY_OP_NETWORKS

APPS.WSM_COPY_ALL_OPERATIONS_V is not referenced by any database object

[top of page]

View: WSM_COPY_NEXT_OPERATIONS_V

[top of page]

APPS.WSM_COPY_NEXT_OPERATIONS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - BOM_OPERATION_SEQUENCES
SYNONYM - BOM_STANDARD_OPERATIONS
SYNONYM - WIP_DISCRETE_JOBS
SYNONYM - WIP_OPERATIONS
SYNONYM - WSM_COPY_OPERATIONS
SYNONYM - WSM_COPY_OP_NETWORKS
SYNONYM - WSM_PARAMETERS

APPS.WSM_COPY_NEXT_OPERATIONS_V is not referenced by any database object

[top of page]

View: WSM_CO_PRODUCTS_V

[top of page]

APPS.WSM_CO_PRODUCTS_V references the following:

APPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WSM_CO_PRODUCTS

APPS.WSM_CO_PRODUCTS_V is not referenced by any database object

[top of page]

View: WSM_CO_PRODUCT_COMPONENTS_V

[top of page]

APPS.WSM_CO_PRODUCT_COMPONENTS_V references the following:

APPS
VIEW - FND_COMMON_LOOKUPS
PACKAGE - FND_GLOBAL
VIEW - MFG_LOOKUPS
SYNONYM - MTL_SYSTEM_ITEMS
PACKAGE - WSMPCOGI
SYNONYM - WSM_CO_PRODUCTS

APPS.WSM_CO_PRODUCT_COMPONENTS_V is not referenced by any database object

[top of page]

View: WSM_CO_PROD_COMP_SUBSTITUTES_V

[top of page]

APPS.WSM_CO_PROD_COMP_SUBSTITUTES_V references the following:

APPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WSM_CO_PRODUCTS
SYNONYM - WSM_CO_PROD_COMP_SUBSTITUTES

APPS.WSM_CO_PROD_COMP_SUBSTITUTES_V is not referenced by any database object

[top of page]

View: WSM_DISCRETE_JOBS_V

[top of page]

APPS.WSM_DISCRETE_JOBS_V references the following:

APPS
VIEW - MFG_LOOKUPS
SYNONYM - MTL_KANBAN_CARDS
SYNONYM - MTL_SECONDARY_INVENTORIES
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WIP_DISCRETE_JOBS
SYNONYM - WIP_ENTITIES
SYNONYM - WIP_LINES
SYNONYM - WIP_SCHEDULE_GROUPS

APPS.WSM_DISCRETE_JOBS_V is not referenced by any database object

[top of page]

View: WSM_INV_GENEALOGY_V

[top of page]

APPS.WSM_INV_GENEALOGY_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
VIEW - MFG_LOOKUPS
SYNONYM - MTL_MATERIAL_TRANSACTIONS
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_TRANSACTION_TYPES
SYNONYM - MTL_TXN_SOURCE_TYPES

APPS.WSM_INV_GENEALOGY_V is not referenced by any database object

[top of page]

View: WSM_INV_TXNS_WIP_LOTS_V

[top of page]

APPS.WSM_INV_TXNS_WIP_LOTS_V references the following:

APPS
PACKAGE - INV_OBJECT_GENEALOGY
SYNONYM - MTL_MATERIAL_TRANSACTIONS
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_TXN_SOURCE_TYPES
SYNONYM - WIP_ENTITIES
SYNONYM - WMS_LICENSE_PLATE_NUMBERS
APPS.WSM_INV_TXNS_WIP_LOTS_V is referenced by following:

APPS
PACKAGE BODY - INV_GENEALOGY_REPORT_GEN

[top of page]

View: WSM_ITEM_EXTENSIONS_V

[top of page]

APPS.WSM_ITEM_EXTENSIONS_V references the following:

APPS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - WSM_ITEM_EXTENSIONS

APPS.WSM_ITEM_EXTENSIONS_V is not referenced by any database object

[top of page]

View: WSM_NEXT_OPERATIONS_V

[top of page]

APPS.WSM_NEXT_OPERATIONS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - BOM_OPERATIONAL_ROUTINGS
SYNONYM - BOM_OPERATION_NETWORKS
SYNONYM - BOM_OPERATION_SEQUENCES
SYNONYM - BOM_STANDARD_OPERATIONS
SYNONYM - WIP_DISCRETE_JOBS
SYNONYM - WIP_OPERATIONS
SYNONYM - WSM_PARAMETERS

APPS.WSM_NEXT_OPERATIONS_V is not referenced by any database object

[top of page]

View: WSM_OPERATION_DETAILS_V

[top of page]

APPS.WSM_OPERATION_DETAILS_V references the following:

APPS
SYNONYM - BOM_STANDARD_OPERATIONS
SYNONYM - WSM_OPERATION_DETAILS
APPS.WSM_OPERATION_DETAILS_V is referenced by following:

APPS
PACKAGE BODY - M4R_7B1_WSM_IN

[top of page]

View: WSM_SM_RESULTING_JOBS_V

[top of page]

APPS.WSM_SM_RESULTING_JOBS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - BOM_STANDARD_OPERATIONS
VIEW - MFG_LOOKUPS
SYNONYM - WIP_OPERATIONS
SYNONYM - WSM_SM_RESULTING_JOBS
SYNONYM - WSM_SM_STARTING_JOBS
SYNONYM - WSM_SPLIT_MERGE_TRANSACTIONS

APPS.WSM_SM_RESULTING_JOBS_V is not referenced by any database object

[top of page]

View: WSM_SM_STARTING_JOBS_V

[top of page]

APPS.WSM_SM_STARTING_JOBS_V references the following:

APPS
VIEW - BOM_BILL_OF_MATERIALS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - BOM_OPERATIONAL_ROUTINGS
SYNONYM - BOM_OPERATION_SEQUENCES
SYNONYM - BOM_STANDARD_OPERATIONS
PACKAGE - FND_GLOBAL
VIEW - MFG_LOOKUPS
SYNONYM - MTL_KANBAN_CARDS
SYNONYM - WIP_DISCRETE_JOBS
SYNONYM - WIP_OPERATIONS
SYNONYM - WSM_SM_STARTING_JOBS

APPS.WSM_SM_STARTING_JOBS_V is not referenced by any database object

[top of page]

View: WSM_SOURCE_LOTS_V

[top of page]

APPS.WSM_SOURCE_LOTS_V references the following:

APPS
SYNONYM - MTL_LOT_NUMBERS
SYNONYM - MTL_ONHAND_QUANTITIES_DETAIL
SYNONYM - MTL_SECONDARY_INVENTORIES
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - WSM_SUBINVENTORY_EXTENSIONS
APPS.WSM_SOURCE_LOTS_V is referenced by following:

APPS
PACKAGE BODY - INV_KANBAN_PKG
PACKAGE BODY - WSMPINVL
PACKAGE BODY - WSMPLBJI
PACKAGE BODY - WSM_LBJ_INTERFACE_PVT

[top of page]

View: WSM_STANDARD_CLASSES_VAL_V

[top of page]

APPS.WSM_STANDARD_CLASSES_VAL_V references the following:

APPS
SYNONYM - WIP_ACCOUNTING_CLASSES

APPS.WSM_STANDARD_CLASSES_VAL_V is not referenced by any database object

[top of page]

View: WSM_WIP_GENEALOGY_V

[top of page]

APPS.WSM_WIP_GENEALOGY_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
PACKAGE - PJM_PROJECT
VIEW - WIP_DISCRETE_JOBS_V
APPS.WSM_WIP_GENEALOGY_V is referenced by following:

APPS
PACKAGE BODY - M4R_7B5_OSFM_PKG

[top of page]

View: WSM_WIP_LOT_TXNS_V

[top of page]

APPS.WSM_WIP_LOT_TXNS_V references the following:

APPS
SYNONYM - BOM_OPERATIONAL_ROUTINGS
VIEW - MFG_LOOKUPS
SYNONYM - WIP_ENTITIES
SYNONYM - WSM_SM_RESULTING_JOBS
SYNONYM - WSM_SM_STARTING_JOBS
SYNONYM - WSM_SPLIT_MERGE_TRANSACTIONS
APPS.WSM_WIP_LOT_TXNS_V is referenced by following:

APPS
PACKAGE BODY - INV_GENEALOGY_REPORT_GEN

[top of page]

View: WSM_WIP_OPERATIONS_V

[top of page]

APPS.WSM_WIP_OPERATIONS_V references the following:

APPS
SYNONYM - WIP_OPERATIONS

APPS.WSM_WIP_OPERATIONS_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract