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 %
Comments

Definition of OSFM Co-product relationship

Indexes
Index Type Tablespace Column
WSM_CO_PRODUCTS_U1 UNIQUE APPS_TS_TX_IDX CO_PRODUCT_GROUP_ID
CO_PRODUCT_ID
Columns
Name Datatype Length Mandatory Comments
CO_PRODUCT_GROUP_ID NUMBER
Y Co-product group identifies the relationships between One Component and Co-Products in a definition.
COMPONENT_ID NUMBER
Y Component Identifier.
ORGANIZATION_ID NUMBER
Y OSFM Organization Identifier.
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CO_PRODUCT_ID NUMBER

Co-Product Identifier
BILL_SEQUENCE_ID NUMBER

Bill Sequence Id in Bill of Materials.
COMPONENT_SEQUENCE_ID NUMBER

Component sequence Id for the primary Bill created for the primary co-product in a group.
SPLIT NUMBER

Normally, Primary co-product will have the highest % value.
EFFECTIVITY_DATE DATE
Y Co-product group effective date.
DISABLE_DATE DATE

Co-product group disable date.
PRIMARY_FLAG VARCHAR2 (1)
Primary co-product will have 'Y'. Non-primary co-product will have 'N'. Values for component records will be NULL.
REVISION VARCHAR2 (3)
Co-product revision Identifer.
CHANGE_NOTICE VARCHAR2 (10)
Co-product Engineering Change Notice.
IMPLEMENTATION_DATE DATE

ECO Implementation date.
USAGE_RATE NUMBER
Y Component Usage rate.
DUALITY_FLAG VARCHAR2 (1)
Duality Flag (For future use)
PLANNING_FACTOR NUMBER

Planning Factor
COMPONENT_YIELD_FACTOR NUMBER

Component Yield.
INCLUDE_IN_COST_ROLLUP NUMBER

Include this component in cost-rollup
WIP_SUPPLY_TYPE NUMBER

Work In Process Supply Type.
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supply Subinventory for component
SUPPLY_LOCATOR_ID NUMBER

Supply Locator for component, if supply subinventory is locator controlled.
COMPONENT_REMARKS VARCHAR2 (240)
Component Remarks
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield definition category
COMP_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
COMP_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ALTERNATE_DESIGNATOR VARCHAR2 (10)
Alternate Designator for co-products
BASIS_TYPE NUMBER

Component Basis Type

[top of page]

WSM.WSM_CO_PRODUCTS does not reference any database object

WSM.WSM_CO_PRODUCTS is referenced by following:

WSM
VIEW - 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
Comments

Substitute Component Details for co-product group component.

Indexes
Index Type Tablespace Column
WSM_CO_PROD_COMP_SUBS_U1 UNIQUE APPS_TS_TX_IDX CO_PRODUCT_GROUP_ID
SUBSTITUTE_COMPONENT_ID
Columns
Name Datatype Length Mandatory Comments
SUBSTITUTE_COMPONENT_ID NUMBER
Y Substitute component for the component in a coproduct group.
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CO_PRODUCT_GROUP_ID NUMBER
Y Co-product group Identifer.
SUBSTITUTE_ITEM_QUANTITY NUMBER
Y Substitute Component Quantity
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
BASIS_TYPE NUMBER

Component Basis Type

[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:

WSM
VIEW - 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
Comments

Details of Substitute Co-product for the coproducs in a coproduct group..

Indexes
Index Type Tablespace Column
WSM_CO_PROD_SUBSTITUTES_U1 UNIQUE APPS_TS_TX_IDX CO_PRODUCT_GROUP_ID
CO_PRODUCT_ID
SUBSTITUTE_CO_PRODUCT_ID
Columns
Name Datatype Length Mandatory Comments
SUBSTITUTE_CO_PRODUCT_ID NUMBER
Y Substitute co-product id.
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CO_PRODUCT_GROUP_ID NUMBER
Y Co-product Group Identifier.
CO_PRODUCT_ID NUMBER
Y Co-product Id for which the substitute co-product is specified.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).

[top of page]

WSM.WSM_CO_PROD_SUBSTITUTES does not reference any database object

WSM.WSM_CO_PROD_SUBSTITUTES is referenced by following:

WSM
VIEW - 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.
Comments

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

Indexes
Index Type Tablespace Column
WSM_INTERFACE_ERRORS_N1 NONUNIQUE APPS_TS_INTERFACE HEADER_ID
REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER

Transaction Id
MESSAGE VARCHAR2 (2000)
Error Message Text
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
HEADER_ID NUMBER
Y Header Id of the OSFM Interface table processed by this request.
MESSAGE_TYPE NUMBER
Y Message Type - Warning, Error.
REQUEST_ID NUMBER
Y Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_ID NUMBER
Y Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_APPLICATION_ID NUMBER
Y Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).

[top of page]

WSM.WSM_INTERFACE_ERRORS does not reference any database object

WSM.WSM_INTERFACE_ERRORS is referenced by following:

WSM
VIEW - 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 %
Comments

Defines the Sector Extensions for a organization Item.

Indexes
Index Type Tablespace Column
WSM_ITEM_EXTENSIONS_U1 UNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
INVENTORY_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Y OSFM organization identifier.
INVENTORY_ITEM_ID NUMBER
Y Inventory Item Identifier.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECTOR_EXTENSION_ID NUMBER
Y Sector Extension Identifier.

[top of page]

WSM.WSM_ITEM_EXTENSIONS does not reference any database object

WSM.WSM_ITEM_EXTENSIONS is referenced by following:

WSM
VIEW - 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
Comments

Interface table for the Import of Lot based Jobs in OSFM.

Indexes
Index Type Tablespace Column
WSM_LOT_JOB_INTERFACE_U1 UNIQUE APPS_TS_INTERFACE HEADER_ID
WSM_LOT_JOB_INTERFACE_N1 NONUNIQUE APPS_TS_INTERFACE SOURCE_LINE_ID
WSM_LOT_JOB_INTERFACE_N2 NONUNIQUE APPS_TS_INTERFACE ORGANIZATION_ID
JOB_NAME
Columns
Name Datatype Length Mandatory Comments
MODE_FLAG NUMBER
Y User enters 2 if a wip lot is created from an inventory lot, otherwise a value of 1 (even for job update).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
GROUP_ID NUMBER

Processing group identifier
SOURCE_CODE VARCHAR2 (30)
Code of the process that generated the interface record.
SOURCE_LINE_ID NUMBER

dentifier of the source system that generated the interface record
PROCESS_TYPE NUMBER

Process type.
ORGANIZATION_ID NUMBER

Organization Identifier
LOAD_TYPE NUMBER
Y Type of Interface Record. 5 - Job creation, 6 - Job update.
STATUS_TYPE NUMBER

Status of the job to be loaded
OLD_STATUS_TYPE NUMBER

Old status
LAST_UNIT_COMPLETION_DATE DATE

Job completion date.
OLD_COMPLETION_DATE DATE

Old completion date
PROCESSING_WORK_DAYS NUMBER

processing days of repetitive schedule
DAILY_PRODUCTION_RATE NUMBER

Schedule daily quantity
LINE_ID NUMBER

Line identifier (Not used)
PRIMARY_ITEM_ID NUMBER

Inventory Item Identifier for the assembly that the job creates
BOM_REFERENCE_ID NUMBER

Identfier that uniquely identifies a bill of material. For explosion of nonstandarad jobs, this should be assembly identifier used as bill of material reference
ROUTING_REFERENCE_ID NUMBER

Identfier that uniquely identifies a routing. For explosion of nonstandarad jobs, this should be assembly identifier used as routing reference
BOM_REVISION_DATE DATE

date of inventory Item revision used to explode the bill of materials used in the job
ROUTING_REVISION_DATE DATE

Routing revision date
WIP_SUPPLY_TYPE NUMBER

Method of material consumption within WIP
CLASS_CODE VARCHAR2 (10)
Accounting class associated with job
LOT_NUMBER VARCHAR2 (80)
Default lot number to assign to assemblies completed from the job
LOT_CONTROL_CODE NUMBER

Lot Control Code
JOB_NAME VARCHAR2 (240)
Lot Job Name
DESCRIPTION VARCHAR2 (240)
Description
FIRM_PLANNED_FLAG NUMBER

Control for Planning scheduling
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate routing used in a job
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate bill of material used in a job
DEMAND_CLASS VARCHAR2 (30)
Type of demand the job satisfies
START_QUANTITY NUMBER

Job start quantity
OLD_START_QUANTITY NUMBER

Old job start quantity (used while updating job parameters)
WIP_ENTITY_ID NUMBER

Wip job identifier
REPETITIVE_SCHEDULE_ID NUMBER

Wip repetitive schedule identifier
ERROR VARCHAR2 (240)
Error message
PARENT_GROUP_ID NUMBER

Parent Group Id
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
INTERFACE_ID NUMBER

