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_ENTITIES

Product:	WIP - Work in Process
Description:	Information common to jobs and schedules
Implementation/DBA Data:	WIP.WIP_ENTITIES

Primary Key: WIP_ENTITIES_PK

WIP_ENTITY_ID

Primary Key: WIP_ENTITIES_UK

WIP_ENTITY_NAME
ORGANIZATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
WIP_ENTITIES	WIP_PARAMETERS	WIP_ENTITIES.ORGANIZATION_ID
WIP_ENTITIES	MTL_SYSTEM_ITEMS_B	WIP_ENTITIES.PRIMARY_ITEM_ID WIP_ENTITIES.ORGANIZATION_ID
AHL_WORKORDERS	WIP_ENTITIES	AHL_WORKORDERS.WIP_ENTITY_ID
CST_COMP_SNAPSHOT	WIP_ENTITIES	CST_COMP_SNAPSHOT.WIP_ENTITY_ID
CST_STD_COST_ADJ_DEBUG	WIP_ENTITIES	CST_STD_COST_ADJ_DEBUG.WIP_ENTITY_ID
CST_STD_COST_ADJ_TEMP	WIP_ENTITIES	CST_STD_COST_ADJ_TEMP.WIP_ENTITY_ID
CST_STD_COST_ADJ_VALUES	WIP_ENTITIES	CST_STD_COST_ADJ_VALUES.WIP_ENTITY_ID
JAI_PO_OSP_LINES	WIP_ENTITIES	JAI_PO_OSP_LINES.WIP_ENTITY_ID
MRP_ITEM_WIP_ENTITIES	WIP_ENTITIES	MRP_ITEM_WIP_ENTITIES.WIP_ENTITY_ID
MRP_RELIEF_INTERFACE	WIP_ENTITIES	MRP_RELIEF_INTERFACE.DISPOSITION_ID
MRP_SCHEDULE_CONSUMPTIONS	WIP_ENTITIES	MRP_SCHEDULE_CONSUMPTIONS.DISPOSITION_ID
MTL_KANBAN_CARD_ACTIVITY	WIP_ENTITIES	MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_HEADER_ID
MTL_SERIAL_NUMBERS	WIP_ENTITIES	MTL_SERIAL_NUMBERS.ORIGINAL_WIP_ENTITY_ID
MTL_USER_SUPPLY	WIP_ENTITIES	MTL_USER_SUPPLY.SOURCE_ID
PO_REQUISITION_LINES_ALL	WIP_ENTITIES	PO_REQUISITION_LINES_ALL.WIP_ENTITY_ID
QA_RESULTS	WIP_ENTITIES	QA_RESULTS.WORK_ORDER_ID
QA_RESULTS	WIP_ENTITIES	QA_RESULTS.WIP_ENTITY_ID
WIP_COST_TXN_INTERFACE	WIP_ENTITIES	WIP_COST_TXN_INTERFACE.WIP_ENTITY_ID
WIP_DISCRETE_JOBS	WIP_ENTITIES	WIP_DISCRETE_JOBS.WIP_ENTITY_ID
WIP_FLOW_SCHEDULES	WIP_ENTITIES	WIP_FLOW_SCHEDULES.WIP_ENTITY_ID
WIP_MOVE_TRANSACTIONS	WIP_ENTITIES	WIP_MOVE_TRANSACTIONS.WIP_ENTITY_ID
WIP_MOVE_TXN_INTERFACE	WIP_ENTITIES	WIP_MOVE_TXN_INTERFACE.WIP_ENTITY_ID
WIP_PAC_PERIOD_BALANCES	WIP_ENTITIES	WIP_PAC_PERIOD_BALANCES.WIP_ENTITY_ID
WIP_REPETITIVE_ITEMS	WIP_ENTITIES	WIP_REPETITIVE_ITEMS.WIP_ENTITY_ID
WIP_SHOP_FLOOR_STATUSES	WIP_ENTITIES	WIP_SHOP_FLOOR_STATUSES.WIP_ENTITY_ID
WIP_TEMP_REPORTS	WIP_ENTITIES	WIP_TEMP_REPORTS.WIP_ENTITY_ID
WIP_TRANSACTIONS	WIP_ENTITIES	WIP_TRANSACTIONS.WIP_ENTITY_ID
WIP_TRANSACTION_ACCOUNTS	WIP_ENTITIES	WIP_TRANSACTION_ACCOUNTS.WIP_ENTITY_ID
WSM_LOT_JOB_INTERFACE	WIP_ENTITIES	WSM_LOT_JOB_INTERFACE.JOB_NAME WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID
WSM_LOT_JOB_INTERFACE	WIP_ENTITIES	WSM_LOT_JOB_INTERFACE.WIP_ENTITY_ID
WSM_LOT_MOVE_TXN_INTERFACE	WIP_ENTITIES	WSM_LOT_MOVE_TXN_INTERFACE.WIP_ENTITY_ID
WSM_SM_RESULTING_JOBS	WIP_ENTITIES	WSM_SM_RESULTING_JOBS.WIP_ENTITY_ID
WSM_SM_STARTING_JOBS	WIP_ENTITIES	WSM_SM_STARTING_JOBS.WIP_ENTITY_ID
WSM_SPLIT_MERGE_SNAPSHOT	WIP_ENTITIES	WSM_SPLIT_MERGE_SNAPSHOT.WIP_ENTITY_ID
WSM_STARTING_JOBS_INTERFACE	WIP_ENTITIES	WSM_STARTING_JOBS_INTERFACE.WIP_ENTITY_ID