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_OPERATIONS

Product:	WIP - Work in Process
Description:	Operations necessary for jobs and schedules
Implementation/DBA Data:	WIP.WIP_OPERATIONS

Primary Key: WIP_OPERATIONS_PK

WIP_ENTITY_ID
OPERATION_SEQ_NUM
REPETITIVE_SCHEDULE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
WIP_OPERATIONS	BOM_DEPARTMENTS	WIP_OPERATIONS.DEPARTMENT_ID
WIP_OPERATIONS	BOM_OPERATION_SEQUENCES	WIP_OPERATIONS.OPERATION_SEQUENCE_ID
WIP_OPERATIONS	WIP_OPERATIONS	WIP_OPERATIONS.WIP_ENTITY_ID WIP_OPERATIONS.PREVIOUS_OPERATION_SEQ_NUM WIP_OPERATIONS.REPETITIVE_SCHEDULE_ID
WIP_OPERATIONS	WIP_OPERATIONS	WIP_OPERATIONS.WIP_ENTITY_ID WIP_OPERATIONS.NEXT_OPERATION_SEQ_NUM WIP_OPERATIONS.REPETITIVE_SCHEDULE_ID
WIP_OPERATIONS	WIP_REPETITIVE_SCHEDULES	WIP_OPERATIONS.REPETITIVE_SCHEDULE_ID
WIP_OPERATIONS	WIP_DISCRETE_JOBS	WIP_OPERATIONS.WIP_ENTITY_ID
JAI_PO_OSP_LINES	WIP_OPERATIONS	JAI_PO_OSP_LINES.WIP_ENTITY_ID JAI_PO_OSP_LINES.WIP_OPERATION_SEQUENCE_NUM JAI_PO_OSP_LINES.WIP_REPETITIVE_SCHEDULE_ID
WIP_MOVE_TXN_INTERFACE	WIP_OPERATIONS	WIP_MOVE_TXN_INTERFACE.WIP_ENTITY_ID WIP_MOVE_TXN_INTERFACE.TO_OPERATION_SEQ_NUM WIP_MOVE_TXN_INTERFACE.REPETITIVE_SCHEDULE_ID
WIP_MOVE_TXN_INTERFACE	WIP_OPERATIONS	WIP_MOVE_TXN_INTERFACE.WIP_ENTITY_ID WIP_MOVE_TXN_INTERFACE.FM_OPERATION_SEQ_NUM WIP_MOVE_TXN_INTERFACE.REPETITIVE_SCHEDULE_ID
WIP_OPERATIONS	WIP_OPERATIONS	WIP_OPERATIONS.WIP_ENTITY_ID WIP_OPERATIONS.PREVIOUS_OPERATION_SEQ_NUM WIP_OPERATIONS.REPETITIVE_SCHEDULE_ID
WIP_OPERATIONS	WIP_OPERATIONS	WIP_OPERATIONS.WIP_ENTITY_ID WIP_OPERATIONS.NEXT_OPERATION_SEQ_NUM WIP_OPERATIONS.REPETITIVE_SCHEDULE_ID
WIP_OPERATION_RESOURCES	WIP_OPERATIONS	WIP_OPERATION_RESOURCES.WIP_ENTITY_ID WIP_OPERATION_RESOURCES.OPERATION_SEQ_NUM WIP_OPERATION_RESOURCES.REPETITIVE_SCHEDULE_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_SUB_OPERATION_RESOURCES	WIP_OPERATIONS	WIP_SUB_OPERATION_RESOURCES.WIP_ENTITY_ID WIP_SUB_OPERATION_RESOURCES.OPERATION_SEQ_NUM WIP_SUB_OPERATION_RESOURCES.REPETITIVE_SCHEDULE_ID