The INVENTORY_ITEM_ID in the MTL_SYSTEM_ITEMS table is system generated. It is the same number as the ASSEMBLY_ITEM_ID in the BOM_BILL_OF_MTLS_INTERFACE the COMPONENT_ITEM_ID in the BOM_INVENTORY_COMPS_INTERFACE table and the SUBSTITUTE_COMPONENT_ID in the BOM_SUB_COMPS_INTERFACE.
The ASSEMBLY_ITEM_ID in the BOM_BILL_OF_MTLS_INTERFACE table is the same number as the ASSEMBLY_ITEM_ID in the BOM_INVENTORY_COMPS_INTERFACE, the
BOM_OP_RESOURCES_INTERFACE, the BOM_OP_SEQUENCES_INTERFACE, and the
BOM_OP_ROUTINGS_INTERFACE tables.
The BILL_SEQUENCE_ID in the BOM_BILL_OF_MTLS_INTERFACE table is system generated. It is the same number as the BILL_SEQUENCE_ID in the BOM_INVENTORY_COMPS_INTERFACE table.
The COMPONENT_SEQUENCE_ID in the BOM_INVENTORY_COMPS table is system generated.The ROUTING_SEQUENCE_ID in the BOM_OP_ROUTINGS_INTERFACE table is the same in the BOM_OP_RESOURCES_INTERFACE and the BOM_OP_SEQUENCES_INTERFACE tables.
The OPERATION_SEQUENCE_ID in the BOM_OP_SEQUENCES_INTERFACE table is the same in the BOM_OP_RESOURCES_INTERFACE table.
If you enter the ORGANIZATION_CODE, Oracle Bills of Materials will fill in the corresponding
ORGANIZATION_ID.
The ASSEMBLY_ITEM_ID in the BOM_BILL_OF_MTLS_INTERFACE table is the same number as the ASSEMBLY_ITEM_ID in the BOM_INVENTORY_COMPS_INTERFACE, the
BOM_OP_RESOURCES_INTERFACE, the BOM_OP_SEQUENCES_INTERFACE, and the
BOM_OP_ROUTINGS_INTERFACE tables.
The BILL_SEQUENCE_ID in the BOM_BILL_OF_MTLS_INTERFACE table is system generated. It is the same number as the BILL_SEQUENCE_ID in the BOM_INVENTORY_COMPS_INTERFACE table.
The COMPONENT_SEQUENCE_ID in the BOM_INVENTORY_COMPS table is system generated.The ROUTING_SEQUENCE_ID in the BOM_OP_ROUTINGS_INTERFACE table is the same in the BOM_OP_RESOURCES_INTERFACE and the BOM_OP_SEQUENCES_INTERFACE tables.
The OPERATION_SEQUENCE_ID in the BOM_OP_SEQUENCES_INTERFACE table is the same in the BOM_OP_RESOURCES_INTERFACE table.
If you enter the ORGANIZATION_CODE, Oracle Bills of Materials will fill in the corresponding
ORGANIZATION_ID.
- If you enter the ITEM_NUMBER, Oracle Bills of Materials will fill in the corresponding ASSEMBLY_ITEM_ID.
- If you enter the LOCATION_NAME , Oracle Bills of Materials will fill in the corresponding SUPPLY_LOCATOR_ID
- If you enter the ASSEMBLY_ITEM_NUMBER, Oracle Bills of Materials will fill in the corresponding ASSEMBLY_ITEM_ID.
- If you enter the SUBSTITUTE_COMP_NUMBER , Oracle Bills of Materials will fill in the corresponding SUBSTITUTE_COMP_ID.
- If you enter the COMPONENT_ITEM_NUMBER, Oracle Bills of Materials will fill in the corresponding COMPONENT_ITEM_ID.
- You can enter the BILL_SEQUENCE_ID, COMPONENT_ITEM_ID, OPERATION_SEQ_NUM, and EFFECTIVITY_DATE instead of COMPONENT_SEQUENCE_ID. The open interfaces will fill in the corresponding COMPONENT_SEQUENCE_ID.
- You can enter ASSEMBLY_ITEM_ID, ORGANIZATION_ID, and ALTERNATE_BOM_DESIGNATOR instead of BILL_SEQUENCE_ID. The open interfaces will fill in the corresponding BILL_SEQUENCE_ID.
- You can enter ASSEMBLY_ITEM_ID, ORGANIZATION_ID, AND ALTERNATE_ROUTING_DESIGNATOR instead of ROUTING_SEQUENCE_ID. Oracle Bills of Material will fill in the corresponding ROUTING_SEQUENCE_ID.
- You can enter ROUTING_SEQUENCE_ID, OPERATION_SEQ_NUM, and EFFECTIVITY_DATE instead of OPERATION_SEQUENCE_ID. Oracle Bills of Materials will fill in the corresponding OPERATION_SEQUENCE_ID.