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: BOM_OPERATIONAL_ROUTINGS

Product:	BOM - Bills of Material
Description:	Routings
Implementation/DBA Data:	BOM.BOM_OPERATIONAL_ROUTINGS

Primary Key: BOM_OPERATIONAL_ROUTINGS_PK

ROUTING_SEQUENCE_ID

Primary Key: BOM_OPERATIONAL_ROUTINGS_UK1

ASSEMBLY_ITEM_ID
ORGANIZATION_ID
ALTERNATE_ROUTING_DESIGNATOR

Foreign Keys

Table	Foreign Table	Foreign Key Column
BOM_OPERATIONAL_ROUTINGS	BOM_ALTERNATE_DESIGNATORS	BOM_OPERATIONAL_ROUTINGS.ALTERNATE_ROUTING_DESIGNATOR BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID
BOM_OPERATIONAL_ROUTINGS	MTL_SYSTEM_ITEMS_B	BOM_OPERATIONAL_ROUTINGS.COMMON_ASSEMBLY_ITEM_ID BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID
BOM_OPERATIONAL_ROUTINGS	MTL_SYSTEM_ITEMS_B	BOM_OPERATIONAL_ROUTINGS.ASSEMBLY_ITEM_ID BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID
BOM_OPERATIONAL_ROUTINGS	BOM_OPERATIONAL_ROUTINGS	BOM_OPERATIONAL_ROUTINGS.COMMON_ROUTING_SEQUENCE_ID
BOM_OPERATIONAL_ROUTINGS	MTL_SECONDARY_INVENTORIES	BOM_OPERATIONAL_ROUTINGS.COMPLETION_SUBINVENTORY BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID
BOM_OPERATIONAL_ROUTINGS	MTL_ITEM_LOCATIONS	BOM_OPERATIONAL_ROUTINGS.COMPLETION_LOCATOR_ID BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID
BOM_OPERATIONAL_ROUTINGS	WIP_LINES	BOM_OPERATIONAL_ROUTINGS.LINE_ID
BOM_DELETE_ENTITIES	BOM_OPERATIONAL_ROUTINGS	BOM_DELETE_ENTITIES.ROUTING_SEQUENCE_ID
BOM_OPERATIONAL_ROUTINGS	BOM_OPERATIONAL_ROUTINGS	BOM_OPERATIONAL_ROUTINGS.COMMON_ROUTING_SEQUENCE_ID
BOM_OPERATION_SEQUENCES	BOM_OPERATIONAL_ROUTINGS	BOM_OPERATION_SEQUENCES.ROUTING_SEQUENCE_ID
WIP_DISCRETE_JOBS	BOM_OPERATIONAL_ROUTINGS	WIP_DISCRETE_JOBS.COMMON_ROUTING_SEQUENCE_ID
WIP_JOB_SCHEDULE_INTERFACE	BOM_OPERATIONAL_ROUTINGS	WIP_JOB_SCHEDULE_INTERFACE.PRIMARY_ITEM_ID WIP_JOB_SCHEDULE_INTERFACE.ORGANIZATION_ID WIP_JOB_SCHEDULE_INTERFACE.ALTERNATE_ROUTING_DESIGNATOR
WIP_FLOW_SCHEDULES	BOM_OPERATIONAL_ROUTINGS	WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID WIP_FLOW_SCHEDULES.ORGANIZATION_ID WIP_FLOW_SCHEDULES.ALTERNATE_ROUTING_DESIGNATOR
WIP_REPETITIVE_ITEMS	BOM_OPERATIONAL_ROUTINGS	WIP_REPETITIVE_ITEMS.PRIMARY_ITEM_ID WIP_REPETITIVE_ITEMS.ORGANIZATION_ID WIP_REPETITIVE_ITEMS.ALTERNATE_ROUTING_DESIGNATOR
WIP_REPETITIVE_SCHEDULES	BOM_OPERATIONAL_ROUTINGS	WIP_REPETITIVE_SCHEDULES.COMMON_ROUTING_SEQUENCE_ID
WSM_LOT_JOB_INTERFACE	BOM_OPERATIONAL_ROUTINGS	WSM_LOT_JOB_INTERFACE.PRIMARY_ITEM_ID WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID WSM_LOT_JOB_INTERFACE.ALTERNATE_ROUTING_DESIGNATOR