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_FLOW_SCHEDULES

Product:	WIP - Work in Process
Description:	Work order-less flow schedules
Implementation/DBA Data:	WIP.WIP_FLOW_SCHEDULES

Primary Key: WIP_FLOW_SCHEDULES_PK

WIP_ENTITY_ID

Primary Key: WIP_FLOW_SCHEDULES_UK

SCHEDULE_NUMBER
ORGANIZATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
WIP_FLOW_SCHEDULES	MTL_SYSTEM_ITEMS_B	WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID WIP_FLOW_SCHEDULES.ORGANIZATION_ID
WIP_FLOW_SCHEDULES	MTL_ITEM_REVISIONS_B	WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID WIP_FLOW_SCHEDULES.ORGANIZATION_ID WIP_FLOW_SCHEDULES.BOM_REVISION
WIP_FLOW_SCHEDULES	GL_CODE_COMBINATIONS	WIP_FLOW_SCHEDULES.RESOURCE_ACCOUNT
WIP_FLOW_SCHEDULES	GL_CODE_COMBINATIONS	WIP_FLOW_SCHEDULES.OUTSIDE_PROCESSING_ACCOUNT
WIP_FLOW_SCHEDULES	GL_CODE_COMBINATIONS	WIP_FLOW_SCHEDULES.MATERIAL_VARIANCE_ACCOUNT
WIP_FLOW_SCHEDULES	GL_CODE_COMBINATIONS	WIP_FLOW_SCHEDULES.RESOURCE_VARIANCE_ACCOUNT
WIP_FLOW_SCHEDULES	GL_CODE_COMBINATIONS	WIP_FLOW_SCHEDULES.OUTSIDE_PROC_VARIANCE_ACCOUNT
WIP_FLOW_SCHEDULES	GL_CODE_COMBINATIONS	WIP_FLOW_SCHEDULES.STD_COST_ADJUSTMENT_ACCOUNT
WIP_FLOW_SCHEDULES	GL_CODE_COMBINATIONS	WIP_FLOW_SCHEDULES.OVERHEAD_ACCOUNT
WIP_FLOW_SCHEDULES	GL_CODE_COMBINATIONS	WIP_FLOW_SCHEDULES.OVERHEAD_VARIANCE_ACCOUNT
WIP_FLOW_SCHEDULES	MTL_KANBAN_CARDS	WIP_FLOW_SCHEDULES.KANBAN_CARD_ID
WIP_FLOW_SCHEDULES	BOM_STRUCTURES_B	WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID WIP_FLOW_SCHEDULES.ORGANIZATION_ID WIP_FLOW_SCHEDULES.ALTERNATE_BOM_DESIGNATOR
WIP_FLOW_SCHEDULES	MTL_RTG_ITEM_REVISIONS	WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID WIP_FLOW_SCHEDULES.ORGANIZATION_ID WIP_FLOW_SCHEDULES.ROUTING_REVISION
WIP_FLOW_SCHEDULES	BOM_OPERATIONAL_ROUTINGS	WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID WIP_FLOW_SCHEDULES.ORGANIZATION_ID WIP_FLOW_SCHEDULES.ALTERNATE_ROUTING_DESIGNATOR
WIP_FLOW_SCHEDULES	PJM_UNIT_NUMBERS	WIP_FLOW_SCHEDULES.END_ITEM_UNIT_NUMBER
WIP_FLOW_SCHEDULES	WIP_ENTITIES	WIP_FLOW_SCHEDULES.WIP_ENTITY_ID
WIP_FLOW_SCHEDULES	MTL_ITEM_LOCATIONS	WIP_FLOW_SCHEDULES.COMPLETION_LOCATOR_ID WIP_FLOW_SCHEDULES.ORGANIZATION_ID
WIP_FLOW_SCHEDULES	MTL_ITEM_SUB_INVENTORIES	WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID WIP_FLOW_SCHEDULES.ORGANIZATION_ID WIP_FLOW_SCHEDULES.COMPLETION_SUBINVENTORY
WIP_FLOW_SCHEDULES	WIP_ACCOUNTING_CLASSES	WIP_FLOW_SCHEDULES.CLASS_CODE WIP_FLOW_SCHEDULES.ORGANIZATION_ID
WIP_FLOW_SCHEDULES	GL_CODE_COMBINATIONS	WIP_FLOW_SCHEDULES.MATERIAL_ACCOUNT
WIP_FLOW_SCHEDULES	GL_CODE_COMBINATIONS	WIP_FLOW_SCHEDULES.MATERIAL_OVERHEAD_ACCOUNT
MTL_MATERIAL_TRANSACTIONS	WIP_FLOW_SCHEDULES	MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	WIP_FLOW_SCHEDULES	MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID
MTL_TRANSACTIONS_INTERFACE	WIP_FLOW_SCHEDULES	MTL_TRANSACTIONS_INTERFACE.SCHEDULE_NUMBER MTL_TRANSACTIONS_INTERFACE.ORGANIZATION_ID
WIP_PERIOD_BALANCES	WIP_FLOW_SCHEDULES	WIP_PERIOD_BALANCES.WIP_ENTITY_ID