No longer used as a row identifier
LAST_UPDATED_BY_NAME VARCHAR2 (100)
Standard Who Column
CREATED_BY_NAME VARCHAR2 (100)
Standard Who Column
PROCESS_PHASE NUMBER

Process phase
PROCESS_STATUS NUMBER

Process status 1- Pending, 2- Running, 3- Error, 4 - Successful.
ORGANIZATION_CODE VARCHAR2 (3)
Short Code that uniquely identifies the organization
FIRST_UNIT_START_DATE DATE

Date job should start
FIRST_UNIT_COMPLETION_DATE DATE

date job should complete the first unit
LAST_UNIT_START_DATE DATE

Date job should start processing the last unit
SCHEDULING_METHOD NUMBER

Scheduling method
LINE_CODE VARCHAR2 (10)
Line Code
PRIMARY_ITEM_SEGMENTS VARCHAR2 (2000)
Primary item segments
BOM_REFERENCE_SEGMENTS VARCHAR2 (2000)
Bom reference segments
ROUTING_REFERENCE_SEGMENTS VARCHAR2 (2000)
Routing reference segments
ROUTING_REVISION VARCHAR2 (3)
Revision to the assembly routing
BOM_REVISION VARCHAR2 (3)
Revision to the bill of material
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Completion subinventory
COMPLETION_LOCATOR_ID NUMBER

Completion locator identifier
COMPLETION_LOCATOR_SEGMENTS VARCHAR2 (2000)
Completion locator segments
SCHEDULE_GROUP_ID NUMBER

Schedule group identifier
SCHEDULE_GROUP_NAME VARCHAR2 (30)
Schedule group name
BUILD_SEQUENCE NUMBER

Build sequence
PROJECT_ID NUMBER

Project Identifier
PROJECT_NAME VARCHAR2 (30)
Project name
TASK_ID NUMBER

Task identifier
TASK_NAME VARCHAR2 (20)
Task number
NET_QUANTITY NUMBER

Planning Net Quantity
DESCRIPTIVE_FLEX_SEGMENTS VARCHAR2 (2000)
Decsriptive flexfield segments
PROJECT_NUMBER VARCHAR2 (25)
Project number
TASK_NUMBER VARCHAR2 (25)
Task number
PROJECT_COSTED NUMBER

Project Costed
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
ndicates whether the job can be considered as a supply for the primary assembly only or for the assembly along with its co-products
OVERCOMPLETION_TOLERANCE_TYPE NUMBER

Unit of OVERCOMPLETION_TOLERANCE_VALUE (percent or amount)
OVERCOMPLETION_TOLERANCE_VALUE NUMBER

Percent or amount above the expected quantity that this entity is allowed to complete
KANBAN_CARD_ID NUMBER

Production kanban replenished by the wip entity being created
PRIORITY NUMBER

Priority to assign to the job being created
DUE_DATE DATE

Due date of the job that is being created
ALLOW_EXPLOSION VARCHAR2 (1)
Determines whether you can run the exploder, thereby creating child records in addition to the job header record
HEADER_ID NUMBER
Y Uniquely identifies this request so that it can be referenced by child requests in other interfaces
DELIVERY_ID NUMBER

Delivery Identifier
ERROR_CODE NUMBER

Indicates if a row has been processed successfully or not
ERROR_MSG VARCHAR2 (2000)
Contains error message if the row is processed with error
COPRODUCTS_SUPPLY NUMBER

ndicates whether the job can be considered as a supply for the primary assembly only or for the assembly along with its co-products
XML_DOCUMENT_ID VARCHAR2 (240)
Xml Document Identifier
JOB_TYPE NUMBER

1 for standard jobs, 3 for non-standard.
DATE_RELEASED DATE

Job Release date
TRANSACTION_DATE DATE

Indicating the date of transaction, only records transaction_date > sysdate are picked up for processing.
NUM_OF_CHILDREN NUMBER

Number of child records in WSM_LOT_JOB_DTL_INTERFACE table, manager will update this column.

[top of page]

WSM.WSM_LOT_JOB_INTERFACE does not reference any database object

WSM.WSM_LOT_JOB_INTERFACE is referenced by following:

WSM
VIEW - 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
Comments

Interface table for the Import of Lot based Jobs Shopfloor Move Transactions in OSFM.

Indexes
Index Type Tablespace Column
WSM_LOT_MOVE_TXN_INTERFACE_U1 UNIQUE APPS_TS_INTERFACE HEADER_ID
WSM_LOT_MOVE_TXN_INTERFACE_N1 NONUNIQUE APPS_TS_INTERFACE GROUP_ID
INTERNAL_GROUP_ID
WSM_LOT_MOVE_TXN_INTERFACE_N2 NONUNIQUE APPS_TS_INTERFACE WIP_ENTITY_ID
GROUP_ID
STATUS
WSM_LOT_MOVE_TXN_INTERFACE_N3 NONUNIQUE APPS_TS_INTERFACE TRANSACTION_ID
WSM_LOT_MOVE_TXN_INTERFACE_N4 NONUNIQUE APPS_TS_INTERFACE WIP_ENTITY_NAME
STATUS
Columns
Name Datatype Length Mandatory Comments
INTERFACE_ID NUMBER

TRANSACTION_ID NUMBER

Transaction Identifier
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY_NAME VARCHAR2 (100)
Standard Who Column
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATED_BY_NAME VARCHAR2 (100)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
GROUP_ID NUMBER

Transaction group Identifier
SOURCE_CODE VARCHAR2 (30)
Code of the shop floor control system that generated the transaction record (null if created by Oracle Work in Process)
SOURCE_LINE_ID NUMBER

dentifier used by source shop floor control system (null if created by Oracle Work in Process)
STATUS NUMBER
Y Transaction processing status
TRANSACTION_TYPE NUMBER

Transaction type
ORGANIZATION_ID NUMBER

Organization Identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
WIP_ENTITY_ID NUMBER

WIP job or repetitive assembly Identifier
WIP_ENTITY_NAME VARCHAR2 (240)
Lot based job name
ENTITY_TYPE NUMBER

WIP entity type code for Lot based Jobs
PRIMARY_ITEM_ID NUMBER

nventory item Identifier for assembly that the job or schedule creates
LINE_ID NUMBER

WIP line Identifier
LINE_CODE VARCHAR2 (10)
Line name
REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule Identifier (this column is solely for internal use)
TRANSACTION_DATE DATE
Y Date transaction was performed
ACCT_PERIOD_ID NUMBER

Accounting period Identifier
FM_OPERATION_SEQ_NUM NUMBER

From operation sequence number
FM_OPERATION_CODE VARCHAR2 (4)
From operation code
FM_DEPARTMENT_ID NUMBER

From department Identifier
FM_DEPARTMENT_CODE VARCHAR2 (10)
From department code
FM_INTRAOPERATION_STEP_TYPE NUMBER

From intra-operation step
TO_OPERATION_SEQ_NUM NUMBER

To operation sequence number
TO_OPERATION_CODE VARCHAR2 (4)
To operation code
TO_DEPARTMENT_ID NUMBER

To department Identifier
TO_DEPARTMENT_CODE VARCHAR2 (10)
To department code
TO_INTRAOPERATION_STEP_TYPE NUMBER

To intraoperation step
TRANSACTION_QUANTITY NUMBER
Y Transaction quantity (between operations)
TRANSACTION_UOM VARCHAR2 (3) Y Unit of measure used in transaction
PRIMARY_QUANTITY NUMBER

Quantity of assembly being moved between operations expressed in the assembly's primary unit of measure
PRIMARY_UOM VARCHAR2 (3)
Primary unit of measure for the assembly
SCRAP_ACCOUNT_ID NUMBER (15)
General Ledger account charged when material is scrapped
REASON_ID NUMBER

Standard transaction reason identifier
REASON_NAME VARCHAR2 (30)
Standard transaction reason name
REFERENCE VARCHAR2 (240)
Transaction reference descriptive text
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
QA_COLLECTION_ID NUMBER

Collection Identifier for quality results
KANBAN_CARD_ID NUMBER

Kanban Card reference for Move completions
OVERCOMPLETION_TRANSACTION_QTY NUMBER

Overcompletion quantity specified in the transaction UOM
OVERCOMPLETION_PRIMARY_QTY NUMBER

Overcompletion quantity derived in the primary unit of measure
OVERCOMPLETION_TRANSACTION_ID NUMBER

Column that links parent Move/Completion transaction with a child Move transaction for Overcompletions.
ERROR VARCHAR2 (2000)
Error Message
JUMP_FLAG VARCHAR2 (1)
Flag to enable Jump functionality
HEADER_ID NUMBER
Y Header Identifier
PROCESSING_ORDER NUMBER

Determines move processsing order within a job
XML_DOCUMENT_ID VARCHAR2 (240)
Xml Document Identifier
NEW_WIP_ENTITY_NAME VARCHAR2 (240)
New job name when a job is completed
PRIMARY_SCRAP_QUANTITY NUMBER

