FND Design Data [Home] [Help]

Table: BOM_OPERATION_SEQUENCES

Product: BOM - Bills of Material
Description: Routing operations
Implementation/DBA Data: TableBOM.BOM_OPERATION_SEQUENCES
Primary Key: BOM_OPERATION_SEQUENCES_PK
  1. ColumnOPERATION_SEQUENCE_ID
Primary Key: BOM_OPERATION_SEQUENCES_UK1
  1. ColumnROUTING_SEQUENCE_ID
  2. ColumnOPERATION_SEQ_NUM
  3. ColumnEFFECTIVITY_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
BOM_OPERATION_SEQUENCES FK Joins to TableBOM_DEPARTMENTS BOM_OPERATION_SEQUENCES.DEPARTMENT_ID
BOM_OPERATION_SEQUENCES FK Joins to TableBOM_OPERATIONAL_ROUTINGS BOM_OPERATION_SEQUENCES.ROUTING_SEQUENCE_ID
BOM_OPERATION_SEQUENCES FK Joins to TableBOM_OPERATION_SEQUENCES BOM_OPERATION_SEQUENCES.PROCESS_OP_SEQ_ID
BOM_OPERATION_SEQUENCES FK Joins to TableBOM_OPERATION_SEQUENCES BOM_OPERATION_SEQUENCES.LINE_OP_SEQ_ID
TableBOM_COMPONENT_OPERATIONS FK Joins to BOM_OPERATION_SEQUENCES BOM_COMPONENT_OPERATIONS.OPERATION_SEQUENCE_ID
TableBOM_DELETE_SUB_ENTITIES FK Joins to BOM_OPERATION_SEQUENCES BOM_DELETE_SUB_ENTITIES.OPERATION_SEQUENCE_ID
TableBOM_OPERATION_NETWORKS FK Joins to BOM_OPERATION_SEQUENCES BOM_OPERATION_NETWORKS.TO_OP_SEQ_ID
TableBOM_OPERATION_RESOURCES FK Joins to BOM_OPERATION_SEQUENCES BOM_OPERATION_RESOURCES.OPERATION_SEQUENCE_ID
TableBOM_OPERATION_SEQUENCES FK Joins to BOM_OPERATION_SEQUENCES BOM_OPERATION_SEQUENCES.PROCESS_OP_SEQ_ID
TableBOM_OPERATION_SEQUENCES FK Joins to BOM_OPERATION_SEQUENCES BOM_OPERATION_SEQUENCES.LINE_OP_SEQ_ID
TableCST_ITEM_COST_DETAILS FK Joins to BOM_OPERATION_SEQUENCES CST_ITEM_COST_DETAILS.OPERATION_SEQUENCE_ID
TableCST_ITEM_CST_DTLS_INTERFACE FK Joins to BOM_OPERATION_SEQUENCES CST_ITEM_CST_DTLS_INTERFACE.OPERATION_SEQUENCE_ID
TableWIP_OPERATIONS FK Joins to BOM_OPERATION_SEQUENCES WIP_OPERATIONS.OPERATION_SEQUENCE_ID