FND Design Data [Home] [Help]

Table: WSM_LOT_JOB_INTERFACE

Product: WSM - Shop Floor Management
Description: Interface table for the Import of Lot based Jobs in OSFM.
Implementation/DBA Data: TableWSM.WSM_LOT_JOB_INTERFACE
Primary Key: WSM_LOT_JOB_INTERFACE_PK
  1. ColumnHEADER_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
WSM_LOT_JOB_INTERFACE FK Joins to TableBOM_BILL_OF_MATERIALS WSM_LOT_JOB_INTERFACE.PRIMARY_ITEM_ID
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID
WSM_LOT_JOB_INTERFACE.ALTERNATE_BOM_DESIGNATOR
WSM_LOT_JOB_INTERFACE FK Joins to TableBOM_OPERATIONAL_ROUTINGS WSM_LOT_JOB_INTERFACE.PRIMARY_ITEM_ID
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID
WSM_LOT_JOB_INTERFACE.ALTERNATE_ROUTING_DESIGNATOR
WSM_LOT_JOB_INTERFACE FK Joins to TableMTL_ITEM_LOCATIONS WSM_LOT_JOB_INTERFACE.COMPLETION_LOCATOR_ID
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID
WSM_LOT_JOB_INTERFACE FK Joins to TableMTL_SECONDARY_INVENTORIES WSM_LOT_JOB_INTERFACE.COMPLETION_SUBINVENTORY
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID
WSM_LOT_JOB_INTERFACE FK Joins to TableWIP_ACCOUNTING_CLASSES WSM_LOT_JOB_INTERFACE.CLASS_CODE
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID
WSM_LOT_JOB_INTERFACE FK Joins to TableWIP_ENTITIES WSM_LOT_JOB_INTERFACE.JOB_NAME
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID
WSM_LOT_JOB_INTERFACE FK Joins to TableWIP_ENTITIES WSM_LOT_JOB_INTERFACE.WIP_ENTITY_ID
WSM_LOT_JOB_INTERFACE FK Joins to TableWSM_PARAMETERS WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID