eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: WIP_REQUIREMENT_OPERATIONS

Product:	WIP - Work in Process
Description:	Components required by jobs and schedules
Implementation/DBA Data:	WIP.WIP_REQUIREMENT_OPERATIONS

Primary Key: WIP_REQUIREMENT_OPERATIONS_PK

INVENTORY_ITEM_ID
WIP_ENTITY_ID
OPERATION_SEQ_NUM
REPETITIVE_SCHEDULE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
WIP_REQUIREMENT_OPERATIONS	MTL_SYSTEM_ITEMS_B	WIP_REQUIREMENT_OPERATIONS.INVENTORY_ITEM_ID WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID
WIP_REQUIREMENT_OPERATIONS	WIP_REPETITIVE_SCHEDULES	WIP_REQUIREMENT_OPERATIONS.REPETITIVE_SCHEDULE_ID
WIP_REQUIREMENT_OPERATIONS	WIP_DISCRETE_JOBS	WIP_REQUIREMENT_OPERATIONS.WIP_ENTITY_ID
WIP_REQUIREMENT_OPERATIONS	BOM_COMPONENTS_B	WIP_REQUIREMENT_OPERATIONS.COMPONENT_SEQUENCE_ID
WIP_REQUIREMENT_OPERATIONS	WIP_OPERATIONS	WIP_REQUIREMENT_OPERATIONS.WIP_ENTITY_ID WIP_REQUIREMENT_OPERATIONS.OPERATION_SEQ_NUM WIP_REQUIREMENT_OPERATIONS.REPETITIVE_SCHEDULE_ID
WIP_REQUIREMENT_OPERATIONS	MTL_ITEM_SUB_INVENTORIES	WIP_REQUIREMENT_OPERATIONS.INVENTORY_ITEM_ID WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID WIP_REQUIREMENT_OPERATIONS.SUPPLY_SUBINVENTORY
WIP_REQUIREMENT_OPERATIONS	MTL_SECONDARY_INVENTORIES	WIP_REQUIREMENT_OPERATIONS.SUPPLY_SUBINVENTORY WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID
WIP_REQUIREMENT_OPERATIONS	MTL_ITEM_LOCATIONS	WIP_REQUIREMENT_OPERATIONS.SUPPLY_LOCATOR_ID WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID
WIP_REQUIREMENT_OPERATIONS	MTL_SECONDARY_LOCATORS	WIP_REQUIREMENT_OPERATIONS.INVENTORY_ITEM_ID WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID WIP_REQUIREMENT_OPERATIONS.SUPPLY_LOCATOR_ID
WIP_REQUIREMENT_OPERATIONS	BOM_DEPARTMENTS	WIP_REQUIREMENT_OPERATIONS.DEPARTMENT_ID