Scrap quantity of assembly being moved between operations expressed in the assembly's primary unit of measure
SCRAP_QUANTITY NUMBER

Quantity of the assembly being scrapped
SCRAP_AT_OPERATION_FLAG NUMBER

Indicates the operation at which the user wishes to perform the scrap in a move and scrap transaction
INTERNAL_GROUP_ID NUMBER

Internally populated and should not be populated by the user.
INTERNAL_SCRAP_TXN_ID NUMBER

Internally populated and should not be populated by the user.
SERIAL_START_FLAG NUMBER

1 - User intends to start serial tracking from the current move transaction

[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:

WSM
VIEW - 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
Comments

Base table for Lot based Inventory Transactions - Header Information.

Indexes
Index Type Tablespace Column
WSM_LOT_SPLIT_MERGES_U1 UNIQUE APPS_TS_TX_IDX TRANSACTION_ID
WSM_LOT_SPLIT_MERGES_N1 NONUNIQUE APPS_TS_TX_IDX GROUP_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15) Y Transaction Id (populated from sequence WSM_SPLIT_MERGE_TRANSACTIONS_S)
TRANSACTION_TYPE_ID NUMBER (15) Y Inventory Lot Transaction Type (1-Split, 2-Merge, 3-Translate and 4-Transfer)
ORGANIZATION_ID NUMBER
Y OSFM Organization Identifier.
WIP_FLAG NUMBER
Y WIP Flag
SPLIT_FLAG NUMBER
Y Split Flag.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
TRANSACTION_REFERENCE VARCHAR2 (240)
Transaction Reference.
REASON_ID NUMBER

Reason for performing this Transaction.
TRANSACTION_DATE DATE

Transaction Date.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROCESS_STATUS NUMBER

1 - Pending, 2-Running, 3-Error, 4-Complete, 5-Warning.
ERROR_MESSAGE VARCHAR2 (2000)
Error message Text.
GROUP_ID NUMBER (15)
Group Identifer
TRANSACTION_REASON VARCHAR2 (30)
Transaction Reason.

[top of page]

WSM.WSM_LOT_SPLIT_MERGES does not reference any database object

WSM.WSM_LOT_SPLIT_MERGES is referenced by following:

WSM
VIEW - 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
Comments

Interface table for Lot based Inventory Lot Transactions - Header Information.

Indexes
Index Type Tablespace Column
WSM_LOT_SPLIT_MERGES_IFC_U1 UNIQUE APPS_TS_INTERFACE HEADER_ID
WSM_LOT_SPLIT_MERGES_IFC_N1 NONUNIQUE APPS_TS_INTERFACE GROUP_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER

Transactions Id (System generated).
TRANSACTION_TYPE_ID NUMBER
Y Inventory Lot Transaction Type (1-Split, 2-Merge, 3-Translate and 4-Transfer)
ORGANIZATION_ID NUMBER
Y OSFM organization identifier
WIP_FLAG NUMBER
Y WIP Flag
SPLIT_FLAG NUMBER
Y Split Flag.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
TRANSACTION_REFERENCE VARCHAR2 (240)
Transaction Reference.
REASON_ID NUMBER

Reason Id
TRANSACTION_DATE DATE

Transaction Date
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROCESS_STATUS NUMBER

1-Pending, 2- Running, 3- Error, 4-Completed and 5-Warning.
ERROR_MESSAGE VARCHAR2 (2000)
Error message Text.
GROUP_ID NUMBER

Group Id.
TRANSACTION_REASON VARCHAR2 (30)
Transaction Reason.
HEADER_ID NUMBER
Y Header Identifier (Unique - WSM_LOT_SM_IFC_HEADER_S sequence)
XML_DOCUMENT_ID VARCHAR2 (240)
Xml Document Identfier

