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.
Description: | Definition of OSFM Co-product relationship |
---|
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 | % |
WSM.WSM_CO_PRODUCTS does not reference any database object
WSM.WSM_CO_PRODUCTS is referenced by following:
Description: | Substitute Component Details for co-product group component. |
---|
WSM.WSM_CO_PROD_COMP_SUBSTITUTES does not reference any database object
WSM.WSM_CO_PROD_COMP_SUBSTITUTES is referenced by following:
Description: | Details of Substitute Co-product for the coproducs in a coproduct group.. |
---|
WSM.WSM_CO_PROD_SUBSTITUTES does not reference any database object
WSM.WSM_CO_PROD_SUBSTITUTES is referenced by following:
Description: | Table for capturing information regarding errors encountered in processing records in OSFM Interface tables. |
---|
WSM.WSM_INTERFACE_ERRORS does not reference any database object
WSM.WSM_INTERFACE_ERRORS is referenced by following:
Description: | Sector Extensions for OSFM Organization Items. |
---|
Foreign Key Column | Foreign Table |
---|---|
WSM_ITEM_EXTENSIONS.SECTOR_EXTENSION_ID | % |
WSM.WSM_ITEM_EXTENSIONS does not reference any database object
WSM.WSM_ITEM_EXTENSIONS is referenced by following:
Description: | Interface table for the Import of Lot based Jobs in OSFM. |
---|
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 |
WSM.WSM_LOT_JOB_INTERFACE does not reference any database object
WSM.WSM_LOT_JOB_INTERFACE is referenced by following:
Description: | Interface table for the Import of Lot based Jobs Shopfloor Move Transactions in OSFM. |
---|
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 |
WSM.WSM_LOT_MOVE_TXN_INTERFACE does not reference any database object
WSM.WSM_LOT_MOVE_TXN_INTERFACE is referenced by following:
Description: | Base table for Lot based Inventory Transactions - Header Information. |
---|
Foreign Key Column | Foreign Table |
---|---|
WSM_LOT_SPLIT_MERGES.REASON_ID | MTL_TRANSACTION_REASONS |
WSM_LOT_SPLIT_MERGES.ORGANIZATION_ID | WSM_PARAMETERS |
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 |
WSM.WSM_LOT_SPLIT_MERGES does not reference any database object
WSM.WSM_LOT_SPLIT_MERGES is referenced by following:
Description: | Interface table for Lot based Inventory Lot Transactions - Header Information. |
---|
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 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 |
WSM.WSM_LOT_SPLIT_MERGES_INTERFACE does not reference any database object
WSM.WSM_LOT_SPLIT_MERGES_INTERFACE is referenced by following:
Description: | OSFM Specific details for Standard Operations defined in an OSFM organization. |
---|
WSM.WSM_OPERATION_DETAILS does not reference any database object
WSM.WSM_OPERATION_DETAILS is referenced by following:
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 |
---|
Foreign Key Column | Foreign Table |
---|---|
WSM_PARAMETERS.ORGANIZATION_ID | MTL_PARAMETERS |
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 |
WSM.WSM_PARAMETERS does not reference any database object
WSM.WSM_PARAMETERS is referenced by following:
Description: | Interface table for Import WIP Lot Transaction's Resulting Lots - Child Table for WSM_SPLIT_MERGE_TXN_INTERFACE. |
---|
Foreign Key Column | Foreign Table |
---|---|
WSM_RESULTING_JOBS_INTERFACE.HEADER_ID | % |
WSM_RESULTING_JOBS_INTERFACE.HEADER_ID | % |
WSM.WSM_RESULTING_JOBS_INTERFACE does not reference any database object
WSM.WSM_RESULTING_JOBS_INTERFACE is referenced by following:
Description: | Interface table for Import Inventory Lot Transaction's Resulting Lots. Child Table for WSM_LOT_SPLIT_MERGES_INTERFACE. |
---|
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 |
WSM.WSM_RESULTING_LOTS_INTERFACE does not reference any database object
WSM.WSM_RESULTING_LOTS_INTERFACE is referenced by following:
Description: | Sector Extensions in OSFM are the segment of a manufacturing process for which a Lot based Job is defined. |
---|
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 Key Column | Foreign Table |
---|---|
WSM_SUBINVENTORY_EXTENSIONS.SECTOR_EXTENSION_ID | WSM_SECTOR_EXTENSIONS |
WSM.WSM_SECTOR_EXTENSIONS does not reference any database object
WSM.WSM_SECTOR_EXTENSIONS is referenced by following:
Description: | Base table for Resulting Lots for WIP Lot Transactions in OSFM. |
---|
Foreign Key Column | Foreign Table |
---|---|
WSM_SM_RESULTING_JOBS.WIP_ENTITY_ID | WIP_ENTITIES |
WSM_SM_RESULTING_JOBS.TRANSACTION_ID | % |
WSM.WSM_SM_RESULTING_JOBS does not reference any database object
WSM.WSM_SM_RESULTING_JOBS is referenced by following:
Description: | Base table for Resulting Lots for Inventory Lot Transactions in OSFM. |
---|
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 |
WSM.WSM_SM_RESULTING_LOTS does not reference any database object
WSM.WSM_SM_RESULTING_LOTS is referenced by following:
Description: | Base table for Starting Lots for WIP Lot Transactions in OSFM. |
---|
Foreign Key Column | Foreign Table |
---|---|
WSM_SM_STARTING_JOBS.WIP_ENTITY_ID | WIP_ENTITIES |
WSM_SM_STARTING_JOBS.TRANSACTION_ID | % |
WSM.WSM_SM_STARTING_JOBS does not reference any database object
WSM.WSM_SM_STARTING_JOBS is referenced by following:
Description: | Base table for Starting Lots for Inventory Lot Transactions in OSFM. |
---|
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 |
WSM.WSM_SM_STARTING_LOTS does not reference any database object
WSM.WSM_SM_STARTING_LOTS is referenced by following:
Description: | WIP Lot Transactions Snapshot table for Shop Floor cost processor. |
---|
Foreign Key Column | Foreign Table |
---|---|
WSM_SPLIT_MERGE_SNAPSHOT.WIP_ENTITY_ID | WIP_ENTITIES |
WSM.WSM_SPLIT_MERGE_SNAPSHOT does not reference any database object
WSM.WSM_SPLIT_MERGE_SNAPSHOT is referenced by following:
Description: | Base table for header information for WIP Lot Transactions in OSFM. |
---|
Foreign Key Column | Foreign Table |
---|---|
WSM_SPLIT_MERGE_TRANSACTIONS.REASON_ID | MTL_TRANSACTION_REASONS |
WSM_SPLIT_MERGE_TRANSACTIONS.ORGANIZATION_ID | WSM_PARAMETERS |
WSM.WSM_SPLIT_MERGE_TRANSACTIONS does not reference any database object
WSM.WSM_SPLIT_MERGE_TRANSACTIONS is referenced by following:
Description: | Interface table for Lot based WIP Lot Transactions. |
---|
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 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 |
WSM.WSM_SPLIT_MERGE_TXN_INTERFACE does not reference any database object
WSM.WSM_SPLIT_MERGE_TXN_INTERFACE is referenced by following:
Description: | Interface table for Import WIP Lot Transaction's Starting Lots. Child table for WSM_SPLIT_MERGE_TXN_INTERFACE. |
---|
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 |
WSM.WSM_STARTING_JOBS_INTERFACE does not reference any database object
WSM.WSM_STARTING_JOBS_INTERFACE is referenced by following:
Description: | Interface table for Import Inventory Lot Transaction's Starting Lots. Child table for WSM_LOT_SPLIT_MERGES_INTERFACE. |
---|
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 |
WSM.WSM_STARTING_LOTS_INTERFACE does not reference any database object
WSM.WSM_STARTING_LOTS_INTERFACE is referenced by following:
Description: | Sector Extensions associated with a subinventory in an OSFM organization. |
---|
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 |
WSM.WSM_SUBINVENTORY_EXTENSIONS does not reference any database object
WSM.WSM_SUBINVENTORY_EXTENSIONS is referenced by following:
APPS.WSM_ALL_OPERATIONS_V is not referenced by any database object
APPS.WSM_COPRODUCT_SPLIT_DATES_V is not referenced by any database object
APPS.WSM_COPRODUCT_SPLIT_PERC_V is not referenced by any database object
APPS.WSM_COPY_ALL_OPERATIONS_V is not referenced by any database object
APPS.WSM_COPY_NEXT_OPERATIONS_V is not referenced by any database object
APPS.WSM_CO_PRODUCTS_V is not referenced by any database object
APPS.WSM_CO_PRODUCT_COMPONENTS_V is not referenced by any database object
APPS.WSM_CO_PROD_COMP_SUBSTITUTES_V is not referenced by any database object
APPS.WSM_DISCRETE_JOBS_V is not referenced by any database object
APPS.WSM_INV_GENEALOGY_V is not referenced by any database object
APPS.WSM_ITEM_EXTENSIONS_V is not referenced by any database object
APPS.WSM_NEXT_OPERATIONS_V is not referenced by any database object
APPS.WSM_SM_RESULTING_JOBS_V is not referenced by any database object
APPS.WSM_SM_STARTING_JOBS_V is not referenced by any database object
APPS.WSM_STANDARD_CLASSES_VAL_V is not referenced by any database object
APPS.WSM_WIP_OPERATIONS_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |