FND Design Data [Home] [Help]

Table: WIP_REQUIREMENT_OPERATIONS

Product: WIP - Work in Process
Description: Components required by jobs and schedules
Implementation/DBA Data: TableWIP.WIP_REQUIREMENT_OPERATIONS
Primary Key: WIP_REQUIREMENT_OPERATIONS_PK
  1. ColumnINVENTORY_ITEM_ID
  2. ColumnWIP_ENTITY_ID
  3. ColumnOPERATION_SEQ_NUM
  4. ColumnREPETITIVE_SCHEDULE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
WIP_REQUIREMENT_OPERATIONS FK Joins to TableMTL_SYSTEM_ITEMS_B WIP_REQUIREMENT_OPERATIONS.INVENTORY_ITEM_ID
WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID
WIP_REQUIREMENT_OPERATIONS FK Joins to TableWIP_REPETITIVE_SCHEDULES WIP_REQUIREMENT_OPERATIONS.REPETITIVE_SCHEDULE_ID
WIP_REQUIREMENT_OPERATIONS FK Joins to TableWIP_DISCRETE_JOBS WIP_REQUIREMENT_OPERATIONS.WIP_ENTITY_ID
WIP_REQUIREMENT_OPERATIONS FK Joins to TableBOM_COMPONENTS_B WIP_REQUIREMENT_OPERATIONS.COMPONENT_SEQUENCE_ID
WIP_REQUIREMENT_OPERATIONS FK Joins to TableWIP_OPERATIONS WIP_REQUIREMENT_OPERATIONS.WIP_ENTITY_ID
WIP_REQUIREMENT_OPERATIONS.OPERATION_SEQ_NUM
WIP_REQUIREMENT_OPERATIONS.REPETITIVE_SCHEDULE_ID
WIP_REQUIREMENT_OPERATIONS FK Joins to TableMTL_ITEM_SUB_INVENTORIES WIP_REQUIREMENT_OPERATIONS.INVENTORY_ITEM_ID
WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID
WIP_REQUIREMENT_OPERATIONS.SUPPLY_SUBINVENTORY
WIP_REQUIREMENT_OPERATIONS FK Joins to TableMTL_SECONDARY_INVENTORIES WIP_REQUIREMENT_OPERATIONS.SUPPLY_SUBINVENTORY
WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID
WIP_REQUIREMENT_OPERATIONS FK Joins to TableMTL_ITEM_LOCATIONS WIP_REQUIREMENT_OPERATIONS.SUPPLY_LOCATOR_ID
WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID
WIP_REQUIREMENT_OPERATIONS FK Joins to TableMTL_SECONDARY_LOCATORS WIP_REQUIREMENT_OPERATIONS.INVENTORY_ITEM_ID
WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID
WIP_REQUIREMENT_OPERATIONS.SUPPLY_LOCATOR_ID
WIP_REQUIREMENT_OPERATIONS FK Joins to TableBOM_DEPARTMENTS WIP_REQUIREMENT_OPERATIONS.DEPARTMENT_ID