[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:

WSM
VIEW - WSM_LOT_SPLIT_MERGES_INTERFAC#

[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
Comments

OSFM Specific details for Standard Operations defined in an OSFM organization.

Indexes
Index Type Tablespace Column
WSM_OPERATION_DETAILS_U1 UNIQUE APPS_TS_TX_IDX STANDARD_OPERATION_ID
Columns
Name Datatype Length Mandatory Comments
STANDARD_OPERATION_ID NUMBER
Y Standard Operation Id.
QUEUE_MANDATORY_FLAG NUMBER

Flag to set Queue intra-operation step mandatory.
RUN_MANDATORY_FLAG NUMBER

Flag to set Run intra-operation step mandatory.
TO_MOVE_MANDATORY_FLAG NUMBER

Flag to set To-Move intra-operation step mandatory.
SECONDARY_INVENTORY_NAME VARCHAR2 (10)
Stocking Point (completion subinventory)
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ORGANIZATION_ID NUMBER
Y OSFM Organization Identifier.
INVENTORY_LOCATION_ID NUMBER

Default Inventory Locator Id, if the Subinventory is locator controlled.

[top of page]

WSM.WSM_OPERATION_DETAILS does not reference any database object

WSM.WSM_OPERATION_DETAILS is referenced by following:

WSM
VIEW - 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
Comments

Define OSFM Parameters for a Inventory/Manufacturing Organization

Indexes
Index Type Tablespace Column
WSM_PARAMETERS_U1 UNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Y OSFM Organization Identifier.(PK)
NEW_LOT_SEPARATOR VARCHAR2 (1)
New Lot Separator. (used by OSFM Transactions)
JOB_COMPLETION_SEPARATOR VARCHAR2 (1)
Lot based Job completion separator
ALLOW_BACKWARD_MOVE_FLAG NUMBER

Flag to set to Allow UNDO Last Lot Job Move.
DELETE_BACKWARD_FROM_FLAG NUMBER

Not used.
TRANSACTION_ACCOUNT_ID NUMBER (15)
ransaction Account Id used for Lot Transactions.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PLAN_CODE VARCHAR2 (30)
Quality Plan Code. (Not used currently)
LAST_OPERATION_SEQ_NUM NUMBER

Last Operation Sequence Number for a Lot based Job. Default to 9999.
OP_SEQ_NUM_INCREMENT NUMBER

Operation Sequence Number Increment for Lot Job Moves. Defaults to 10.
COPRODUCTS_SUPPLY_DEFAULT NUMBER

Default for lot job to consider associated co-products as supply.
DEFAULT_ACCT_CLASS_CODE VARCHAR2 (10)
Default account class code (used by Lot based Job creation).
INV_LOT_TXN_ENABLED NUMBER

Flag to allow inventory lot transaction
ESTIMATED_SCRAP_ACCOUNTING NUMBER

Flag indicating whether estimate scrap accounting will be conducted for the organization
HONOR_KANBAN_SIZE NUMBER

Honor Item's Kanban size for Lot based Jobs Replenishment
CHARGE_JUMP_FROM_QUEUE NUMBER

To charge jump-from-queue operation or not
MOVE_IN_OPTION NUMBER

Allow Move In transaction for the current Organization.
MOVE_TO_NEXT_OP_OPTION NUMBER

Allow Move to Next Operation for the Current Organization.
SHOW_NEXT_OP_BY_DEFAULT NUMBER

Flag Which Decides Behaviour of Move to Next Operation
TRACK_MULTI_USAGE_DATES NUMBER

Track Multiple Resource Usage (Currently Not Used).
REUSE_JOBNAME NUMBER
Y Parameter to allow creation of new jobs with name same as that of existing lot.

[top of page]

WSM.WSM_PARAMETERS does not reference any database object

WSM.WSM_PARAMETERS is referenced by following:

WSM
VIEW - 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 %
Comments

Interface table for Import WIP Lot Transaction's Resulting Lots - Child Table for WSM_SPLIT_MERGE_TXN_INTERFACE.

Indexes
Index Type Tablespace Column
WSM_RESULT_JOBS_INTERFACE_N1 NONUNIQUE APPS_TS_INTERFACE HEADER_ID
WIP_ENTITY_NAME
WSM_RESULT_JOBS_INTERFACE_N2 NONUNIQUE APPS_TS_INTERFACE WIP_ENTITY_NAME
ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER (15) Y Header Identifier
GROUP_ID NUMBER (15)
Transaction Group Identifier
WIP_ENTITY_NAME VARCHAR2 (240) Y Lot based Job Name.
DESCRIPTION VARCHAR2 (240)
Job Description.
PRIMARY_ITEM_ID NUMBER
Y Inventory item Identifier for the assembly the job or schedule creates
CLASS_CODE VARCHAR2 (10)
WIP Accounting class associated with the job
START_QUANTITY NUMBER
Y Job start quantity
BOM_REFERENCE_ID NUMBER

Assembly identifier used as bill of material reference for explosions of nonstandard job
ROUTING_REFERENCE_ID NUMBER

Assembly identifier used as routing reference for explosions of nonstandard job
COMMON_BOM_SEQUENCE_ID NUMBER

Bill of material identifier when a common bill is used
COMMON_ROUTING_SEQUENCE_ID NUMBER

Routing identifier when a common routing is used
ROUTING_REVISION VARCHAR2 (3)
Short code that uniquely identifies the Routing revision
BOM_REVISION VARCHAR2 (3)
BOM revision for the primary assembly
BOM_REVISION_DATE DATE

Date of assembly item revision used to explode the bills of material used in the job
ROUTING_REVISION_DATE DATE

Routing revision date
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Designator if an Alternate Bill is used in this Job.
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Designator if an Alternate Routing is used in this Job.
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Default completion subinventory for assemblies completed by the job
STARTING_OPERATION_SEQ_NUM NUMBER

Starting Operation Sequence Number
STARTING_INTRAOPERATION_STEP NUMBER

Starting Intra-operation step
SCHEDULED_COMPLETION_DATE DATE

Last unit scheduled completion date
STARTING_WIP_ENTITY_RENAME VARCHAR2 (240)
Starting WIP Entity Rename
FORWARD_OP_OPTION NUMBER

Forward Operations Option
BONUS_ACCT_ID NUMBER (15)
Bonus Account Identifier
DEMAND_CLASS VARCHAR2 (30)
Demand class.
PROCESS_STATUS NUMBER
Y Transaction processing status
ERROR_MESSAGE VARCHAR2 (2000)
Error Message
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
COMPLETION_LOCATOR_ID NUMBER (15)
Default completion locator identifier for assemblies completed by the job
STARTING_OPERATION_CODE VARCHAR2 (4)
Starting Operation Code
STARTING_STD_OP_ID NUMBER

Starting Standard Operation Identifier
SCHEDULED_START_DATE DATE

Scheduled Start date.
COPRODUCTS_SUPPLY NUMBER

Coproducts Supply
NET_QUANTITY NUMBER

Planning Net Quantity.
XML_DOCUMENT_ID VARCHAR2 (240)
Xml Document Identifier
JOB_TYPE NUMBER

Job Type 1- Standard 3-Nonstandard
ORGANIZATION_ID NUMBER

organization Identifier
INTERNAL_GROUP_ID NUMBER

Internal only. System generated
SPLIT_HAS_UPDATE_ASSY NUMBER

Value of '0' means 'no update assy' and value of '1' means 'split and update assembly'

[top of page]

WSM.WSM_RESULTING_JOBS_INTERFACE does not reference any database object

WSM.WSM_RESULTING_JOBS_INTERFACE is referenced by following:

WSM
VIEW - 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
Comments

Interface table for Import Inventory Lot Transaction's Resulting Lots. Child Table for WSM_LOT_SPLIT_MERGES_INTERFACE.

Indexes
Index Type Tablespace Column
WSM_RESULTING_LOTS_IFC_U1 UNIQUE APPS_TS_INTERFACE HEADER_ID
LOT_NUMBER
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER

LOT_NUMBER VARCHAR2 (80) Y Lot Number
INVENTORY_ITEM_ID NUMBER
Y Inventory Item Id.
ORGANIZATION_ID NUMBER
Y OSFM Organization Identifier
WIP_ENTITY_ID NUMBER

Lot based Job Identifier.
QUANTITY NUMBER
Y Quantity
SUBINVENTORY_CODE VARCHAR2 (10)
Secondary Inventory name (Subinventory)
LOCATOR_ID NUMBER

Locator Identifier, if secondary inventory is locator controlled.
REVISION VARCHAR2 (3)
Item revision
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
HEADER_ID NUMBER
Y Header Id.
XML_DOCUMENT_ID VARCHAR2 (240)
Xml Document Identifier

[top of page]

WSM.WSM_RESULTING_LOTS_INTERFACE does not reference any database object

WSM.WSM_RESULTING_LOTS_INTERFACE is referenced by following:

WSM
VIEW - 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
Comments

Sector Extensions in OSFM are the segment of a manufacturing process for which a Lot based Job is defined.

Indexes
Index Type Tablespace Column
WSM_SECTOR_EXTENSIONS_U1 UNIQUE APPS_TS_TX_IDX SECTOR_EXTENSION_ID
WSM_SECTOR_EXTENSIONS_U2 UNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
SECTOR_EXTENSION_CODE
Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECTOR_EXTENSION_ID NUMBER
Y Generated from Sector Extension Id (WSM_SECTOR_EXTENSIONS_S sequence)
SECTOR_EXTENSION_CODE VARCHAR2 (10) Y Sector Extension Name.
SECTOR_EXTENSION_DESCRIPTION VARCHAR2 (60)
Sector Extension Description.
ORGANIZATION_ID NUMBER
Y OSFM Organization Identifier.
DEFAULT_ACCT_CLASS_CODE VARCHAR2 (10) Y OSFM Default WIP Accounting Class associated with the Sector Extension.

[top of page]

WSM.WSM_SECTOR_EXTENSIONS does not reference any database object

WSM.WSM_SECTOR_EXTENSIONS is referenced by following:

WSM
VIEW - 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 %
Comments

Base table for Resulting Lots for WIP Lot Transactions in OSFM.

Indexes
Index Type Tablespace Column
WSM_SM_RESULTING_JOBS_N1 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_ID
WIP_ENTITY_NAME
WSM_SM_RESULTING_JOBS_N2 NONUNIQUE APPS_TS_TX_IDX WIP_ENTITY_NAME
ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15) Y Transaction Identifier
WIP_ENTITY_NAME VARCHAR2 (240) Y Job Name
WIP_ENTITY_ID NUMBER

Job Identifier.
DESCRIPTION VARCHAR2 (240)
Description.
PRIMARY_ITEM_ID NUMBER

nventory item Identifier for the assembly the job or schedule manufactures.
CLASS_CODE VARCHAR2 (10)
WIP Accounting class for the job.
START_QUANTITY NUMBER
Y Job start quantity
BOM_REFERENCE_ID NUMBER

Assembly identifier used as bill of material reference for explosions of nonstandard job
ROUTING_REFERENCE_ID NUMBER

Assembly identifier used as routing reference for explosions of nonstandard job
COMMON_BOM_SEQUENCE_ID NUMBER

Bill of material identifier when a common bill is used
COMMON_ROUTING_SEQUENCE_ID NUMBER

Routing identifier when a common routing is used
BOM_REVISION VARCHAR2 (3)
BOM revision for the primary assembly
ROUTING_REVISION VARCHAR2 (3)
Routing revision for the primary assembly
BOM_REVISION_DATE DATE

Date of assembly item revision used to explode the bills of material used in the job
ROUTING_REVISION_DATE DATE

Routing revision date
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate BOM Designator used in a Job.
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate Routing Designator used in a Job.
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Default completion subinventory for assemblies completed by the job
STARTING_OPERATION_SEQ_NUM NUMBER

Starting Operation Sequence Number
STARTING_INTRAOPERATION_STEP NUMBER

Starting Intra-operation step
SCHEDULED_START_DATE DATE

Date on which job is scheduled to start
SCHEDULED_COMPLETION_DATE DATE

Last unit scheduled completion date
STARTING_WIP_ENTITY_RENAME VARCHAR2 (240)
Starting WIP Entity Rename
FORWARD_OP_OPTION NUMBER

Forward Operations Option
BONUS_ACCT_ID NUMBER (15)
Bonus Account Identifier
DEMAND_CLASS VARCHAR2 (30)
Demand class.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
COMPLETION_LOCATOR_ID NUMBER

Default completion locator identifier for assemblies completed by the job
STARTING_OPERATION_CODE VARCHAR2 (4)
Starting Operation Code
STARTING_STD_OP_ID NUMBER

Starting Standard Operation Identifier
COPRODUCTS_SUPPLY NUMBER

Coproducts Supply
NET_QUANTITY NUMBER

Planning Net Quantity.
JOB_TYPE NUMBER

Job Type 1-Standard 3-NonStandard
ORGANIZATION_ID NUMBER

Organization Identifier
JOB_OPERATION_SEQ_NUM NUMBER

Job Operation Sequence Number
INTERNAL_GROUP_ID NUMBER

Internal group Id. Internal only. System generated
SPLIT_HAS_UPDATE_ASSY NUMBER

Value of '0' means 'no update assy' and value of '1' means 'split and update assembly'

[top of page]

WSM.WSM_SM_RESULTING_JOBS does not reference any database object

WSM.WSM_SM_RESULTING_JOBS is referenced by following:

WSM
VIEW - 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
Comments

Base table for Resulting Lots for Inventory Lot Transactions in OSFM.

Indexes
Index Type Tablespace Column
WSM_SM_RESULTING_LOTS_U1 UNIQUE APPS_TS_TX_IDX TRANSACTION_ID
LOT_NUMBER
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15) Y Transaction Identifier.
LOT_NUMBER VARCHAR2 (80) Y Lot Number
INVENTORY_ITEM_ID NUMBER
Y Inventory Item Id.
ORGANIZATION_ID NUMBER
Y OSFM Organization Identifier.
WIP_ENTITY_ID NUMBER

