FND Design Data [Home] [Help]

Table: BOM_OPERATIONAL_ROUTINGS

Product: BOM - Bills of Material
Description: Routings
Implementation/DBA Data: TableBOM.BOM_OPERATIONAL_ROUTINGS
Primary Key: BOM_OPERATIONAL_ROUTINGS_PK
  1. ColumnROUTING_SEQUENCE_ID
Primary Key: BOM_OPERATIONAL_ROUTINGS_UK1
  1. ColumnASSEMBLY_ITEM_ID
  2. ColumnORGANIZATION_ID
  3. ColumnALTERNATE_ROUTING_DESIGNATOR
Foreign Keys
Table
Foreign Table Foreign Key Column
BOM_OPERATIONAL_ROUTINGS FK Joins to TableBOM_ALTERNATE_DESIGNATORS BOM_OPERATIONAL_ROUTINGS.ALTERNATE_ROUTING_DESIGNATOR
BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID
BOM_OPERATIONAL_ROUTINGS FK Joins to TableMTL_SYSTEM_ITEMS_B BOM_OPERATIONAL_ROUTINGS.COMMON_ASSEMBLY_ITEM_ID
BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID
BOM_OPERATIONAL_ROUTINGS FK Joins to TableMTL_SYSTEM_ITEMS_B BOM_OPERATIONAL_ROUTINGS.ASSEMBLY_ITEM_ID
BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID
BOM_OPERATIONAL_ROUTINGS FK Joins to TableBOM_OPERATIONAL_ROUTINGS BOM_OPERATIONAL_ROUTINGS.COMMON_ROUTING_SEQUENCE_ID
BOM_OPERATIONAL_ROUTINGS FK Joins to TableMTL_SECONDARY_INVENTORIES BOM_OPERATIONAL_ROUTINGS.COMPLETION_SUBINVENTORY
BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID
BOM_OPERATIONAL_ROUTINGS FK Joins to TableMTL_ITEM_LOCATIONS BOM_OPERATIONAL_ROUTINGS.COMPLETION_LOCATOR_ID
BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID
BOM_OPERATIONAL_ROUTINGS FK Joins to TableWIP_LINES BOM_OPERATIONAL_ROUTINGS.LINE_ID
TableBOM_DELETE_ENTITIES FK Joins to BOM_OPERATIONAL_ROUTINGS BOM_DELETE_ENTITIES.ROUTING_SEQUENCE_ID
TableBOM_OPERATIONAL_ROUTINGS FK Joins to BOM_OPERATIONAL_ROUTINGS BOM_OPERATIONAL_ROUTINGS.COMMON_ROUTING_SEQUENCE_ID
TableBOM_OPERATION_SEQUENCES FK Joins to BOM_OPERATIONAL_ROUTINGS BOM_OPERATION_SEQUENCES.ROUTING_SEQUENCE_ID
TableWIP_DISCRETE_JOBS FK Joins to BOM_OPERATIONAL_ROUTINGS WIP_DISCRETE_JOBS.COMMON_ROUTING_SEQUENCE_ID
TableWIP_JOB_SCHEDULE_INTERFACE FK Joins to BOM_OPERATIONAL_ROUTINGS WIP_JOB_SCHEDULE_INTERFACE.PRIMARY_ITEM_ID
WIP_JOB_SCHEDULE_INTERFACE.ORGANIZATION_ID
WIP_JOB_SCHEDULE_INTERFACE.ALTERNATE_ROUTING_DESIGNATOR
TableWIP_FLOW_SCHEDULES FK Joins to BOM_OPERATIONAL_ROUTINGS WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID
WIP_FLOW_SCHEDULES.ORGANIZATION_ID
WIP_FLOW_SCHEDULES.ALTERNATE_ROUTING_DESIGNATOR
TableWIP_REPETITIVE_ITEMS FK Joins to BOM_OPERATIONAL_ROUTINGS WIP_REPETITIVE_ITEMS.PRIMARY_ITEM_ID
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID
WIP_REPETITIVE_ITEMS.ALTERNATE_ROUTING_DESIGNATOR
TableWIP_REPETITIVE_SCHEDULES FK Joins to BOM_OPERATIONAL_ROUTINGS WIP_REPETITIVE_SCHEDULES.COMMON_ROUTING_SEQUENCE_ID
TableWSM_LOT_JOB_INTERFACE FK Joins to BOM_OPERATIONAL_ROUTINGS WSM_LOT_JOB_INTERFACE.PRIMARY_ITEM_ID
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID
WSM_LOT_JOB_INTERFACE.ALTERNATE_ROUTING_DESIGNATOR