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_STRUCTURES_B

Product:	BOM - Bills of Material
Description:	Bills of material
Implementation/DBA Data:	BOM.BOM_STRUCTURES_B

Primary Key: BOM_STRUCTURES_B_PK

BILL_SEQUENCE_ID

Primary Key: BOM_STRUCTURES_B_UK1

ASSEMBLY_ITEM_ID
ORGANIZATION_ID
ALTERNATE_BOM_DESIGNATOR

Foreign Keys

Table	Foreign Table	Foreign Key Column
BOM_STRUCTURES_B	MTL_SYSTEM_ITEMS_B	BOM_STRUCTURES_B.ASSEMBLY_ITEM_ID BOM_STRUCTURES_B.ORGANIZATION_ID
BOM_STRUCTURES_B	ENG_ENGINEERING_CHANGES	BOM_STRUCTURES_B.PENDING_FROM_ECN BOM_STRUCTURES_B.ORGANIZATION_ID
BOM_STRUCTURES_B	BOM_ALTERNATE_DESIGNATORS	BOM_STRUCTURES_B.ALTERNATE_BOM_DESIGNATOR BOM_STRUCTURES_B.ORGANIZATION_ID
BOM_STRUCTURES_B	BOM_STRUCTURES_B	BOM_STRUCTURES_B.COMMON_BILL_SEQUENCE_ID
BOM_STRUCTURES_B	MTL_SYSTEM_ITEMS_B	BOM_STRUCTURES_B.COMMON_ASSEMBLY_ITEM_ID BOM_STRUCTURES_B.COMMON_ORGANIZATION_ID
BOM_STRUCTURES_B	HR_ALL_ORGANIZATION_UNITS	BOM_STRUCTURES_B.ORGANIZATION_ID
BOM_COMPONENT_OPERATIONS	BOM_STRUCTURES_B	BOM_COMPONENT_OPERATIONS.BILL_SEQUENCE_ID
BOM_COMPONENTS_B	BOM_STRUCTURES_B	BOM_COMPONENTS_B.BILL_SEQUENCE_ID
BOM_DELETE_ENTITIES	BOM_STRUCTURES_B	BOM_DELETE_ENTITIES.BILL_SEQUENCE_ID
BOM_DEPENDENT_DESC_ELEMENTS	BOM_STRUCTURES_B	BOM_DEPENDENT_DESC_ELEMENTS.BILL_SEQUENCE_ID
BOM_EXPLOSION_TEMP	BOM_STRUCTURES_B	BOM_EXPLOSION_TEMP.TOP_BILL_SEQUENCE_ID
BOM_EXPLOSION_TEMP	BOM_STRUCTURES_B	BOM_EXPLOSION_TEMP.BILL_SEQUENCE_ID
BOM_EXPLOSION_TEMP	BOM_STRUCTURES_B	BOM_EXPLOSION_TEMP.TOP_ITEM_ID BOM_EXPLOSION_TEMP.ORGANIZATION_ID BOM_EXPLOSION_TEMP.TOP_ALTERNATE_DESIGNATOR
BOM_SMALL_EXPL_TEMP	BOM_STRUCTURES_B	BOM_SMALL_EXPL_TEMP.TOP_BILL_SEQUENCE_ID
BOM_SMALL_EXPL_TEMP	BOM_STRUCTURES_B	BOM_SMALL_EXPL_TEMP.BILL_SEQUENCE_ID
BOM_SMALL_EXPL_TEMP	BOM_STRUCTURES_B	BOM_SMALL_EXPL_TEMP.TOP_ITEM_ID BOM_SMALL_EXPL_TEMP.ORGANIZATION_ID BOM_SMALL_EXPL_TEMP.TOP_ALTERNATE_DESIGNATOR
BOM_STRUCTURES_B	BOM_STRUCTURES_B	BOM_STRUCTURES_B.COMMON_BILL_SEQUENCE_ID
ENG_REVISED_ITEMS	BOM_STRUCTURES_B	ENG_REVISED_ITEMS.BILL_SEQUENCE_ID
WIP_DISCRETE_JOBS	BOM_STRUCTURES_B	WIP_DISCRETE_JOBS.COMMON_BOM_SEQUENCE_ID
WIP_JOB_SCHEDULE_INTERFACE	BOM_STRUCTURES_B	WIP_JOB_SCHEDULE_INTERFACE.PRIMARY_ITEM_ID WIP_JOB_SCHEDULE_INTERFACE.ORGANIZATION_ID WIP_JOB_SCHEDULE_INTERFACE.ALTERNATE_BOM_DESIGNATOR
WIP_FLOW_SCHEDULES	BOM_STRUCTURES_B	WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID WIP_FLOW_SCHEDULES.ORGANIZATION_ID WIP_FLOW_SCHEDULES.ALTERNATE_BOM_DESIGNATOR
WIP_REPETITIVE_ITEMS	BOM_STRUCTURES_B	WIP_REPETITIVE_ITEMS.PRIMARY_ITEM_ID WIP_REPETITIVE_ITEMS.ORGANIZATION_ID WIP_REPETITIVE_ITEMS.ALTERNATE_BOM_DESIGNATOR
WIP_REPETITIVE_SCHEDULES	BOM_STRUCTURES_B	WIP_REPETITIVE_SCHEDULES.COMMON_BOM_SEQUENCE_ID