Lot based Job Identifier.
QUANTITY NUMBER
Y Quantity.
SUBINVENTORY_CODE VARCHAR2 (10)
Secondary Inventory Name (Subinventory).
LOCATOR_ID NUMBER

Inventory Locator Identifier, if the subinventory is locator controlled.
REVISION VARCHAR2 (3)
Item Revision.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).

[top of page]

WSM.WSM_SM_RESULTING_LOTS does not reference any database object

WSM.WSM_SM_RESULTING_LOTS is referenced by following:

WSM
VIEW - 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 %
Comments

Base table for Starting Lots for WIP Lot Transactions in OSFM.

Indexes
Index Type Tablespace Column
WSM_SM_STARTING_JOBS_N1 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_ID
WIP_ENTITY_ID
WSM_SM_STARTING_JOBS_N2 NONUNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
WIP_ENTITY_NAME
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15) Y Transaction Identifier
WIP_ENTITY_ID NUMBER
Y Job or schedule Identifier
REPRESENTATIVE_FLAG VARCHAR2 (1)
Representative Job Flag
JOB_START_QUANTITY NUMBER

Job start quantity
OPERATION_SEQ_NUM NUMBER

Operation Sequence Number
INTRAOPERATION_STEP NUMBER

Intra-operation step
AVAILABLE_QUANTITY NUMBER
Y Available Quantity
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
WIP_ENTITY_NAME VARCHAR2 (240)
WIP job or repetitive assembly name or flow schedule reference code
ROUTING_SEQ_ID NUMBER

Routing Identifier
PRIMARY_ITEM_ID NUMBER

nventory item Identifier for the assembly.
NET_QUANTITY NUMBER

Net Quantity
ROUTING_REFERENCE_ID NUMBER

Routing Reference Id (used by Non-standard Lot based Jobs)
BOM_REFERENCE_ID NUMBER

BOM Reference Id (used by Non-standard Lot based Jobs)
ORGANIZATION_ID NUMBER

Organization Identifier
DESCRIPTION VARCHAR2 (240)
Description
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Completion Subinventory
COMPLETION_LOCATOR_ID NUMBER (15)
Completion Locator Id
BILL_SEQUENCE_ID NUMBER

Bill of Material Identifer
DEPARTMENT_ID NUMBER

Department Id
OPERATION_SEQUENCE_ID NUMBER

Operation Sequence Identifier
BOM_REVISION VARCHAR2 (3)
Bill of Material Revision
BOM_REVISION_DATE DATE

Bill of Material Revision Date
ROUTING_REVISION VARCHAR2 (3)
Routing Revision
ROUTING_REVISION_DATE DATE

Routing Revision Date
SCHEDULED_START_DATE DATE

Scheduled Start Date
SCHEDULED_COMPLETION_DATE DATE

Scheduled Completion Date
COPRODUCTS_SUPPLY NUMBER

Co-products supply from this Job.
INTERNAL_GROUP_ID NUMBER

Internal group Id. Internal only. System generated

[top of page]

WSM.WSM_SM_STARTING_JOBS does not reference any database object

WSM.WSM_SM_STARTING_JOBS is referenced by following:

WSM
VIEW - 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
Comments

Base table for Starting Lots for Inventory Lot Transactions in OSFM.

Indexes
Index Type Tablespace Column
WSM_SM_STARTING_LOTS_U1 UNIQUE APPS_TS_TX_IDX TRANSACTION_ID
LOT_NUMBER
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15) Y Transaction Identifier.
LOT_NUMBER VARCHAR2 (80) Y Lot Number
INVENTORY_ITEM_ID NUMBER
Y Inventory Item Identifier.
ORGANIZATION_ID NUMBER
Y OSFM Organization Identifier.
QUANTITY NUMBER
Y Quantity.
SUBINVENTORY_CODE VARCHAR2 (10) Y Secondary Inventory Name (Subinventory)
LOCATOR_ID NUMBER

Inventory Locator Identifier, if subinventory is locator controlled.
REVISION VARCHAR2 (3)
Item revision.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
REPRESENTATIVE_FLAG VARCHAR2 (1)
Representative Lot Flag

[top of page]

WSM.WSM_SM_STARTING_LOTS does not reference any database object

WSM.WSM_SM_STARTING_LOTS is referenced by following:

WSM
VIEW - 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
Comments

WIP Lot Transactions Snapshot table for Shop Floor cost processor.

Indexes
Index Type Tablespace Column
WSM_SPLIT_MERGE_SNAPSHOT_U1 UNIQUE APPS_TS_ARCHIVE TRANSACTION_ID
WIP_ENTITY_ID
OPERATION_SEQ_NUM
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Y Transaction Identifier
WIP_ENTITY_ID NUMBER
Y WIP job or repetitive assembly Identifier
OPERATION_SEQ_NUM NUMBER
Y Operation sequence number
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
QUANTITY_COMPLETED NUMBER

Assembly Quantity Completed
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).

[top of page]

WSM.WSM_SPLIT_MERGE_SNAPSHOT does not reference any database object

WSM.WSM_SPLIT_MERGE_SNAPSHOT is referenced by following:

WSM
VIEW - 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
Comments

Base table for header information for WIP Lot Transactions in OSFM.

Indexes
Index Type Tablespace Column
WSM_SPLIT_MERGE_TXN_U1 UNIQUE APPS_TS_TX_IDX TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15) Y Transaction Identifier
TRANSACTION_TYPE_ID NUMBER (15) Y Transaction Type Identifier
TRANSACTION_DATE DATE
Y Date transaction was performed
ORGANIZATION_ID NUMBER
Y Organization Identifier
REASON_ID NUMBER

Standard transaction reason identifier
SUSPENSE_ACCT_ID NUMBER (15)
Suspense Account Identifier
TRANSACTION_REFERENCE VARCHAR2 (240)
Transaction reference descriptive text
STATUS NUMBER
Y Transaction processing status
CONCURRENT_REQUEST_ID NUMBER (15)
Concurrent Request Identifier
COSTED NUMBER

Transaction costing status
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
GROUP_ID NUMBER (15)
Transaction group Identifier
ERROR_MESSAGE VARCHAR2 (2000)
Error Message
INTERNAL_GROUP_ID NUMBER

Internal group Id. Internal only. System generated
EMPLOYEE_ID VARCHAR2 (240)
Employee Identifier

[top of page]

WSM.WSM_SPLIT_MERGE_TRANSACTIONS does not reference any database object

WSM.WSM_SPLIT_MERGE_TRANSACTIONS is referenced by following:

WSM
VIEW - 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
Comments

Interface table for Lot based WIP Lot Transactions.

Indexes
Index Type Tablespace Column
WSM_SM_TXN_INTERFACE_U1 UNIQUE APPS_TS_INTERFACE HEADER_ID
WSM_SM_TXN_INTERFACE_N1 NONUNIQUE APPS_TS_INTERFACE GROUP_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER (15) Y Header Identifier
TRANSACTION_TYPE_ID NUMBER (15) Y Transaction Type Identifier
TRANSACTION_DATE DATE
Y Date transaction was performed
ORGANIZATION_ID NUMBER
Y Organization Identifier
REASON_ID NUMBER

Standard transaction reason identifier
SUSPENSE_ACCT_ID NUMBER (15)
Suspense Account Identifier
TRANSACTION_REFERENCE VARCHAR2 (240)
Transaction reference descriptive text
GROUP_ID NUMBER (15)
Transaction group Identifier
PROCESS_STATUS NUMBER
Y Transaction processing status
TRANSACTION_ID NUMBER (15)
Transaction Identifier
ERROR_MESSAGE VARCHAR2 (2000)
Error Message
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
XML_DOCUMENT_ID VARCHAR2 (240)
Xml Document Identifier
INTERNAL_GROUP_ID NUMBER

Internal only. System generated

[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:

WSM
VIEW - 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
Comments

Interface table for Import WIP Lot Transaction's Starting Lots. Child table for WSM_SPLIT_MERGE_TXN_INTERFACE.

Indexes
Index Type Tablespace Column
WSM_START_JOBS_INTERFACE_N1 NONUNIQUE APPS_TS_INTERFACE HEADER_ID
WIP_ENTITY_ID
WSM_START_JOBS_INTERFACE_N2 NONUNIQUE APPS_TS_INTERFACE WIP_ENTITY_NAME
ORGANIZATION_ID
WSM_START_JOBS_INTERFACE_N3 NONUNIQUE APPS_TS_INTERFACE WIP_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER (15) Y Header Identifier
WIP_ENTITY_ID NUMBER

WIP job or repetitive assembly Identifier
OPERATION_SEQ_NUM NUMBER
Y Operation sequence number
INTRAOPERATION_STEP NUMBER
Y Intra-operation step
REPRESENTATIVE_FLAG VARCHAR2 (1)
Representative Job Flag
GROUP_ID NUMBER (15)
Transaction group Identifier
PROCESS_STATUS NUMBER
Y Transaction processing status
ERROR_MESSAGE VARCHAR2 (2000)
Error Message
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ROUTING_SEQ_ID NUMBER

Routing identifier
PRIMARY_ITEM_ID NUMBER

Inventory item Identifier for the assembly the job or schedule creates
XML_DOCUMENT_ID VARCHAR2 (240)
Xml Document Identifier
WIP_ENTITY_NAME VARCHAR2 (240)
Resulting Job Name
ORGANIZATION_ID NUMBER

Organization Identifier
INTERNAL_GROUP_ID NUMBER

Internal only. System generated

[top of page]

WSM.WSM_STARTING_JOBS_INTERFACE does not reference any database object

WSM.WSM_STARTING_JOBS_INTERFACE is referenced by following:

WSM
VIEW - 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
Comments

Interface table for Import Inventory Lot Transaction's Starting Lots. Child table for WSM_LOT_SPLIT_MERGES_INTERFACE.

Indexes
Index Type Tablespace Column
WSM_STARTING_LOTS_IFC_U1 UNIQUE APPS_TS_INTERFACE HEADER_ID
LOT_NUMBER
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER

LOT_NUMBER VARCHAR2 (80) Y Lot Number
INVENTORY_ITEM_ID NUMBER
Y Inventory Item.
ORGANIZATION_ID NUMBER
Y OSFM Organization Identifier.
QUANTITY NUMBER
Y Quantity.
SUBINVENTORY_CODE VARCHAR2 (10) Y Secondary Inventory Name (Subinventory)
LOCATOR_ID NUMBER

Inventory Locator Id,if the subinventory is locator controlled.
REVISION VARCHAR2 (3)
Item Revision.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
HEADER_ID NUMBER
Y Header Identifier
XML_DOCUMENT_ID VARCHAR2 (240)
Xml Document Identifier
COMPONENT_ISSUE_QUANTITY NUMBER

Issue quantity of component for Lot creation
REPRESENTATIVE_FLAG VARCHAR2 (1)
Representative Lot Flag

[top of page]

WSM.WSM_STARTING_LOTS_INTERFACE does not reference any database object

WSM.WSM_STARTING_LOTS_INTERFACE is referenced by following:

WSM
VIEW - 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
Comments

Sector Extensions associated with a subinventory in an OSFM organization.

Indexes
Index Type Tablespace Column
WSM_SUBINVENTORY_EXTENSIONS_U1 UNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
SECONDARY_INVENTORY_NAME
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Y OSFM Organization Identifier
SECONDARY_INVENTORY_NAME VARCHAR2 (10) Y Subinventory Stocking Points associated with the sector extension.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECTOR_EXTENSION_ID NUMBER
Y Sector Extension Identifier to which the subinventory is associated with.

[top of page]

WSM.WSM_SUBINVENTORY_EXTENSIONS does not reference any database object

WSM.WSM_SUBINVENTORY_EXTENSIONS is referenced by following:

WSM
VIEW - WSM_SUBINVENTORY_EXTENSIONS#

[top of page]

View: WSM_ALL_OPERATIONS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Y WIP Job Identifier
TO_OP_SEQ_NUM NUMBER

To operation number
TO_BOS_OP_SEQ_NUM NUMBER
Y To Operation Number in Routing
TO_OP_SEQ_ID NUMBER
Y To Operation Sequence Id
NEXT_OPERATION_CODE VARCHAR2 (4)
Short code that uniquely identifies the Next operation
OPERATION_DESCRIPTION VARCHAR2 (240)
Descriptive text for the operation
STANDARD_OPERATION_ID NUMBER

Standard Operation Identifier
DEPARTMENT_CODE VARCHAR2 (10) Y Department Code
DEPARTMENT_ID NUMBER
Y Department Identifier

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ASSEMBLY_ITEM_ID NUMBER

COMPONENT_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

COMPONENT_QUANTITY NUMBER

COMPONENT_YIELD_FACTOR NUMBER

ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
BASIS_TYPE NUMBER

Basis type of the component ( null - item, 2- Lot )

[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 not referenced by any database object

[top of page]

View: WSM_COPRODUCT_SPLIT_DATES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

OSFM organization identifier
CO_PRODUCT_GROUP_ID NUMBER

Co-product relationship identifier
EFFECTIVITY_DATE DATE

Co-product split effectivity range - effective date
DISABLE_DATE DATE

Co-product split effectivity range - disable date

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
rowid column
CO_PRODUCT_GROUP_ID NUMBER

Co-product relationship identifier
CO_PRODUCT_ID NUMBER

Co-product identifier
ORGANIZATION_ID NUMBER

OSFM organization identifier
CREATION_DATE DATE

Standard who column - creation date of this record
CREATED_BY NUMBER

Standard who column - creation by User ID
LAST_UPDATE_DATE DATE

Standard who column - last update date of this record
LAST_UPDATED_BY NUMBER

Standard who column - last updated by User ID
LAST_UPDATE_LOGIN NUMBER

Standard who column - last updated by Operating system User login ID
EFFECTIVITY_DATE DATE

Split effectivity range - effective date
DISABLE_DATE DATE

Split effectivity range - disable date
PRIMARY_FLAG VARCHAR2 (1)
Primary co-product will have 'Y'. Non-primary co-product will have 'N'
REVISION VARCHAR2 (3)
Revision of the co-product item
SPLIT NUMBER

Split percentage of the co-product in a range
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row
PROGRAM_ID NUMBER (15)
Concurrent Program who column - ID of the program that last updated this row
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - Date on which the program that last updated this row
DESCRIPTION VARCHAR2 (240)
Description of the co-product item

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Y WIP Job Identifier
TO_OP_SEQ_NUM NUMBER

To Operation Sequence Number
TO_WCO_OP_SEQ_NUM NUMBER
Y To Operation Sequence Number in the Job's copy of the Routing
TO_OP_SEQ_ID NUMBER
Y To Operation Sequence Id
NEXT_OPERATION_CODE VARCHAR2 (4)
Short code that uniquely identifies the Next operation
OPERATION_DESCRIPTION VARCHAR2 (240)
Descriptive text for the operation
STANDARD_OPERATION_ID NUMBER

Standard Operation Identifier
DEPARTMENT_CODE VARCHAR2 (10) Y Department Code of the To Operation
DEPARTMENT_ID NUMBER
Y Department Identifier of the To Operation
RECOMMENDED VARCHAR2 (1) Y Recommended Operation Flag

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER

WIP Job Identifier
FM_OPERATION_SEQ_NUM NUMBER

From Operation Sequence Number
TO_WO_OPERATION_SEQ_NUM NUMBER

To Operation Sequence Number
TO_WCO_OPERATION_SEQ_NUM NUMBER

To Operation Sequence Number in the Job's copy of the Routing
FM_OPERATION_SEQ_ID NUMBER

From Operation Sequence Id
TO_OPERATION_SEQ_ID NUMBER

To Operation Sequence Id
OPERATION_CODE VARCHAR2 (4)
Short code that uniquely identifies the Next operation
NEXT_OPERATION_CODE VARCHAR2 (4)
Short code that uniquely identifies the Next operation
OPERATION_DESCRIPTION VARCHAR2 (240)
Descriptive text for the operation
STANDARD_OPERATION_ID NUMBER

Standard Operation Identifier
DEPARTMENT_CODE VARCHAR2 (10)
Department Code
DEPARTMENT_ID NUMBER

Department Identifier
RECOMMENDED_NEXT_OPERATION VARCHAR2 (1)
Recommended Next Operation Flag
RECOMMENDED_OPERATION VARCHAR2 (1)
Recommended Operation Flag

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CO_PRODUCT_GROUP_ID NUMBER
Y
CO_PRODUCT_ID NUMBER

COMPONENT_ID NUMBER
Y
ORGANIZATION_ID NUMBER
Y
COMPONENT_SEQUENCE_ID NUMBER

CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
EFFECTIVITY_DATE DATE
Y
DISABLE_DATE DATE

PRIMARY_FLAG VARCHAR2 (1)
REVISION VARCHAR2 (3)
CHANGE_NOTICE VARCHAR2 (10)
USAGE_RATE NUMBER
Y
SPLIT NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
CO_PRODUCT_DESC VARCHAR2 (240)
IMPLEMENTATION_DATE DATE

BILL_SEQUENCE_ID NUMBER

ALTERNATE_DESIGNATOR VARCHAR2 (10)

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CO_PRODUCT_GROUP_ID NUMBER
Y
COMPONENT_ID NUMBER
Y
ORGANIZATION_ID NUMBER
Y
COMPONENT_SEQUENCE_ID NUMBER

CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
EFFECTIVITY_DATE DATE
Y
DISABLE_DATE DATE

USAGE_RATE NUMBER
Y
DUALITY_FLAG VARCHAR2 (1)
PLANNING_FACTOR NUMBER

COMPONENT_YIELD_FACTOR NUMBER

INCLUDE_IN_COST_ROLLUP NUMBER

WIP_SUPPLY_TYPE NUMBER

SUPPLY_TYPE VARCHAR2 (80)
SUPPLY_SUBINVENTORY VARCHAR2 (10)
SUPPLY_LOCATOR_ID NUMBER

COMPONENT_REMARKS VARCHAR2 (240)
COMP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
COMP_ATTRIBUTE1 VARCHAR2 (150)
COMP_ATTRIBUTE2 VARCHAR2 (150)
COMP_ATTRIBUTE3 VARCHAR2 (150)
COMP_ATTRIBUTE4 VARCHAR2 (150)
COMP_ATTRIBUTE5 VARCHAR2 (150)
COMP_ATTRIBUTE6 VARCHAR2 (150)
COMP_ATTRIBUTE7 VARCHAR2 (150)
COMP_ATTRIBUTE8 VARCHAR2 (150)
COMP_ATTRIBUTE9 VARCHAR2 (150)
COMP_ATTRIBUTE10 VARCHAR2 (150)
COMP_ATTRIBUTE11 VARCHAR2 (150)
COMP_ATTRIBUTE12 VARCHAR2 (150)
COMP_ATTRIBUTE13 VARCHAR2 (150)
COMP_ATTRIBUTE14 VARCHAR2 (150)
COMP_ATTRIBUTE15 VARCHAR2 (150)
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
COMPONENT_ITEM_DESC VARCHAR2 (240)
ALTERNATE_DESIGNATOR VARCHAR2 (10)
INVENTORY_ASSET_FLAG VARCHAR2 (1) Y
ITEM_LOCATOR_CONTROL NUMBER

RESTRICT_LOCATORS_FLAG NUMBER

RESTRICT_SUBINV_FLAG VARCHAR2 (1)
ITEM_TYPE VARCHAR2 (80)
INVENTORY_ITEM_STATUS_CODE VARCHAR2 (10) Y
BASIS_TYPE NUMBER

Component Basis type

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
SUBSTITUTE_COMPONENT_ID NUMBER
Y
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CO_PRODUCT_GROUP_ID NUMBER
Y
SUBSTITUTE_ITEM_QUANTITY NUMBER
Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PRIMARY_UOM_CODE VARCHAR2 (3)
DESCRIPTION VARCHAR2 (240)
BASIS_TYPE NUMBER

component basis type

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
WIP_ENTITY_ID NUMBER
Y
WIP_ENTITY_NAME VARCHAR2 (240) Y
STATUS_TYPE NUMBER
Y
PRIMARY_ITEM_ID NUMBER

SCHEDULED_START_DATE DATE
Y
SCHEDULED_COMPLETION_DATE DATE
Y
STATUS_TYPE_DISP VARCHAR2 (80) Y
ASSEMBLY_DESCRIPTION VARCHAR2 (240)
ORGANIZATION_ID NUMBER
Y

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Y
SUBINVENTORY_CODE VARCHAR2 (10)
TRANSACTION_DATE DATE
Y
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ORGANIZATION_CODE VARCHAR2 (3)
ORGANIZATION_NAME VARCHAR2 (240) Y
TRANSACTION_TYPE VARCHAR2 (240)
TRANSACTION_ACTION VARCHAR2 (80) Y
SOURCE_TYPE VARCHAR2 (240)
LOCATOR_ID NUMBER

ORGANIZATION_ID NUMBER
Y

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER

OBJECT_TYPE NUMBER

ORGANIZATION_ID NUMBER
Y
TRANSACTION_ID NUMBER
Y
TRANSACTION_DATE DATE
Y
ORGANIZATION_CODE VARCHAR2 (3)
TRANSACTION_SOURCE_NAME VARCHAR2 (30) Y
TRANSACTION_SOURCE VARCHAR2 (4000)
TRADING_PARTNER VARCHAR2 (0)
PROJECT VARCHAR2 (0)
TASK VARCHAR2 (0)
TRANSACTION_QUANTITY NUMBER
Y
TRANSACTION_UOM VARCHAR2 (3) Y
PRIMARY_QUANTITY NUMBER
Y
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SOURCE_CODE VARCHAR2 (30)
SOURCE_LINE_ID NUMBER

TRANSACTION_TYPE_ID NUMBER
Y
LPN_NUMBER VARCHAR2 (30)
TRANSFER_LPN_NUMBER VARCHAR2 (30)
CONTENT_LPN_NUMBER VARCHAR2 (30)
LOCATOR_ID NUMBER

SUBINVENTORY_CODE VARCHAR2 (10)
SUPPLIER_LOT_NUMBER VARCHAR2 (30)
TRANSACTION_LOT_NUMBER VARCHAR2 (0)
SECONDARY_QUANTITY VARCHAR2 (0)
GRADE_CODE VARCHAR2 (0)

[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 not referenced by any database object

[top of page]

View: WSM_ITEM_EXTENSIONS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ORGANIZATION_ID NUMBER
Y
INVENTORY_ITEM_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Y Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECTOR_EXTENSION_ID NUMBER
Y
ITEM_NUMBER VARCHAR2 (40)
DESCRIPTION VARCHAR2 (240)

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER

WIP Job Identifier
FM_OPERATION_SEQ_NUM NUMBER

From operation number
TO_OPERATION_SEQ_NUM NUMBER

TO_WO_OPERATION_SEQ_NUM NUMBER

TO_BOS_OPERATION_SEQ_NUM NUMBER

FM_OPERATION_SEQ_ID NUMBER

TO_OPERATION_SEQ_ID NUMBER

OPERATION_CODE VARCHAR2 (4)
Short code that uniquely identifies the current operation
NEXT_OPERATION_CODE VARCHAR2 (4)
Short code that uniquely identifies the Next operation
OPERATION_DESCRIPTION VARCHAR2 (240)
Descriptive text for the operation
STANDARD_OPERATION_ID NUMBER

Standard Operation Identifier
DEPARTMENT_CODE VARCHAR2 (10)
Department Code
DEPARTMENT_ID NUMBER

Department Identifier

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
STANDARD_OPERATION_ID NUMBER
Y
OPERATION_CODE VARCHAR2 (4) Y
OPERATION_DESCRIPTION VARCHAR2 (240)
ORGANIZATION_ID NUMBER
Y
SECONDARY_INVENTORY_NAME VARCHAR2 (10)
INVENTORY_LOCATION_ID NUMBER

QUEUE_MANDATORY_FLAG NUMBER

RUN_MANDATORY_FLAG NUMBER

TO_MOVE_MANDATORY_FLAG NUMBER

CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

[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 not referenced by any database object

[top of page]

View: WSM_SM_RESULTING_JOBS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Unique Row Identifier
TRANSACTION_ID NUMBER (15) Y Transaction Identifier
WIP_ENTITY_NAME VARCHAR2 (240) Y WIP Job Name
WIP_ENTITY_ID NUMBER

WIP Job Identifier
DESCRIPTION VARCHAR2 (240)
Description of the discrete job or repetitive assembly
ORGANIZATION_ID NUMBER
Y Organization Identifier
PRIMARY_ITEM_ID NUMBER

Inventory item Identifier for the assembly the job or schedule creates
CLASS_CODE VARCHAR2 (10)
WIP Accounting class for the job.
START_QUANTITY NUMBER
Y Starting Job Quantity
JOB_TYPE VARCHAR2 (12)
BOM_REFERENCE_ID NUMBER

Assembly identifier used as bill of material reference for explosions of nonstandard job
ROUTING_REFERENCE_ID NUMBER

Assembly identifier used as routing reference for explosions of nonstandard job
COMMON_BOM_SEQUENCE_ID NUMBER

Bill of material identifier when a common bill is used
COMMON_ROUTING_SEQUENCE_ID NUMBER

Routing identifier when a common routing is used
BOM_REVISION VARCHAR2 (3)
BOM revision for the primary assembly
ROUTING_REVISION VARCHAR2 (3)
Routing revision for the primary assembly
BOM_REVISION_DATE DATE

Date of assembly item revision used to explode the bills of material used in the job
ROUTING_REVISION_DATE DATE

Routing revision date
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate BOM Designator used in a Job.
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate Routing Designator used in a Job.
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Default completion subinventory for assemblies completed by the job
COMPLETION_LOCATOR_ID NUMBER

Default completion locator identifier for assemblies completed by the job
STARTING_OPERATION_SEQ_NUM NUMBER
Y Starting Operation Sequence Number
STARTING_OPERATION_CODE VARCHAR2 (4)
Starting Operation Code
STARTING_INTRAOPERATION_STEP NUMBER

Starting Intra-operation step
STARTING_STD_OP_ID NUMBER

Starting Standard Operation Identifier
STARTING_INTRAOP_STEP_TEXT VARCHAR2 (80) Y Starting Intra-operation step text
OPERATION_DESCRIPTION VARCHAR2 (240)
Operation Description
DEPARTMENT_CODE VARCHAR2 (10) Y Department code
DEPARTMENT_ID NUMBER
Y Department ID
SCHEDULED_START_DATE DATE

Date on which job is scheduled to start
SCHEDULED_COMPLETION_DATE DATE

Last unit scheduled completion date
DEMAND_CLASS VARCHAR2 (30)
Type of demand the job satisfies
BONUS_ACCT_ID NUMBER (15)
Bonus Account Identifier
FORWARD_OP_OPTION NUMBER

Forward Operations Option
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
NET_QUANTITY NUMBER

Number of assemblies netted to supply by MRP
COPRODUCTS_SUPPLY NUMBER

Coproducts Supply
SPLIT_HAS_UPDATE_ASSY NUMBER

Value of '0' means 'no update assy' and value of '1' means 'split and update assembly'

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Unique Row Identifier
TRANSACTION_ID NUMBER (15) Y Transaction Identifier
WIP_ENTITY_ID NUMBER
Y WIP Job Identifier
WIP_ENTITY_NAME VARCHAR2 (240)
WIP Job Name
CLASS_CODE VARCHAR2 (10) Y WIP Accounting class for the job.
KANBAN_CARD_ID NUMBER

DESCRIPTION VARCHAR2 (240)
Description of the discrete job or repetitive assembly
REPRESENTATIVE_FLAG VARCHAR2 (1)
Representative Job Flag
PRIMARY_ITEM_ID NUMBER

Inventory item Identifier for the assembly the job or schedule creates
OPERATION_SEQ_NUM NUMBER

Operation Sequence Number
STANDARD_OP_CODE VARCHAR2 (4)
Standard Operation Code
STANDARD_OPERATION_ID NUMBER

Standard Operation Identifier
OPERATION_DESCRIPTION VARCHAR2 (240)
Operation Description
INTRAOPERATION_STEP NUMBER

Intraoperation step
DEPARTMENT_CODE VARCHAR2 (10)
Department Code
DEPARTMENT_ID NUMBER

INTRAOPERATION_STEP_TEXT VARCHAR2 (80) Y Intraoperation step text
AVAILABLE_QUANTITY NUMBER
Y Available Quantity
JOB_START_QUANTITY NUMBER

Quantity at which the job started
QTY_COMPLETED NUMBER
Y Quantity Completed by the job
JOB_TYPE VARCHAR2 (12)
SCHEDULED_START_DATE DATE

Date on which job is scheduled to start
SCHEDULED_COMPLETION_DATE DATE

Last unit scheduled completion date
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Default completion subinventory for assemblies completed by the job
COMPLETION_LOCATOR_ID NUMBER (15)
Default completion locator identifier for assemblies completed by the job
BOM_REFERENCE_ID NUMBER

Assembly identifier used as bill of material reference for explosions of nonstandard job
COMMON_BOM_SEQUENCE_ID NUMBER

Bill of material identifier when a common bill is used
BOM_REVISION VARCHAR2 (3)
BOM revision for the primary assembly
BOM_REVISION_DATE DATE

Date of assembly item revision used to explode the bills of material used in the job
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate BOM Designator used in a Job.
ROUTING_REFERENCE_ID NUMBER

Assembly identifier used as routing reference for explosions of nonstandard job
COMMON_ROUTING_SEQUENCE_ID NUMBER

Routing identifier when a common routing is used
ROUTING_REVISION VARCHAR2 (3)
Routing revision for the primary assembly
ROUTING_REVISION_DATE DATE

Routing revision date
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate Routing Designator used in a Job.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
COPRODUCTS_SUPPLY NUMBER

Coproducts Supply
NET_QUANTITY NUMBER

MRP Net Quantity
KANBAN_CARD_NUMBER VARCHAR2 (200)

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
LOT_NUMBER VARCHAR2 (80) Y
INVENTORY_ITEM_ID NUMBER
Y
ORGANIZATION_ID NUMBER
Y
SUBINVENTORY_CODE VARCHAR2 (10) Y
LOCATOR_ID NUMBER

REVISION VARCHAR2 (3)
QUANTITY NUMBER

PRIMARY_QUANTITY NUMBER

primary quantity
ITEM VARCHAR2 (40)

[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 not referenced by any database object

[top of page]

View: WSM_STANDARD_CLASSES_VAL_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
CLASS_CODE VARCHAR2 (10) Y
DESCRIPTION VARCHAR2 (240)
CLASS_TYPE NUMBER
Y
MATERIAL_ACCOUNT NUMBER

MATERIAL_VARIANCE_ACCOUNT NUMBER

MATERIAL_OVERHEAD_ACCOUNT NUMBER

RESOURCE_ACCOUNT NUMBER

RESOURCE_VARIANCE_ACCOUNT NUMBER

OUTSIDE_PROCESSING_ACCOUNT NUMBER

OUTSIDE_PROC_VARIANCE_ACCOUNT NUMBER

OVERHEAD_ACCOUNT NUMBER

OVERHEAD_VARIANCE_ACCOUNT NUMBER

STD_COST_ADJUSTMENT_ACCOUNT NUMBER

ORGANIZATION_ID NUMBER
Y

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Y
WIP_ENTITY_NAME VARCHAR2 (240) Y
ORGANIZATION_ID NUMBER
Y
ORGANIZATION_CODE VARCHAR2 (3)
ORGANIZATION_NAME VARCHAR2 (240) Y
STATUS_TYPE VARCHAR2 (80) Y
ITEM_NUMBER VARCHAR2 (40)
ITEM_DESCRIPTION VARCHAR2 (240)
FIRM_PLANNED_FLAG NUMBER
Y
CLASS_CODE VARCHAR2 (10) Y
SCHEDULED_START_DATE DATE
Y
DATE_RELEASED DATE

SCHEDULED_COMPLETION_DATE DATE
Y
DATE_COMPLETED DATE

DATE_CLOSED DATE

START_QUANTITY NUMBER
Y
QUANTITY_REMAINING VARCHAR2 (40)
QUANTITY_COMPLETED VARCHAR2 (40)
QUANTITY_SCRAPPED VARCHAR2 (40)
NET_QUANTITY NUMBER
Y
COMPLETION_SUBINVENTORY VARCHAR2 (10)
JOB_TYPE NUMBER
Y

[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 not referenced by any database object

[top of page]

View: WSM_WIP_LOT_TXNS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_DATE DATE

TRANSACTION_TYPE VARCHAR2 (80)
PREV_WIP_ENTITY_NAME VARCHAR2 (240)
PREV_START_QUANTITY NUMBER

PREV_WIP_ENTITY_ID NUMBER

PREV_ALT_ROUTING_DESIGNATOR VARCHAR2 (10)
PREV_PRIMARY_ITEM_ID NUMBER

CHG_WIP_ENTITY_NAME VARCHAR2 (240)
CHG_WIP_ENTITY_ID NUMBER

CHG_START_QUANTITY NUMBER

CHG_ALT_ROUTING_DESIGNATOR VARCHAR2 (10)
CHG_PRIMARY_ITEM_ID NUMBER

OBJECT_ID NUMBER

OBJECT_TYPE NUMBER

CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
TRANSACTION_ID NUMBER (15)

[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 not referenced by any database object

[top of page]

View: WSM_WIP_OPERATIONS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Y
OPERATION_SEQ_NUM NUMBER
Y
ORGANIZATION_ID NUMBER
Y
REPETITIVE_SCHEDULE_ID NUMBER

LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
OPERATION_SEQUENCE_ID NUMBER

STANDARD_OPERATION_ID NUMBER

DEPARTMENT_ID NUMBER
Y
DESCRIPTION VARCHAR2 (240)
SCHEDULED_QUANTITY NUMBER
Y
QUANTITY_IN_QUEUE NUMBER
Y
QUANTITY_RUNNING NUMBER
Y
QUANTITY_WAITING_TO_MOVE NUMBER
Y
QUANTITY_REJECTED NUMBER
Y
QUANTITY_SCRAPPED NUMBER
Y
QUANTITY_COMPLETED NUMBER
Y
FIRST_UNIT_START_DATE DATE
Y
FIRST_UNIT_COMPLETION_DATE DATE
Y
LAST_UNIT_START_DATE DATE
Y
LAST_UNIT_COMPLETION_DATE DATE
Y
PREVIOUS_OPERATION_SEQ_NUM NUMBER

NEXT_OPERATION_SEQ_NUM NUMBER

COUNT_POINT_TYPE NUMBER
Y
BACKFLUSH_FLAG NUMBER
Y
MINIMUM_TRANSFER_QUANTITY NUMBER
Y
DATE_LAST_MOVED DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
PRE_SPLIT_QUANTITY NUMBER

OPERATION_YIELD_ENABLED NUMBER

OPERATION_YIELD NUMBER

PREVIOUS_OPERATION_SEQ_ID NUMBER

[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