FND Design Data [Home] [Help]

Table: WIP_REPETITIVE_ITEMS

Product: WIP - Work in Process
Description: Line/assembly associations
Implementation/DBA Data: TableWIP.WIP_REPETITIVE_ITEMS
Primary Key: WIP_REPETITIVE_ITEMS_PK
  1. ColumnWIP_ENTITY_ID
  2. ColumnLINE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
WIP_REPETITIVE_ITEMS FK Joins to TableMTL_SYSTEM_ITEMS_B WIP_REPETITIVE_ITEMS.PRIMARY_ITEM_ID
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID
WIP_REPETITIVE_ITEMS FK Joins to TableBOM_OPERATIONAL_ROUTINGS WIP_REPETITIVE_ITEMS.PRIMARY_ITEM_ID
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID
WIP_REPETITIVE_ITEMS.ALTERNATE_ROUTING_DESIGNATOR
WIP_REPETITIVE_ITEMS FK Joins to TableWIP_ENTITIES WIP_REPETITIVE_ITEMS.WIP_ENTITY_ID
WIP_REPETITIVE_ITEMS FK Joins to TableWIP_ACCOUNTING_CLASSES WIP_REPETITIVE_ITEMS.CLASS_CODE
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID
WIP_REPETITIVE_ITEMS FK Joins to TableWIP_LINES WIP_REPETITIVE_ITEMS.LINE_ID
WIP_REPETITIVE_ITEMS FK Joins to TableMTL_ITEM_SUB_INVENTORIES WIP_REPETITIVE_ITEMS.PRIMARY_ITEM_ID
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID
WIP_REPETITIVE_ITEMS.COMPLETION_SUBINVENTORY
WIP_REPETITIVE_ITEMS FK Joins to TableMTL_SECONDARY_INVENTORIES WIP_REPETITIVE_ITEMS.COMPLETION_SUBINVENTORY
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID
WIP_REPETITIVE_ITEMS FK Joins to TableMTL_ITEM_LOCATIONS WIP_REPETITIVE_ITEMS.COMPLETION_LOCATOR_ID
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID
WIP_REPETITIVE_ITEMS FK Joins to TableMTL_SECONDARY_LOCATORS WIP_REPETITIVE_ITEMS.PRIMARY_ITEM_ID
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID
WIP_REPETITIVE_ITEMS.COMPLETION_LOCATOR_ID
WIP_REPETITIVE_ITEMS FK Joins to TableBOM_STRUCTURES_B WIP_REPETITIVE_ITEMS.PRIMARY_ITEM_ID
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID
WIP_REPETITIVE_ITEMS.ALTERNATE_BOM_DESIGNATOR
TableMTL_MATERIAL_TRANSACTIONS FK Joins to WIP_REPETITIVE_ITEMS MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_ID
MTL_MATERIAL_TRANSACTIONS.REPETITIVE_LINE_ID
TableWIP_REPETITIVE_SCHEDULES FK Joins to WIP_REPETITIVE_ITEMS WIP_REPETITIVE_SCHEDULES.WIP_ENTITY_ID
WIP_REPETITIVE_SCHEDULES.LINE_ID
TableWIP_REPETITIVE_SCHEDULES FK Joins to WIP_REPETITIVE_ITEMS WIP_REPETITIVE_SCHEDULES.WIP_ENTITY_ID
WIP_REPETITIVE_SCHEDULES.LINE_ID
TableWIP_SHOP_FLOOR_STATUSES FK Joins to WIP_REPETITIVE_ITEMS WIP_SHOP_FLOOR_STATUSES.WIP_ENTITY_ID
WIP_SHOP_FLOOR_STATUSES.LINE_ID